A fix is available
APAR status
Closed as program error.
Error description
Unexpected CURSOR_NAME can be seen in the table CQM_SQLCODE_DET. Field CURSOR_NAME is filled even when it is just a SELECT and pointing to a cursor_name. Field CURSOR_NAME has different content for executions from the same plan/corrid/package/statement. Field CURSOR_NAME has content that doesn't even exist on the package DBRM referred.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS * * users of component: * * - CQM Data Collector * * - CQM Data Offload and Batch Reporting * * - ISPF Client * **************************************************************** * PROBLEM DESCRIPTION: Unexpected CURSOR_NAME can be seen in * * the table CQM_SQLCODE_DET. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** A residual cursor name could be left in a control block and flow into non-cursor related SQL statement exceptions.
Problem conclusion
Code changed to update cursor name at the end of SQL call. Filtering provided to fill cursor name only for cursor related SQLs. Search Keywords: INCORROUT CURSOR_NAME CQM_SQLCODE_DET
Temporary fix
Comments
APAR Information
APAR number
PH35885
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
330
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-31
Closed date
2021-06-16
Last modified date
2021-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM#BCMX CQM#INIX CQM#PARM CQM#SSMN CQM$ACTV CQMMACTX CQMMCALX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEXCX CQMMEXXX CQMMINDX
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI75914
UP21/06/22 P F106
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.
[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":""},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Document Information
Modified date:
03 July 2021