0x0 Normal
0x1 Quiesced: SHARE
0x2 Quiesced: UPDATE
0x4 Quiesced: EXCLUSIVE
0x8 Load pending
0x10 Delete pending
0x20 Backup pending
0x40 Roll forward in progress
0x80 Roll forward pending
0x100 Restore pending
0x100 Recovery pending (not used)
0x200 Disable pending
0x400 Reorg in progress
0x800 Backup in progress
0x1000 Storage must be defined
0x2000 Restore in progress
0x4000 Offline and not accessible
0x8000 Drop pending
0x2000000 Storage may be defined
0x4000000 StorDef is in 'final' state
0x8000000 StorDef was changed prior to rollforward
0x10000000 DMS rebalancer is active
0x20000000 TBS deletion in progress
0x40000000 TBS creation in progress
0x8 For service use only
ibmxp 回复于:2004-08-05 09:50:54
db2tbst <tablespace state>;
也可以看到解释!
不过还是顶一下!
mymm 回复于:2004-08-07 16:53:17
以前偶也贴过一个,看得明白些!
有些是自己译的,不一定确切,有几个空着的偶也不能解释确切的意思!
如有能补充,非常感谢!
0x0 Normal 正常
0x1 Quiesced: SHARE 静止态共享
0x2 Quiesced: UPDATE 静止态更新
0x4 Quiesced: EXCLUSIVE 静止态排它
0x8 Load pending 载入挂起
0x10 Delete pending 删除挂起
0x20 Backup pending 备份挂起
0x40 Roll forward in progress 正在回滚
0x80 Roll forward pending 回滚挂起
0x100 Restore pending 存储挂起
0x100 Recovery pending (not used) 恢复挂起
0x200 Disable pending
0x400 Reorg in progress 正在重组
0x800 Backup in progress 正在备份
0x1000 Storage must be defined 存储器未被指定
0x2000 Restore in progress 正在恢复
0x4000 Offline and not accessible 表空间不可访问
0x8000 Drop pending 删除挂起
0x2000000 Storage may be defined 存储器需被指定
0x4000000 StorDef is in 'final' state 存储器终止
0x8000000 StorDef was changed prior to 存储器被改变至回滚状态
rollforward
0x10000000 DMS rebalancer is active 表空间的容器重新分布
0x20000000 TBS deletion in progress 表空间删除
0x40000000 TBS creation in progress 表空间建立
0x8 For service use only
没必要记下来,如ibmxp兄所说用db2tbst随时查就可以!
andrewleading_h 回复于:2004-08-13 10:16:34
不错,不错,收藏了...
|