QUERY (Querying)

Q COPIES PIPING/AREA-A

Lists the copies of DB PIPING/AREA-A.

Q LINEWIDTHS

Lists the System defined line widths used in Draft.

Q SET MDB
Q SET TEAM
Q SET DBSET

Queries the set (i.e. current) Team, MDB or Database (DB) Set.

Q MOD DESIGN DRAFT 33

Queries module entries for Model, Draft and module 33.

Q DDL

Gives version number of System DDL.

Q UPGRADE STATUS

Lists the current upgrade version of all DBs in the Project and the upgrade version that the software works on. If DBs are on a lower upgrade version than the software, then the "upgrade required" text accompanies the DB.

Q UPGRADE LIST

Lists all the part upgrades ("item:" in the response) organized per upgrade version.

Q CLAIM SAMPLE/DESI

Outputs information about claimed DBs.

Q NEWREF old-ref

Gives the new reference corresponding to the given old reference.

Q SESSION LAST

Outputs the date, User, and any comments saved with the given session.

Q SESSIONS ON date dbname
Q SESSIONS SINCE n dbname
Q SESSIONS LAST n dbname

Queries session information on a specified DB.

Q SESSIONS SINCE n
Q SESSIONS LAST n
Q SESSIONS ON date

Queries session information on the current DB (i.e. System or Global DB).

Q ACTIVE

Gives the active session number.

Q NACCNT

