JR48259: INDEX WAS NOT DROPPED FOR A PARTITIONED TABLE

Fix list for IBM InfoSphere Change Data Capture

APAR status

• Closed as program error.

Error description

• If target table is an Oracle partitioned table, and fast loader
  is used for refresh, then customer can encounter ORA-26002 error
  during refresh. The event log on target would indicate that the
  index that was dropped before start of refresh was re-enabled
  before the refresh is done
  

Local fix

• set undocumented system parameter
  target_num_refresh_apply_threads to 1 (default is 4 in 10.2)
  

Problem summary

• IIDR 10.2 for Oracle fails refresh operation with ORA-26002
  Oracle error when the target table is a partitioned table and
  fast apply refresh is enabled.
  
  This issue affects users running IIDR 10.2 Interim Fix 2 for
  Oracle Redo or IIDR 10.2 GA for Oracle Trigger.
  

Problem conclusion

• This issue is fixed by applying the following interim fixes
  depending on the IIDR product:
  - IIDR 10.2 Interim Fix 3 for Oracle Redo; or
  - IIDR 10.2 Interim Fix 1 for Oracle Trigger.
  

Temporary fix

• Disable fast apply.
  

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

• RA20 PSY

     UP