PH35805: IBM INTEGRATED SYNCHRONIZATION CANNOT ENABLE REPLICATION FOR TABLE WITH DECIMAL OR TIMESTAMP COLUMNS CREATED PRIOR TO DB2 V4

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enabling a table for replication with IBM Integrated
  Synchronization in IBM Db2 Analytics Accelerator or IBM Db2 for
  z/OS Data Gate may fail if the table was created with a Db2 for
  z/OS version prior to V4 and the table has a DECIMAL or
  a TIMESTAMP column.
  When enabling replication, the table schema is looked up by
  IBM Integrated Synchronization and fails to retrieve the
  information due to missing information in the table OBD.
  
  Additional keywords: IDAAV7R5/K DATAGATE/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who either use                     *
  * IBM Db2 Analytics Accelerator with IBM                       *
  * Integrated Synchronization or IBM Db2 for                    *
  * z/OS Data Gate.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Enabling replication for a table in                          *
  * IBM Db2 Analytics Accelerator or IBM                         *
  * Db2 for z/OS Data Gate may fail if the                       *
  * table has a DECIMAL or TIMESTAMP                             *
  * column and the table was created with                        *
  * a Db2 for z/OS version older than V4.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When enabling replication for a table, the table schema is
  looked up by IBM Integrated Synchronization in Db2 for z/OS in
  the internal object descriptor (OBD). Some information may be
  missing in the OBD because the column was created in earlier
  versions of Db2 for z/OS. The missing data is then read from
  the Db2 catalog. This catalog lookup failed because the creator
  and table name used for the catalog lookup are only present in
  the OBD if the table was created in Db2 for z/OS V4 or newer.
  

Problem conclusion

• Code has been fixed to determine the creator and table name for
  old OBDs from the catalog as well.
  The PTF for this APAR also adds the collection of additional
  diagnostics data for the Integrated Synchronization protocol
  to enhance product serviceability.
  Additional keywords: IDAAV7R5/K DATAGATE/K
  

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:

  UI75070

Modules/Macros

• DSNLJEMG DSNLJMCF DSNLJMLR DSNIOBDJ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI75070

     UP21/05/01 P F104

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.