JR61900: INFOSPHERE DATA REPLICATION FOR ORACLE CAN FAIL TO DECRYPT TRANSACTION ID INFO FROM BEGIN/COMMIT ENTRIES WHEN TDE ENABLED.

APAR status

• Closed as program error.

Error description

• InfoSphere Data Replication for Oracle may not decrypt some of
  the transaction identification information from Begin/commit
  entries from the database logs when TDE is enabled.
  
  This will result in log reading and replication performance
  degredataion and some data not being replicated.
  Performance metrics will show # of open txns continually
  increasing while Log Read slows down.
  
  More evidence of this can be found by setting IIDR engine
  parameter  staging_store_dump_txn_queue_metadata=true,
  restarting the IIDR instance and then  running the
  dmgetstagingstorestatus  command.   This will dump details from
  the transaction queues to the trace_dmts_*  log file.
  Indicators of this are a high # of txns listed and often the
  slot and sequence values being very large and not corresponding
  to information seen from running oracle LOGMiner utility on the
  same file/scn range.
  

Local fix

• NO LOCAL FIX
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using CDC for Oracle as a source  *
  * engine, where the Oracle database uses Oracle Transparent    *
  * Data Encryption.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The CDC for Oracle replication engine was not detecting and  *
  * decrypting certain begin/commit transaction log entries when *
  * TDE was enabled. As a result, the transactions did not       *
  * replicate.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.2-5528 or newer.                       *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.2-5528 or newer resolves this 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

• RB40 PSY

     UP