JR65291: DUPLICATE KEY ERROR ON THE TARGET AFTER FAST LOAD REFRESH USING SELECT STATEMENT WITH CURSOR STABILITY ISOLATION LEVEL ON DB2 Z/

APAR status

• Closed as program error.

Error description

• Duplicate key error on the target after fast load refresh using
  SELECT statement with  cursor stability isolation level on DB2
  z/OS source to Oracle target
  

Local fix

• 1. target CDC datastore parameter:
  use_jdbc_for_refresh=false
  ts_fast_loader_disable_constraint=false
  refresh_allow_fast_loader=true (or not present in MC)
  ts_fast_loader_disable_index=false
  2 manually disable constraint and index
  3 flag table for refresh
  4 start REFRESH
  5 when refresh finishes, execute the following query on Oracle
  DELETE FROM <table>
  WHERE rowid NOT in
  (SELECT MAX(rowid) FROM <table> GROUP BY <keycol1>,<keycol2>...)
  
  6 manually enable constraint and index
  7 start MIRROR
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using IDR             *
  * 11.4.0.4-5679 or older for Oracle as a target datastore.     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Not available                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5680 or newer for Oracle.            *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5680 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

  IDR DB2ZOS REMS

• Fixed component ID

  5737C30DR

Applicable component levels