A fix is available
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 number
PI25569
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-09-11
Closed date
2014-12-10
Last modified date
2015-01-02
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 April 2020