At a DB element, gives the non-additive changes count. This value increases when a DB is merged, backtracked or reconfigured. This attribute will return the value for the System DB if used at STAT /*S, or in a Global Project, for the Global DB if used at GSTAT /*GS.

Q HCCNT

At a DB element, gives the extract list changes count. This value increases when extracts are inserted or removed.

Note:
The superseded ELCCNT pseudo-attribute is retained as a synonym for HCCNT. HCCNT is available at /*S and /*GS elements as well as at DB elements.

Q CLCCNT

At a DB element, gives the claim list changes count. This value increases when elements are claimed or dropped without other changes to the DB.

Note:
In a Global Project, the above three attributes together with session information can be used to compare the state of the DB at different Locations.

Querying extracts

Q DBNAME

Gives the name of the DB the administrator is actually writing to.

Q CLAIMLIST

Gives a list of User claims in the current DB.

Q CLAIMLIST EXTRACT

Tells the administrator what they can flush.

Q CLAIMLIST OTHERS

Tells the administrator what they can't claim, including User claims and extract claims.

The following options are only available in a Global Project:

Q ADMLOC

Returns the currently administered Location, which may be different from the true current Location.

Q COMMS TO LON

Queries state of comms link to Location LON. (Equivalent to PING.)

Q COMMS LON INPUTPACKETS
Q COMMS LON OUTPUTPACKETS

Queries data from comms link to Location LON: Input or Output Packets.

Q COMMS LON INPUTRequests
Q COMMS LON OUTPUTRequests

Queries data from comms link to named Location: Input or Output Requests.

Q COMMS TO LON PATH

Queries comms routing to Location LON.

Q CURLOC

Returns the true current Location. This command is useful when the administrator is remotely administering another Location: it returns the name of the actual Location where the administrator is working.

Q ISOLAT AT LON

Returns true if the Location LON is isolated.

Q LOCK AT LON

Returns the Project lock at Location LON.

Q PROJ LOCK AT LON

Returns the Project lock at Location LON

Q REMOTE LON SAMPLE/DESI FILEDETAILS

Returns details of the latest session number, compaction number and other file details for the DB at the specified Location. These details are used by the Global daemon when sending a DB update, and can be useful when analyzing the progress of scheduled updates.

Q REMOTE LON SAMPLE/DESI LASTSESSION

Returns session information for the last session of the specified DB at the specified Location. The output is equivalent to that from Q SESSION SAMPLE/DESI at the current Location.

Note:
It is not possible to query sessions other than the latest at a remote Location.

Note:
Q COMMS, Q ISOLAT and Q PROJ LOCK are now available in other modules such as Model.

The following attributes are also useful:

At a LOC element:

Q DBALL

Lists the allocated DBs.

Q DBPRIM

Lists the Primary DBs.

At a DB element:

Q DBLC

Lists the Locations where it is allocated.

At either DB or LOC:

Q PRMLOC

Indicates its Primary Location.

The following options are only available in a Global Project at the Hub:

The daemons must be running.

Q READERS HVAC/HVAC AT CAM

Outputs a list of readers of DB HVAC/HVAC at Location CAM.

Q READERS HVAC/HVAC AT CAM COUNT

Outputs a count of readers of DB HVAC/HVAC at Location CAM.

Q WRITERS HVAC/HVAC AT CAM

Outputs a list of writers to DB HVAC/HVAC at Location CAM.

Q WRITERS HVAC/HVAC AT CAM COUNT

Outputs a count of writers to DB HVAC/HVAC at Location CAM.

>- Q --+- Authuser -------.
       |                  |
       |- Authentication -|
       |                  |
       |--- USer ---------|
       |                  |
       |--- TEam ---------+--- word ------------------.
       |                                              |
       |--- DB -------.                               |
       |              |                               |
       |--- COpies ---+--- dbname --------------------|
       |                                              |
       |--- DBNO dbno --------------------------------|
       |                                              |
       |--- MDB name ---------------------------------|
       |                                              |
       |                .-------<-----.               |
       |               /              |               |
       |--- MOdule ---*--- integer ---|               |
       |              |               |               |
       |              ‘--- word ------+---------------|
       |                                              |
       |--- LOck -------------------------------------|
       |                                              |
       |--- DDL --------------------------------------|
       |                                              |
       |--- SET ---+--- TEam -------------------------|
       |           |                                  |
       |           |--- DBSet ------------------------|
       |           |                                  |
       |           ‘--- MDB --------------------------|
       |                                              |
       |--- Project ----------------------------------|
       |                                              |
       |--- SESSIONS --+-- SINCE --.                  |
       |               |           |                  |
       |               |-- LAST ---+- n --+-----------|
       |               |                  |           |
       |               ‘—- ON <date> -----+-dbname ---|
       |                                              |
       |--- CLAIM dbname -----------------------------|
       |                                              |
       |--- PASSWORDLOCK -----------------------------|
       |                                              |
       |--- NEWREF oldref ----------------------------|
       |                                              |
       |--- MAXUSers ---------------------------------|
       |                                              |
       |--- ACTIVE -----------------------------------|
       |                                              |
       |--- MACRO n ----------------------------------|
       |                                              |
       ‘--- INFOrmation --+--- dbname ----------------|
                          |                           |
                          ‘--- SYSTEM ----------------+--->

>--- Q COMMS ---+--- TO ---.
                |          |
                ‘----------+--- <loc> ---+--- INPUTPackets ----.
                                         |                     |
                                         |--- OUTPUTPackets ---|
                                         |                     |
                                         |--- INPUTRequests ---|
                                         |                     |
                                         |--- OUTPUTRequest ---|
                                         |                     |
                                         |--- PATH ------------|
                                         |                     |
                                         ‘---------------------+-->

>--- Q ADMLOC --->

>--- Q CURLOC --->

>--- Q ISOLAT AT <loc> --->

>--- Q LOCK AT <loc> --->

>--- Q --+-- READERS --.

>--- Q COMMS ---+--- TO ---.
                |          |
                ‘----------+--- <loc> ---+--- INPUTPackets ----.
                                         |                     |
                                         |--- OUTPUTPackets ---|
                                         |                     |
                                         |--- INPUTRequests ---|
                                         |                     |
                                         |--- OUTPUTRequest ---|
                                         |                     |
                                         |--- PATH ------------|
                                         |                     |
                                         ‘---------------------+-->

>--- Q ADMLOC --->

>--- Q CURLOC --->

>--- Q ISOLAT AT <loc> --->

>--- Q LOCK AT <loc> --->

>--- Q --+-- READERS --. 
         |             |
         ‘-- WRITERS --+- <dbname> --.
                       |             |
                       ‘-------------+--- AT <loc> --.
                                     |               |
                                     ‘---------------+-- COUNT --.
                                                     |           |
                                                     ‘-----------+-->