db2 reorganize a table

Question

When I alter a table in db2, I have to reorganize it so I execute the next query:

Call Sysproc.admin_cmd ('reorg Table myTable');

I m searching an appropriate solution to reorganize a table when it s altered, or reorganize all the schema after making various modifications

Answer 1

You can determine when tables will require a REORG by looking at SYSIBMADM.ADMINTABINFO:

select tabschema, tabname
  from sysibmadm.admintabinfo
 where reorg_pending = 'Y' 

You may also want to look at the NUM_REORG_REC_ALTERS column as this may show you additional tables that don't require reorganization due to various ALTER TABLE statements.