JR61769: IDR FOR DB2LUW MAY FAIL ON TARGET APPLY WITH ERROR SQLCODE -805 (TOO MANY OPEN STATEMENTS)

APAR status

• Closed as program error.

Error description

• IDR FOR DB2LUW MAY FAIL ON TARGET APPLY WITH ERROR SQLCODE -805
  (TOO MANY OPEN STATEMENTS) WHEN REPLICATING DECFLOAT COLUMNS
  THAT HAVE SPECIAL VALUES
  
  Error:
  An SQL exception occurred. SQL error code: '-805'. SQL State:
  51002. Error message: DB2 SQL Error: SQLCODE=-805,
  SQLSTATE=51002, SQLERRMC=NULLID.SYSLH21E 0X5359534C564C3031,
  DRIVER=4.19.72
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients who use CDC for Db2 to replicate  *
  * tables from a Db2 source with Decfloat columns that have     *
  * special values (e.g. NaN (Not a Number)).                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The statements for rows with decfloat special values were    *
  * not being closed, and that resulted in a statement leak.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5521 or newer for Db2.           *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5521 or newer for Db2 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

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels