Quote:
Originally Posted by sabari321
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'"
|
I have some tables where reorgchk determines that a reorg is needed, but this say nothing. I am not sure where this will be useful.
Andy