Is there any way i can check the status (Check Pending, Copy Pending etc) of the DB2 table space directly using BMC.
My jobs are abending 'coz some of my tables are in Check/Copy pending status. As of now, i'm just trying to load the table using DSNUTILB, and the sysout of the job says the status of the table space.
Instead i want to see directly using BMC, the state of the table space.
Some statuses (including check pending) can be seen in the STATUS column of SYSIBM.SYSTABLESPACE, but the copy pending and some other restricted states are more complicated than looking at any one column in the catalog.
You can issue the
-DISPLAY DATABASE (*) SPACENAM(*) RESTRICT
command to see any tablespace in any database that is in restricted mode. Check the Command Reference manual for command abbreviations and other options of this command.