hi All, can anyone tell me which DB2's system table stores information about dms tablespace containers..exa mple number of used pages, number of freepages etc..
thanks,
sunny
thanks,
sunny
-
-
Try....... db2pd -tablespace -alldbs -
You can try "db2 list tablespaces show detail"
Regards
-- SanjayComment
-
You can also look in syscat.tablespa ces table. This table will have complete information about the tablespaces.
RegardsCode:$ db2 describe table syscat.tablespaces Data type Column Column name schema Data type name Length Scale Nulls ------------------------------- --------- ------------------- ---------- ----- ------ TBSPACE SYSIBM VARCHAR 128 0 No OWNER SYSIBM VARCHAR 128 0 No OWNERTYPE SYSIBM CHARACTER 1 0 No CREATE_TIME SYSIBM TIMESTAMP 10 0 No TBSPACEID SYSIBM INTEGER 4 0 No TBSPACETYPE SYSIBM CHARACTER 1 0 No DATATYPE SYSIBM CHARACTER 1 0 No EXTENTSIZE SYSIBM INTEGER 4 0 No PREFETCHSIZE SYSIBM INTEGER 4 0 No OVERHEAD SYSIBM DOUBLE 8 0 No TRANSFERRATE SYSIBM DOUBLE 8 0 No PAGESIZE SYSIBM INTEGER 4 0 No DBPGNAME SYSIBM VARCHAR 128 0 No BUFFERPOOLID SYSIBM INTEGER 4 0 No DROP_RECOVERY SYSIBM CHARACTER 1 0 No NGNAME SYSIBM VARCHAR 128 0 No DEFINER SYSIBM VARCHAR 128 0 No REMARKS SYSIBM VARCHAR 254 0 Yes 18 record(s) selected.
-- SanjayComment
Comment