A fix is available
APAR status
Closed as new function.
Error description
Db2 can run several parallel children threads to execute one SQL statement. If several of these children threads exceed Alerts thresholds then one Alert will be generated for each such thread. Currently the CAE Server doesn't allow suppressing Responses for children threads. As a result, the CAE Server may execute several times the same Response (sending mail, cancelling threads, submitting JOB and so on) for one actual SQL statement. This is not always the expected behavior and this enhancement provides the ability to suppress Responses for children threads.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Db2 can run several parallel children * * threads to execute one SQL statement. * * If several of these children threads * * exceed Alerts thresholds then one Alert * * will be generated for each such * * thread. Currently the CAE Server * * doesn't allow suppressing Responses for * * children threads. As a result, the CAE * * Server may execute several times the * * same Response (sending mail, * * cancelling threads, submitting JOB and * * so on) for one actual SQL statement. * * This is not always the expected * * behavior and this enhancement provides * * the ability to suppress Responses for * * children threads. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI93444
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-02-06
Closed date
2018-06-05
Last modified date
2018-08-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI56279 UI56280
Modules/Macros
CQMBLOB CQMCAEPT CQMCPXPT CQMICRT CQMJAR CQMMGRT CQMPTFRM CQMUPXCF
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]
Document Information
Modified date:
31 March 2021