天天看点

【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

上一篇: ubuntu

继续阅读