VDB29.7 查看一个分区表,表空间和表的ID为负,表空间为空。这是为啥?INVALIDATE_TIME指定为最近时间,如何恢复为VALIDATE(表约10G)?db2 "select char(tbspace,16) as tbspace,tbspaceid,char(tabname,10) as tabname,tableid,card,npages,CREATE_TIME,ALTER_TIME,INVALIDATE_TIME...
显示全部VDB29.7 查看一个分区表,表空间和表的ID为负,表空间为空。这是为啥?INVALIDATE_TIME指定为最近时间,如何恢复为VALIDATE(表约10G)?
db2 "select char(tbspace,16) as tbspace,tbspaceid,char(tabname,10) as tabname,tableid,card,npages,CREATE_TIME,ALTER_TIME,INVALIDATE_TIME from syscat.tables where tabname='RM_PORT'"
TBSPACE TBSPACEID TABNAME TABLEID CARD NPAGES CREATE_TIME ALTER_TIME INVALIDATE_TIME
---------------- --------- ---------- ------- -------------------- -------------------- -------------------------- -------------------------- --------------------------
- -6 RM_PORT -32760 468564027 20390590 2011-11-01-13.34.44.119705 2011-11-01-13.34.44.119705 2014-03-24-05.56.22.961855
收起