【DB2学习】查看一个数据的表空间详情

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

上一篇:关于直播间源码和直播app开发的基础知识


下一篇:《Effective Debugging:软件和系统调试的66个有效方法》一导读