Displaying the Table Space Exception List
Select the Tablespaces in exception status option on the Operational Assist Menu to display the Table Space Exception List panel, which lists all of the entries in the Database Exception Table (DBET).
Table Space Exception List panel
Command ===> Scroll ===> PAGE
Commands: FILTER
Select the desired table space(s). Then Press Enter.
S=Issue Start L=List Partition Status
SF=Issue Start ForceSP=Issue Stop
Act Database Table Space Status
.. DSN8D81A DSN8S81R AREO*
.. DSN8D81A DSN8S81S AREO*
.. DSN8D81A XPARTS AREO*
******************************* Bottom of data ********************************
From this panel you can issue the following commands against a table space:
- START DATABASE(database) SPACENAME(table space)
- STOP DATABASE(database) SPACENAME(table space)
- START DATABASE(database) SPACENAME(table space) ACCESS(FORCE)
Listing partition status
To list the status of all partitions in a specific table space, perform the following steps:
Type L in the Act field next to a table space and press Enter.
The Table Space Partition Exception List panel is displayed as follows:
Command ===> Scroll ===> CSR
Select the desired table space(s). Then Press Enter.
S=Issue Start SF=Issue Start Force
SP=Issue Stop
Database: DWQADB01 Tablespace: DWQAX02A
Act Partition # Status
.. 1 RBDP
.. 2 RBDP
.. 3 RBDP
..4 RBDP
.. 5 RBDP
.. 6 RBDP
.. 7 RBDP
.. 8 RBDP
..9 RBDP
.. 10 RBDP
.. 11 RBDP
.. 12 RBDP
.. 13 RBDP
Related topic
Table space/partition exception statuses describes the exception statuses for table spaces and partitions.
Status | Description |
|---|---|
ARBDP | The index needs to be rebuilt to improve performance and allow Db2 to select this index for index-only access. |
AREO* | The table space, index, or partition needs to be reorganized for best performance. |
ACHKP | The table space is in an auxiliary check pending state. This status on a table space indicates that CHECK DATA detected one of the following conditions: an orphan or missing LOB an out-of-sync condition between the row in the base table and the LOB in the LOB table space |
AREST | The 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 under way, it should be initiated in one of the following ways: by issuing the RECOVER POSTPONED command by recycling the system with the LBACKOUT=AUTO system parameter |
AUXW | The table space is in an auxiliary warning state. On a LOB table space, this status indicates that one or more LOBs in the LOB table space is invalid. On a base table space, this status indicates that CHECK DATA detected one of the following conditions: an orphan or missing LOB an out-of-sync condition between the row in the base table and the LOB in the LOB table space. |
CHKP | The object (a table space or a partition within a table space) is in CHECK-pending status. |
COPY | The object (a table space or a partition within a table space) is in COPY-pending status. An image copy is required for this object. |
GRECP | The object (a table space, a table space partition, index space, or index space partition) is marked recovery pending because a group buffer pool failed. This status applies only to spaces. It does not apply to databases. See the IBM Db2 Data Sharing reference documentation for information about resolving this restricted status. |
ICOPY | The object (an index space or index partition) is in informational COPY-pending status. |
LPL | The object has pages or ranges of pages that are unavailable because of logical or physical damage. |
LSTOP | The logical partition is stopped. |
PSRBD | The index space is in page set REBUILD-pending status. |
RBDP | The object (an index space, index partition or logical index partition) is in REBUILD-pending status. |
RBDP* | The logical partition of a non-partitioning index is in REBUILD-pending status. The entire index is inaccessible to SQL applications, but only the logical partition needs to be recovered. |
RECP | The object (a table space, table space partition, index space, index partition or logical index partition) is in RECOVER-pending status. |
REFP | The object (a table space, a table space partition, index space, or index space partition) in REFRESH-pending status. For a table space, run LOAD REPLACE or the RECOVER utility to resolve this restricted status, or use the REBUILD INDEX utility to rebuild the index from the data. |
REORP | The object (a table space or table space partition) is in REORG-pending status. |
RESTP | The object is in the RESTART-pending state. Backout activity against the object must be completed using one of the following methods: issuing the RECOVER POSTPONED command recycling the system with the LBACKOUT=AUTO system parameter |
RO | The table space, table space partition, index space, or index space partition is started for read-only activity. |
RW | The table space, table space partition, index space, or index space partition is started for read and write activity. |
STOP | The 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 to indicate the inconsistency. |
STOPP | A stop is pending for the database, table space, table space partition, index space, or index space partition. |
UT | The table space, table space partition, index space, or index space partition is started for utility processing only. |
UTRO | A utility is processing 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 processing 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 | The object has pages or ranges of pages that are unavailable because of physical damage. To reset this flag, you can use either the RECOVER utility with the ERROR RANGE option or the LOAD utility with the REPLACE option. |
Related topic