PI25569: MSGDSNT376I AND MSGDSNT501I ARE ISSUED WHEN TIME OUT OCCURS INVOLVING RTS DAEMON 014.RTSTST00

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MSGDSNT376I is issued for time out between an application and
  RTS daemon accessing a user database.  MSGDSNT501I follows with
  a reason code 00C9008E.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 customers.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNT376I is issued when an RTS       *
  *                      daemon fails to release a row level     *
  *                      lock on RTS catalog table,              *
  *                      SYSIBM.SYSTABLESPACESTATS or            *
  *                      SYSIBM.SYSINDEXSPACESTATS.              *
  *                      MSGDSNT501I may follow with reason      *
  *                      code 00C9008E.                          *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  DSNT376I with CORRELATION-ID=014.RTSTST00 and DSNT501I
  with RC00C9008E are issued for a time out when an RTS daemon
  fails to release a row level lock on RTS catalog tables
  SYSIBM.SYSTABLESPACESTATS or SYSIBM.SYSINDEXSPACESTATS.
  
  The problem occurs because an internal variable is
  inadvertently set to 'BCT' when it should remain as 'RTS'.
  
  This causes the daemon to not release the lock at a commit.
  Because the RTS daemon continues to hold on to the lock, when
  others attempt to get a lock on the same row, time out occurs
  and the messages are issued.
  
  Additional Keywords: Real-time Statistics
  

Problem conclusion

• The internal variable setting for RTS daemon has been corrected.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI23773 UI23774

Modules/Macros

•    DSNIRTSU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI23773

     UP14/12/30 P F412 Ž

• RB10 PSY UI23774

     UP14/12/30 P F412 Ž

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.