Query the status for one specified tablespace?
As we know, we could issue following command to query status for all of tablespaces in...
As we know, we could issue following command to query status for all of tablespaces in current connected DB.
$ db2 list tablespaces show detail > /tmp/ts.list
Then find the status for the tablespaces we concerned.
Is there's a way to query the status for one specified tablespace?
My answer is No.
- First, I don't find the related column defination in the table or view:
- sysibm.systablespaces
- syscat.tablespaces
- Second, I don't think DB2 stores the status flag within syscata tables. The reason is that once a tablespace comes into a special status, it will not be allowed changing any longer(this may also happen on a system catalog tablespace.) that will lead to a conflict on changing the tablespace status flag if stores it within system catalog tables.
