Retrieving catalog information about check pending
The SYSIBM.SYSTABLESPACE table contains information about table spaces that are in check-pending status.
About this task
The SYSIBM.SYSTABLESPACE table indicates that a table space is in check-pending status by a value in column STATUS: P if the entire table space has that status, S if the status has a scope of less than the entire space.
Procedure
To obtain information about table spaces that are in check-pending status:
Query the SYSIBM.SYSTABLESPACE table.
To
list all table spaces whose use is restricted for any reason,
issue this command:
-DISPLAY DATABASE (*) SPACENAM(*) RESTRICTTo retrieve the names of table spaces in check-pending status
only, with the names of the tables they contain, execute:
SELECT A.DBNAME, A.NAME, B.CREATOR, B.NAME
FROM SYSIBM.SYSTABLESPACE A, SYSIBM.SYSTABLES B
WHERE A.DBNAME = B.DBNAME
AND A.NAME = B.TSNAME
AND (A.STATUS = 'P' OR A.STATUS = 'S')
ORDER BY 1, 2, 3, 4;