I've been using online reorgs since they became available in DB2 8.1. In fact I use them all the time to keep my client databases tuned and available 24x7, which enables my databases to stay up for many months. Here are some examples:
table reorg:
"db2 reorg table db2admin.accounts inplace allow write access"
Monitor the status of the reorg by using the following command: "db2pd -d mydb -reorgs"
You will see if the reorg is started and how far it is or if it is done.
You can pause an online table reorg and resume it later. Use the following commands: "db2 reorg table db2admin.accounts inplace pause"
"db2 reorg table db2admin.accounts inplace resume"
And you can stop an online reorg by using the stop keyword as follows:
"db2 reorg table db2admin.accounts inplace stop".
A reorg that has been paused may be resumed. A reorg that has been stopped cannot be resumed. In this case you will need to start it again from the beginning.
I have most of my clients setup for weekly reorgs based on the output of reorgchk, although some tables and indexes need them done nightly. If you aren't doing reorgs you need to get going. Hope this helps. Later. Phil
table reorg:
"db2 reorg table db2admin.accounts inplace allow write access"
Monitor the status of the reorg by using the following command: "db2pd -d mydb -reorgs"
You will see if the reorg is started and how far it is or if it is done.
You can pause an online table reorg and resume it later. Use the following commands: "db2 reorg table db2admin.accounts inplace pause"
"db2 reorg table db2admin.accounts inplace resume"
And you can stop an online reorg by using the stop keyword as follows:
"db2 reorg table db2admin.accounts inplace stop".
A reorg that has been paused may be resumed. A reorg that has been stopped cannot be resumed. In this case you will need to start it again from the beginning.
I have most of my clients setup for weekly reorgs based on the output of reorgchk, although some tables and indexes need them done nightly. If you aren't doing reorgs you need to get going. Hope this helps. Later. Phil