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– WarrenTApr 16, 2013 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].– WarrenTApr 16, 2013 at 17:20
Add a comment
|
1 Answer
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'
