【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

 内容                                = 用户临时数据