How to run a reorg and runstats online
How to allow write on table during the runstats and reorg for indexes
1 - REORG ONLINE TO ALLOW READ ON TABLE DURING THE REORG
db2 reorg table <table_name> inplace allow read access
2 - REORG ONLINE TO ALLOW READ AND WRITE ON TABLE DURING THE REORG
db2 reorg table <table_name> inplace allow write access
3 - RUNSTATS ONLINE TO ALLOW WRITE ON TABLE DURING THE RUNSTATS
db2 runstats on table <table_name> and indexes all shrlevel change
No comments:
Post a Comment