SELECT TABSCHEMA, TABNAME FROM SYSIBMADM.ADMINTABINFO WHERE REORG_PENDING = 'Y' WITH UR
to find tables that need REORG.
This SQL works fine, except it runs for about 5 minuts on a database with couple of thousend tables.
Is there a faster way to get tables that need REORG?
SystemAdmin 110000D4XK5837 Posts
Re: Find table that need REORG2012-07-27T13:20:27ZThis is the accepted answer. This is the accepted answer.Hello Kovi,
Tables in Reorg Pending State cannot be accessed before a REORG is performed: this happens for example when you drop a column. Many other tables might need a Reorg even if they are not in Reorg Pending State.
The command reorgchk which checks the need for a reorg. You can also let DB2 handle this automatically by means of Automatic Maintenance.