If we issue “DIS DB(DXXXXCSE) SPACENAM(*)” DB2 command thru DB2I, we get output something like below.
DSNT360I #DBTX ***********************************
DSNT361I #DBTX * DISPLAY DATABASE SUMMARY
* GLOBAL
DSNT360I #DBTX ***********************************
DSNT362I #DBTX DATABASE = DXXXXCSE STATUS = RW
DBD LENGTH = 1732292
DSNT397I #DBTX
NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE
-------- ---- ----- ----------------- -------- -------- -------- -----
LXXXX001 LS RW
SXXXX001 TS RW
SXXXX002 TS RW
SXXXX003 TS RW
SXXXX004 TS RW
SXXXX005 TS CHKP
SXXXX006 TS RBDP
SXXXX007 TS RW
Some times we may not remember what various status code mean. The below table lists most of the status codes and their meaning.
Status Codes
Code
|
Description
|
ARBDP
|
Indicates that the index should be rebuilt to improve performance and allows the DB2 subsystem to pick this index for index-only access.
|
AREO*
|
Indicates that the table space, index, or partition identified should be reorganized for optimal performance.
|
ACHKP
|
Indicates an error in the LOB column of the base table space. The base table space has the auxiliary CHECK-pending restrictive status.
|
AREST
|
Indicates that an object (a table space, index space, or a physical partition of a table space or index space) is in an advisory RESTART-pending state. If backout activity against the object is not already underway, initiate it either by issuing the RECOVER POSTPONED command, or by recycling the system with the system parameter LBACKOUT=AUTO.
|
AUXW
|
Either the base table space is in the auxiliary warning advisory status, indicating an error in the LOB column, or the LOB table space is in the auxiliary warning advisory status, indicating an invalid LOB.
|
CHKP
|
The object (a table space, a partition within a table space, or an index) is in the CHECK-pending status.
|
COPY
|
The object (a table space or a partition within a table space) is in the COPY-pending status. An image copy is required for this object.
|
GRECP
|
The object is GBP-dependent and a group buffer pool RECOVER is pending.
|
ICOPY
|
The index space is in the informational COPY-pending advisory status.
|
LPL
|
The object has entries in the logical page list.
|
LSTOP
|
The logical partition of a nonpartitioning index is stopped.
|
PSRBD
|
The entire nonpartitioning index space is in a page set REBUILD-pending status.
|
RBDP
|
The physical or logical index partition is in the REBUILD-pending status.
|
RBDP*
|
The logical partition of a nonpartitioning index is in the REBUILD-pending status, and the entire index is inaccessible to SQL applications. However, only the logical partition needs to be rebuilt.
|
RECP
|
The object (a table space, table space partition, index space, index partition, or logical index partition) is in the RECOVER-pending status.
|
REFP
|
The object (a table space, index space, or an index) is in the REFRESH-pending status.
|
RELDP
|
The object has a release dependency.
|
REORP
|
The data partition is in the REORG-pending status.
|
RESTP
|
The table space or index space is in the restart-pending status.
|
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 is in process, on the table space, table space partition, index space, or index space partition, that allows only RO access. 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 is in process, on the table space, table space partition, index space, or index space partition, that allows RW access.
|
UTUT
|
A utility is in process, on the table space, table space partition, index space, or index space partition, that allows only UT access. 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.
|
WEPR
|
Displays write error page range information.
|
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.