When I alter a table in DB, I need to reorg it:

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

if I had done many modifications, how can I know which tables need a reorg?

  • StackOverflow is for questions about programming problems. Database management questions belong on DBA.stackexchange.com – WarrenT Apr 16 '13 at 16:54
  • Also when asking DB management issues for DB2, please specify which DB2 you are asking about. There are three members of the DB2 family. One for z/OS on mainframes, one for IBM i on Power Systems, and one for Linux, Unix, Windows [LUW]. – WarrenT Apr 16 '13 at 17:20

The reorg is necessary when the table content has changed (lots of inserts, lots of updates, many deletes, a combination of all of that) and you can query which tables need reorganization via 'REORGCHK'



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy