PH29443: ENABLE INCREMENTAL UPDATES WITH INTEGRATED SYNCHRONIZATION FAILS FOR TABLE WITH DECIMAL COLUMN CREATED IN DB2 V7 OR OLDER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enabling incremental updates in IBM Db2 Analytics Accelerator
  V7.5 with Integrated Synchronization results in
  java.sql.SQLException with DB2 SQL Error: SQLCODE=-604,
  SQLSTATE=42611, SQLERRMC=DEC (0 , 0) on the accelerator when the
  Db2 table has one or more DECIMAL columns which were created in
  Db2 for z/OS version 7 or earlier and not altered since then.
  Db2 for z/OS Integrated Synchronization failed to pass the
  correct precision and scale of the column to the accelerator.
  IDAAV7R5/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 with tables containing                        *
  * DECIMAL columns created in Db2 V7 or older.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * java.sql.SQLException with DB2 SQL                           *
  * Error: SQLCODE=-604, SQLSTATE=42611,                         *
  * SQLERRMC=DEC (0 , 0) on accelerator or                       *
  * Data Gate instance when enabling                             *
  * incremental updates or synchronization                       *
  * for a table with one or more DECIMAL                         *
  * columns created in Db2 V7 or earlier.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Enabling a table for incremental updates to an IBM Db2
  Analytics Accelerator using IBM Integrated Synchronization, or
  adding a table to IBM Db2 for z/OS Data Gate for
  synchronization fails when the table has a DECIMAL column that
  was added in Db2 V7 or older and the column has not been
  altered in Db2 V8 or later.
  DECIMAL columns created in older Db2 versions store the
  precision and scale information in the catalog only and the
  table schema used during the process did not retrieve the
  information from the catalog. When creating the table on the
  accelerator or on the Data Gate instance, creation fails with
  an incorrect data type specification.
  Additional keywords:
  IDAAV7R5/K DATAGATE/K
  

Problem conclusion

• Code has been changed to retrieve PRECISION and SCALE for
  DECIMAL columns from the Db2 catalog when the information is
  not available from the object descriptor (OBD).
  

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:

  UI71815

Modules/Macros

• DSNGDADR DSNIOBDJ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI71815

     UP20/10/07 P F010

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.