REORG INDEX generated twice

Document ID : KB000008727
Last Modified Date : 14/02/2018
Show Technical Document Details

RCM compare or Alter analyze generates REORG INDEX of every index before any DDL and again in the utility section after DDL

CA DB2 tools r19 AND r20

This can happen if you use a modelset from r20 with r19 load library.


In r20 model OREORGIX was changed and does not use %PENDDDL and %SQLPOSO to check if -  and where in the flow – the model should be activated.


Make sure to use r19 modelset with release r19.

Additional Information:



This model is used to generate an on-line IBM REORG to materialize the changes and apply the pending definition changes to the catalog and data.  Without this REORG, any subsequently generated table or index DDL that  depends on these  changes being materialized will fail.                


r19 Utilities Referenced by the DEFAULT Model ID

r20 Utilities Referenced by the DEFAULT Model ID