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

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 的表空間容器

 名稱                                = d:\db2\node0000\sample\t0000002\c0000000.

lrg

 類型                                       = 檔案

 總計頁數                            = 4096

 可用頁數                            = 4064

db2 => list tablespace containers for 3 show detail

            表空間 3 的表空間容器

 名稱                                = d:\db2\node0000\sample\t0000003\c0000000.

db2 => list tablespace containers for 5 show detail

            表空間 5 的表空間容器

 名稱                                = d:\db2\node0000\sample\t0000005\c0000000.

utm