How to monitor a DB2 REORG

25 June,2012 by Jack Vamvas

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





Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to monitor a DB2 REORG

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright