search cancel

REORG INDEX generated twice

book

Article ID: 8727

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS

Issue/Introduction

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

Cause

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.

Environment

CA DB2 tools r19 AND r20

Resolution

Make sure to use r19 modelset with release r19.

Additional Information

Model OREORGIX:

 

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