DB2 表Reorg Pending狀态異常

1 問題現象

Runstats表的時候抛出sqlcode:-2310,sqlerrmc:-668

2 問題診斷

檢查該表是否處于Reorg Pending狀态

db2 load query table <tabschema>.<tabname>
Tablestate:
    Reorg Pending      

檢查哪些表處于Reorg Pending狀态

db2 "select varchar(tabschema,20),varchar(tabname,40),REORG_PENDING from sysibmadm.admintabinfo where REORG_PENDING='Y'"      

3 問題恢複

需要對該表進行reorg

su - <instancename>
db2 connect to <dbname>
db2 reorg table <tabschema>.<tabname>