A fix is available
APAR status
Closed as program error.
Error description
The following ABEND may occur in the DB2 DBM1 Address Space: ABND= 0C4 -00000011,U=ISLK,M=(N),C=910.TMGR-DSNTTRUN,M=DSNTFRCV, PSW = 077C2001B070316E,A=009A ADDITIONAL SYMPTOMS SQLCODE904 RC00E30100 The APAR resolves an error in CQM where CQM is monitoring a child task and an unexpected condition occurs. This condition was handled incorrectly and this resulted in the -904 in DB2. With the APAR applied the child task monitor data will be collected correctly and the -904 error will not occur.
Local fix
Add PARALLEL(N) to the CQMPARMS parameter file (recycle the CQM Collector started task to pick up the parameter change). Parameter description: The PARALLEL parameter enables you to control the collection of parallel task metrics for workloads using parallelism. The default value PARALLEL(Y) collects task metrics for both parent and child tasks. Specifying PARALLEL(N) excludes child tasks from the collection of parallel task metrics, however the parent task is still monitored.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: The following ABEND may occur in the * * DB2 DBM1 Address Space: * * ABND= 0C4 -00000011,U=ISLK,M=(N), * * C=910.TMGR-DSNTTRUN,M=DSNTFRCV, * * PSW = 077C2001B070316E,A=009A * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI12910
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-03-03
Closed date
2014-03-26
Last modified date
2015-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI16438 UI16439
Modules/Macros
CQMMPRA1 CQMMPRB1 CQMMPR81 CQMMPR91
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 December 2020