JR61828: CREATE INDEX DDL FAILS IF ITS ALTERED AS UNUSABLE, DURING RULE-BASED REFRESH.

APAR status

• Closed as program error.

Error description

• CREATE INDEX ddl fails if its altered as UNUSABLE, during
  rule-based refresh.
  

Local fix

• Split the CREATE and ALTER, issue ALTER after
  refresh has complete.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using CDC for Oracle as both      *
  * source and target, with rules-based mappings.                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IBM Data Replication for Oracle may fail while refreshing a  *
  * CREATE DDL in rule-based mapping. If the "create index" is   *
  * followed by an "alter index unusable", then CDC fails to     *
  * apply the DDL on target with invalid index error.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5522 or newer for Oracle.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5522 or newer for Oracle resolves
  the issue.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS CDC ORACLE

• Fixed component ID

  5725E30OR

Applicable component levels

• RB33 PSN

     UP

• RB40 PSY

     UP