【DB2學習】顯示錶空間的容器資訊

楊奇龍發表於2010-09-17

LIST TABLESPACE CONTAINERS FOR  tablespace_id  [SHOW DETAIL]
db2 => list tablespace containers for 1 show detail
           表空間 1 的表空間容器
 容器標識                            = 0
 名稱                                = D:\DB2\NODE0000\SAMPLE\T0000001\C0000000.
TMP
 型別                                       = 路徑
 總計頁數                            = 1
 可用頁數                            = 1
 可訪問                              = 是
db2 => list tablespace containers for 2 show detail
            表空間 2 的表空間容器

 容器標識                            = 0
 名稱                                = D:\DB2\NODE0000\SAMPLE\T0000002\C0000000.
LRG
 型別                                       = 檔案
 總計頁數                            = 4096
 可用頁數                            = 4064
 可訪問                              = 是

db2 => list tablespace containers for 3 show detail
            表空間 3 的表空間容器

 容器標識                            = 0
 名稱                                = D:\DB2\NODE0000\SAMPLE\T0000003\C0000000.
LRG
 型別                                       = 檔案
 總計頁數                            = 4096
 可用頁數                            = 4064
 可訪問                              = 是
db2 => list tablespace containers for 5 show detail
            表空間 5 的表空間容器

 容器標識                            = 0
 名稱                                = D:\DB2\NODE0000\SAMPLE\T0000005\C0000000.
UTM
 型別                                       = 路徑
 總計頁數                            = 1
 可用頁數                            = 1
 可訪問                              = 是

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-674263/,如需轉載,請註明出處,否則將追究法律責任。

相關文章