JR65092: CDC FOR POSTGRESQL SOURCE FAILS TO MIRROR DATA FOR PG DB V9.4

APAR status

• Closed as program error.

Error description

• CDC for PostgreSQL Source fails to mirror data for PG db
  v9.4.
  
  An error occurred while turning on supplemental logging
  for <table_name>
  A SQL exception has occurred. The SQL error
  code is '0'. The SQL state is: 42704.
  The error message
  is:
  ERROR: type "regnamespace" does not exist
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are replicating tables    *
  * from a PostgreSQL v9.4 database.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CDC was attempting to use column regnamespace which was not  *
  * added until PostgreSQL v9.5.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5644 or newer for PostgreSQL.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5644 or newer for PostgreSQL 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 POSTGRE

• Fixed component ID

  5725E30PS

Applicable component levels