PH21603: USERS OF REPLICATION MAY BE CONFRONTED WITH AN UNEXPECTED OCCURRENCE OF MESSAGE DSNX881I 20E... IN DB2MSTR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using IDAA V5 maintenance level PTF 7 with Replication
  Engine (11.4.0.1.5800), users may see message DSNX881I 20E
  in DB2MSTR containing error message "A SQL EXCEPTION HAS
  OCCURRED. THE SQL ERROR CODE IS 1111." or
  "A SQL EXCEPTION HAS OCCURRED. THE SQL ERROR CODE IS 1100."
  
  These error message are issued erroneously by the replication
  engine inappropriately raising an error in the context of an
  internal event. You may ignore them as the replication
  replication is not impacted at all by the event causing the
  occurrence of the message.
  For IBM support:
  The DSNX881I messages from above are accompanied by message
  "FATAL 1: Connection Terminated - session timeout exceeded" in
  pg.log.
  
  The fix for this issue will be contained in a new version of the
  Replication Engine that will be delivered as separate PTF on top
  of maintenance level V5PTF8.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the replication component of    *
  *                 IBM DB2 Analytics Accelerator for z/OS       *
  *                 Version 5.1                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using IDAA V5 maintenance level    *
  *                      PTF 7 with Replication Engine           *
  *                      (11.4.0.1.5800), users may see message  *
  *                      DSNX881I 20E in DB2MSTR containing      *
  *                      error message "A SQL EXCEPTION HAS      *
  *                      OCCURRED. THE SQL ERROR CODE IS 1111."  *
  *                      or "A SQL EXCEPTION HAS OCCURRED. THE   *
  *                      SQL ERROR CODE IS 1100." Either of the  *
  *                      messages is accompanied  by             *
  *                      These message are issued erroneously    *
  *                      by the replication engine               *
  *                      inappropriately raising an error in     *
  *                      the context of an internal event.       *
  *                      The processing has been improved to no  *
  *                      longer show these messages in the       *
  *                      context of the underlying event.        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  -
  

Problem conclusion

• The problem has been fixed.
  

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:

  UI70469

Modules/Macros

•    AQTPKCFC AQTPKRE0
  

Fix information

• Fixed component name

  IDAA FOR ZOS

• Fixed component ID

  5697AQT00

Applicable component levels

• R510 PSY UI70469

     UP20/07/11 P F007

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.