db2 获取表空间及缓冲池信息
db2 get snapshot for tablespaces on teps > tablespace.info
db2 get snapshot for tables on teps > tables.info
db2 get snapshot for bufferpools on teps > buffer.info
list tablespaces [show detail]
list tablespace containers for 2 [show detail]
查看缓冲池信息
db2 "select * from syscat.bufferpools"
查看那个缓冲池被分配给那个表空间
db2 "select tbspace,bufferpoolid from syscat.tablespaces"
db2 get snapshot for tables on teps > tables.info
db2 get snapshot for bufferpools on teps > buffer.info
list tablespaces [show detail]
list tablespace containers for 2 [show detail]
查看缓冲池信息
db2 "select * from syscat.bufferpools"
查看那个缓冲池被分配给那个表空间
db2 "select tbspace,bufferpoolid from syscat.tablespaces"
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7338183/viewspace-660732/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
db2 dms sms
请登录后发表评论
登录
全部评论
