JR61947: SQLNONTRANSIENTCONNECTIONEXCEPTION IN LOG PARSER WHEN PARSING FIRST CHANGES FOR TWO TABLES SEPARATED BY MORE THAN IDTHOIN SECS

APAR status

• Closed as program error.

Error description

• Log parser error  :
  "java.sql.SQLNonTransientConnectionException [CDC][DB2 JDBC
  Driver]No more data available to read".
  This indicates that the connection was closed.
  
  Addressed SQLNonTransientConnectionException in the log parser
  when parsing the first changes for two tables separated by more
  than the IDLE THREAD TIMEOUT (IDTHTOIN) seconds
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using IBM Data Replication CDC    *
  * Db2 for z/OS remote source, and are starting to replicate    *
  * new subscriptions.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This issue causes a subscription to end on error. It happens *
  * when the CDC Db2 for z/OS remote source engine log reader is *
  * parsing the first set of changes for two tables where        *
  * changes happened after an elapsed time that is longer than   *
  * the configured idle thread timeout interval (IDTHTOIN).      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5528 for Db2 for z/OS remote     *
  * source.                                                      *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5528 for Db2 for z/OS remote
  source resolves this 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 DB2ZOS REMS

• Fixed component ID

  5737C30DR

Applicable component levels