【DB2學習】檢視一個資料的表空間詳情

db2 => list tablespaces show detail

           目前資料庫的表空間

 表空間辨別                        = 0

 名稱                       = syscatspace

 類型                                       = 資料庫管理空間

 内容                                = 所有持久資料。正常表空間。

 狀态                   = 0x0000

   詳細解釋：

     正常

 總計頁數                            = 8192

 可用頁數                            = 8188

 已用頁數                            = 7492

 可用頁數                            = 696

 高水位标記（頁）                    = 7492

 頁大小（以位元組計）                  = 8192

 擴充資料塊大小（頁）                = 4

 預取大小（頁）                      = 4

 容器數                                  = 1

 表空間辨別                        = 1

 名稱                       = tempspace1

 類型                                       = 系統管理空間

 内容                                = 系統臨時資料

 總計頁數                            = 1

 可用頁數                            = 1

 已用頁數                            = 1

 可用頁數                            = 不适用

 高水位标記（頁）                    = 不适用

 擴充資料塊大小（頁）                = 32

 預取大小（頁）                      = 32

 表空間辨別                        = 2

 名稱                       = userspace1

 内容                                = 所有持久資料。大型表空間。

 總計頁數                            = 4096

 可用頁數                            = 4064

 已用頁數                            = 1952

 可用頁數                            = 2112

 高水位标記（頁）                    = 1952

 最小恢複時間                            = 2010-09-14-12.33.17.000000

 表空間辨別                        = 3

 名稱                       = ibmdb2samplerel

 已用頁數                            = 736

 可用頁數                            = 3328

 高水位标記（頁）                    = 736

 表空間辨別                        = 4

 名稱                       = systoolspace

 可用頁數                            = 4092

 已用頁數                            = 116

 可用頁數                            = 3976

 高水位标記（頁）                    = 116

 表空間辨別                        = 5

 名稱                       = systoolstmpspace

 内容                                = 使用者臨時資料