Database Management Reference Manual
Multiwrite Databases Claims and Extracts : User Claims : How to Find Out What You Can Claim
How to Find Out What You Can Claim
This section explains what different users will see as a result of Q CLAIMLIST commands.
For this example, take the case of a database PIPE/PIPE, accessed by USERA, with two extracts. Users USERX1 and USERX2 are working on the extracts.
USERA creates a Pipe and flushes the database back to the owning database, PIPE/PIPE. The results of various Q CLAIMLIST commands by the three Users, together with the extract control commands which they have to give to make the new data available, are shown in the Figure 6:1.: Querying extract claimlists.
Note:
Q CLAIMLIST EXTRACT
tells you what you can flush

Q CLAIMLIST OTHERS
tells you want you can't claim
Figure 6:1.
Querying extract claimlists
When you create an element, AVEVA E3D™ only sees it as a user claim, not an extract claim, until the element is flushed. It will then be reported as an extract claim (as well as a user claim, if it has not been unclaimed).
Note that a change in the claim status of an existing element will be shown by the appropriate Q CLAIMLIST command as soon as appropriate updates take place, but a user will have to GETWORK as usual to see the changes to the MODEL model data.
We recommend that:
•
Before you make a user or extract claim, you should do an EXTRACT REFRESH and GETWORK.
•
If you need to claim many elements to an extract, it improves performance if the elements are claimed in a single command, for example, by using a collection:
EXTRACT CLAIM ALL FROM !COLL
Common Extract Commands
Q DBNAME
Returns the name of the database which you are actually writing to.
Q CLAIMLIST
Outputs a list of all elements currently claimed by yourself:
Q CLAIMLIST OTHE
Outputs a list of all elements currently claimed by other users who are accessing the same DB:
Q CLAIMLIST EXTRACT
Shows the extract claimlist for all the writable extracts in the MDB.
Q CLAIMLIST EXTRACT DB dbname
Shows the extract claimlist for the named extract DB.
Q CLAIMLIST EXTRACT FREE DB dbname
Shows the elements claimed to the current extract and not claimed to another extract or user. That is, the elements which can be released.
Q CLAIMLIST EXTRACT OTHER DB dbname
Shows the elements claimed to the current extract and claimed to another extract or user.
Q CLAIMLIST CONTROL DB dbname
Shows the extract claimlist for a CONTROLLED named extract DB.
Q DBAC
Queries the access mode of the database. DBAC can have the text settings CONTROL, UPDATE or MULTIWRITE.
Q DBCL
Queries the claim mode of the database. DBCL can have the text settings EXPLICIT or IMPLICIT.
Q LCLM
Queries whether or not the current element is claimed by another user. Returns TRUE or FALSE.
Command Syntax:
>-- Q CLAIMLIST --+- OTHER -----.
                  |             |
                  |- EXTRACT ---+- OTHER --.
                  |             |          |
                  |             |- FREE ---|
                  |             |          |
                  |             ‘----------|
                  |                        |
                  |------------------------+-- DB dbname --.
                  |                                        |
                  ‘----------------------------------------+-->
 
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo