Table name:SIVIEW.FRLOTNOTE
Index name:siview.IRCAST_LOT
1.runstat
db2 runstats on table SIVIEW.FRLOTNOTE and index all allow write access
2.reorgchk
db2 reorgchk current statistics on table all(or SIVIEW.FRLOTNOTE)
3.reorg
db2 "reorg table SIVIEW.FRCAST_LOT index siview.IRCAST_LOT inplace allow write access"
4.reorg status check
db2pd -d tpas -reorgs |grep FRCAST_LOT
5.reorgchk again(check)
db2 reorgchk current statistics on table all
6.done
No comments:
Post a Comment