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

楊奇龍發表於2010-09-16

db2 => list tablespaces show detail
           當前資料庫的表空間

 表空間標識                        = 0
 名稱                       = SYSCATSPACE
 型別                                       = 資料庫管理空間
 內容                                = 所有持久資料。常規表空間。
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 8192
 可用頁數                            = 8188
 已用頁數                            = 7492
 可用頁數                            = 696
 高水位標記(頁)                    = 7492
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 4
 預取大小(頁)                      = 4
 容器數                                  = 1

 表空間標識                        = 1
 名稱                       = TEMPSPACE1
 型別                                       = 系統管理空間
 內容                                = 系統臨時資料
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 1
 可用頁數                            = 1
 已用頁數                            = 1
 可用頁數                            = 不適用
 高水位標記(頁)                    = 不適用
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 32
 預取大小(頁)                      = 32
 容器數                                  = 1

 表空間標識                        = 2
 名稱                       = USERSPACE1
 型別                                       = 資料庫管理空間
 內容                                = 所有持久資料。大型表空間。
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 4096
 可用頁數                            = 4064
 已用頁數                            = 1952
 可用頁數                            = 2112
 高水位標記(頁)                    = 1952
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 32
 預取大小(頁)                      = 32
 容器數                                  = 1
 最小恢復時間                            = 2010-09-14-12.33.17.000000

 表空間標識                        = 3
 名稱                       = IBMDB2SAMPLEREL
 型別                                       = 資料庫管理空間
 內容                                = 所有持久資料。大型表空間。
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 4096
 可用頁數                            = 4064
 已用頁數                            = 736
 可用頁數                            = 3328
 高水位標記(頁)                    = 736
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 32
 預取大小(頁)                      = 32
 容器數                                  = 1

 表空間標識                        = 4
 名稱                       = SYSTOOLSPACE
 型別                                       = 資料庫管理空間
 內容                                = 所有持久資料。大型表空間。
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 4096
 可用頁數                            = 4092
 已用頁數                            = 116
 可用頁數                            = 3976
 高水位標記(頁)                    = 116
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 4
 預取大小(頁)                      = 4
 容器數                                  = 1

 表空間標識                        = 5
 名稱                       = SYSTOOLSTMPSPACE
 型別                                       = 系統管理空間
 內容                                = 使用者臨時資料
 狀態                   = 0x0000
   詳細解釋:
     正常
 總計頁數                            = 1
 可用頁數                            = 1
 已用頁數                            = 1
 可用頁數                            = 不適用
 高水位標記(頁)                    = 不適用
 頁大小(以位元組計)                  = 8192
 擴充套件資料塊大小(頁)                = 4
 預取大小(頁)                      = 4
 容器數                                  = 1

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

相關文章