RCM compare or Alter analyze generates REORG INDEX of every index before any DDL and again in the utility section after DDL
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.
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
Was this information helpful?