JR63704: CDC IS QUERYING MYSQL DATABASE FOR BLOB DATA RATHER THAN READING FROM LOG

APAR status

• Closed as program error.

Error description

• The CDC Replication Engine for MySQL Source queries the database
  when rows with BLOBs are inserted or deleted. The MySQL general
  logs list these "select" queries. The data replicates properly.
  The database queries are not necessary as the MySQL binary log
  contains the data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR 11.4.0.3-5594 *
  * or older for MySql Source, and you replicate tables          *
  * containing BLOB columns.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The CDC Replication Engine for MySQL Sources made            *
  * unnecessary database selects. This has a higher impact on    *
  * the database than reading from the binary log.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5596 or newer for MySQL Source       *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5596 or newer for MySQL Source
  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 CDC MYSQL

• Fixed component ID

  5725E30MY

Applicable component levels