PH06500: SQLCODE911 RC00C9008E TIMEOUT ISSUED INCORRECTLY BY DSNXEAAL SQLERRD1 -130 WITH IMS MPP OR CICS. NO ROLLBACK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IMS MPP application receives -911 RSN 00C9008E incorrectly
  
  When Db2 tries to run a package but failed to load the package
  because of a timeout or deadlock.
  

Local fix

• There is no bypass to this problem. However, timeout or deadlock
  is a timing issue. Rerun the package may not encounter the
  timeout or deadlock, thus the problem is not triggered.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 and 12 for z/OS users             *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE911 is issued incorrectly by     *
  *                      DSNXEAAL when Db2 fails to load a       *
  *                      package for execution due to a timeout  *
  *                      or deadlock.                            *
  *                      There are two problems.                 *
  *                                                              *
  *                      1. SQLCODE911 is issued but the current *
  *                         unit of work is not rolled back.     *
  *                                                              *
  *                      2. IMS did not issue a particular       *
  *                         code/message (U0777) to its          *
  *                         application when timeout or deadlock *
  *                         happens.                             *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  SQLCODE911 is issued incorrectly by DSNXEAAL when Db2 fails to
  load a package for execution due to a timeout or deadlock.
  There are two problems.
  
  1. SQLCODE911 is issued but the current unit of work is not
     rolled back.
  
  2. IMS usually issues a particular error code/message (U0777) to
     its application when a timeout or deadlock happens. However,
     Db2 did not set the appropriate return and reason code for
     IMS to issue U0777.
  

Problem conclusion

• Db2 code has been changed so that SQLCODE913 is issued by
  DSNXEAAL when package loading fails with timeout or deadlock.
  
  After this APAR, CICS and IMS will receive sqlcode -913 for
  timeouts and deadlocks. Other connections (such as batch and
  distributed applications) to Db2 will receive sqlcode -911 for
  timeouts and deadlocks and Db2 drives a rollback.
  
  Additional keywords: SQLCODE913 SQLCODE911
  

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:

  UI61618 UI61624

Modules/Macros

•    DSNXEAAL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI61624

     UP19/03/19 P F903

• RC10 PSY UI61618

     UP19/03/19 P F903

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.