Report output


The following list shows the status codes for display reports and their respective descriptions:
ACHKP (Version 6.0)
Indicates an error in the LOB column of the base table space. The base table space is in the auxiliary CHECK pending restrictive state.
AUXW (Version 6.0)
Either the base table space is in the auxiliary warning advisory state, indicating an error in the LOB column, or the LOB table space is in the auxiliary warning advisory state, indicating an invalid LOB.
CHKP
The object (a table space, a partition within a table space, or an index ) is in the CHECK pending state.
COPY
The object (a table space or a partition within a table space) is in the COPY pending state. An image copy is required for this object.
GRECP
The object is GBP-dependent and a group buffer pool RECOVER is pending.
ICOPY (Version 6.0)
The index space is in the informational COPY pending advisory state.
LPL
The object has entries in the logical page list.
LSTOP
The logical partition of a nonpartitioned index is stopped.
PSRCP
The index space is in a page set RECOVER pending state.
RECP
The object (a table space, table space partition, index space, index partition, or logical index partition) is in the RECOVER pending state.
RECP*
The logical index partition is in the RECOVER pending state, and the entire index is inaccessible to SQL applications. However, only the logical partition needs to be recovered.
REORP (Version 6.0)
The data partition is in the REORG pending state.
REST
The page set or partition is being restarted.
RESTP (Version 6.0)
The table space or index space is in the restart pending state.
RO
The database, table space, table space partition, index space, or index space partition is started for read-only activity.
RW
The database, table space, table space partition, index space, or index space partition is started for read and write activity.
STOP
The database, table space, table space partition, index space or index space partition is stopped.
STOPE
The table space or index space was implicitly stopped because there is a problem with the log RBA in a page. Message DSNT500I or DSNT501I is issued when the error is detected, indicating the inconsistency.
STOPP
A stop is pending for the database, table space, table space partition, index space, or index space partition.
UT
The database, table space, table space partition, index space, or index space partition is started for utility processing only.
UTRO
A utility that allows only RO access is in process on the table space, table space partition, index space or index space partition. If the utility was canceled before the object was drained, the object can allow SQL access because the object was not altered by the utility.
UTRW
A utility that allows RW access is in process on the table space, table space partition, index space or index space partition.
UTUT
A utility that allows only UT access is in process on the table space, table space partition, index space or index space partition. If the utility was canceled before the object was drained, the object can allow SQL access because the object was not altered by the utility.

Sample reports

You can customize the report by selecting different options. These display settings determine the information that the report contains.

Usage setting

This example uses the Usage setting to show information about table space TBS33 in database CB3. Usage displays connection-name(CONNID), correlation-id(CORRID), and authorization ID (USERID) information.
Example:
     DSNT360I - *********************************************************** 
     DSNT361I - *  DISPLAY DATABASE SUMMARY 
                *    GLOBAL USE 
     DSNT360I - *********************************************************** 
     DSNT362I -     DATABASE = CB3  STATUS = RW 
                    DBD LENGTH = 4028 
     DSNT397I - 
     NAME     TYPE PART STATUS             CONNID   CORRID       USERID 
     -------- ---- ---- ------------------ -------- ------------ -------- 
     TBS33    TS    01  RW                 LSS001   DSN2SQL      SYSADM 
     TBS33    TS    02  RW                 LSS001   DSN2SQL      SYSADM 
     TBS33    TS    03  RW                 LSS001   DSN2SQL      SYSADM 
     TBS33    TS    04  RW                 LSS001   DSN2SQL      SYSADM 
     ******* DISPLAY OF DATABASE CB3      ENDED      ********************** 
     DSN9022I . DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION

Locks setting

This display example uses the Locks setting to show information about table space TBS33 in database CB3. Locks displays lock information for table spaces and tables specified; LUWIDs and locations of any remote threads; and connection-name, correlation-id, and authorization ID information.
Example:
     DSNT360I - *********************************************************** 
     DSNT361I - *  DISPLAY DATABASE SUMMARY 
                *    GLOBAL LOCKS 
     DSNT360I - *********************************************************** 
     DSNT362I -     DATABASE = CB3  STATUS = RW 
                    DBD LENGTH = 4028 
     DSNT397I - 
     NAME     TYPE PART STATUS             CONNID   CORRID       LOCKINFO 
     -------- ---- ---- ------------------ -------- ------------ --------- 
     TBS33    TS    01  RW 
     TBS33    TS    02  RW 
     TBS33    TS    03  RW 
     TBS33    TS    04  RW                 LSS004   DSN2SQL      H(IS,S,C) 
     TBS33    TS    04  RW                 LSS005   DSN2SQL      H(IS,S,C) 
     ******* DISPLAY OF DATABASE CB3      ENDED      **********************

Claims setting

This display example uses the Claims setting tp show information about table space TBS33 in database CB3. Claims displays claim types and durations; LUWIDs and locations of any remote threads; and connection-name, correlation-id, and authorization ID information.
Example:
     DSNT360I - *********************************************************** 
     DSNT361I - *  DISPLAY DATABASE SUMMARY 
                *    GLOBAL CLAIMERS 
     DSNT360I - *********************************************************** 
     DSNT362I -     DATABASE = CB3  STATUS = RW 
                    DBD LENGTH = 4028 
     DSNT397I - 
     NAME     TYPE PART STATUS             CONNID   CORRID      CLAIMINFO 
     -------- ---- ---- ------------------ -------- ------------ -------- 
     TBS33    TS    01  RW 
     TBS33    TS    02  RW 
     TBS33    TS    03  RW 
     TBS33    TS    04  RW                 LSS001   DSN2SQL      (RR,C) 
     TBS33    TS    04  RW                 LSS001   DSN2SQL      (WR,C) 
     ******* DISPLAY OF DATABASE CB3      ENDED      *********************

Logical page list entries setting (with limited messages)

This display example uses the the Logical page list entries setting to show information about page sets in database DSNDB01 that have entries in the logical page list. The example also uses the Message limit setting to limit the number of messages returned.
Example:
***********************************************************
DSNT361I -DB1G * DISPLAY DATABASE SUMMARY
* GLOBAL LPL
DSNT360I -DB1G
***********************************************************
DSNT362I -DB1G DATABASE = DSNDB01 STATUS = RW
DBD LENGTH = 8000
DSNT397I -DB1G
NAME TYPE PART STATUS LPL PAGES
-------- ---- ---- ------------------ ------------------
DBD01 TS RW,LPL,GRECP 000001,000004,00000C,000010
---- 000039-00003C
SPT01 TS RW
SCT02 TS RW
SYSLGRNG TS RW
SYSUTILX TS RW
SYSLGRNX TS RW,LPL,GRECP 000000-FFFFFF
DSNSCT02 IX RW
DSNSPT01 IX RW
DSNSPT02 IX RW
DSNLUX01 IX RW
DSNLUX02 IX RW
DSNLLX01 IX RW
DSNLLX02 IX RW
******* DISPLAY OF DATABASE DSNDB01 ENDED **********************
DSN9022I -DB1G DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION
Important:
If the number of messages returned is greater than the specified limit,
then the final lines of the report read:
******* DISPLAY OF DATABASE DSNDB01 ENDED **********************
DSN9022I -DB1G MESSAGE LIMIT EXCEEDED. DISPLAY IS TERMINATED.
DSN9022I -DB1G DSNTDDIS 'DISPLAY DATABASE' ABNORMAL COMPLETION