How to monitor a DB2 REORG

Question: How do I monitor a DB2 REORG , such as the following statement?

 reorg table SYSIBM.SYSCOLGROUPS inplace allow write access start

Answer:  Use the  db2pd   REORGS option. An example is :

         db2pd -d MYDB –reorgs

The resultset returns eleven columns. The “status” column –   is useful. It is possible to pause, stop, resume the REORG.   Be careful with STOP , as you cannot resume the REORG and will have to restart.

Some example commands are :

db2 reorg table     SYSIBM.SYSCOLGROUPS    inplace pause
db2 reorg table SYSIBM.SYSCOLGROUPS  inplace resume
db2 reorg table SYSIBM.SYSCOLGROUPS  inplace stop

 Read More on reorg, table truncate and used space

Reorg table DB2

DB2 table reorg and table truncate

DB2 Used Space and REORG