Thread: How to I see tables that need reorg?
View Single Post
  #10 (permalink)  
Old 09-07-10, 08:01
sabari321 sabari321 is offline
Registered User
  
Join Date: May 2009
Posts: 3
If its v9.1 you can use following cmd to list the tables needed reorg.

db2 "select TABSCHEMA, TABNAME from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'"
Reply With Quote