Direct link to fix
APAR status
Closed as program error.
Error description
Hostvars are not collected for distributed threads if PLANNAME is not DISTSERV
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS * * users of component: * * - CQM Data Collector * * - Host Variables * * - CQM Data Offload and Batch Reporting * * - Current Activity * * - Data Sharing * * - SQL Text * * - ISPF Client * * - CAE server * * - CAE agent * * - PACKAGE VERSIONS * **************************************************************** * PROBLEM DESCRIPTION: 1. Hostvars are not collected for * * distributed threads if PLANNAME is not * * DISTSERV. * * 2. ABENDS378-1C in at startup resulting * * in MSG CQM1031E and MSG CQM1028E. * * 3. Cursor name may appear incorrectly * * when looking at SQL text or SQLCA in * * SQLCODES and Exceptions. * * 4. Empty Package version for CHILD * * threads for static Parallel Activity. * * 5. Authorization error is raised if * * the user restarts the CAE Server * * and stops one of the CAE Agents. * * 6. Authorization error is appeared in * * the CAE Alerts feature if the user * * restarts the CAE Server and stops one * * of the CAE Agents. * * 7. An empty cursor is N/A in some * * cases in Activity Browser feature. * * 8. The Buffer Pool Hit Ratio field * * is always displayed as "0.00%" in Web * * client since the Java 1.8 has been * * released. * * 9. "Couldn't get SQL text" message * * for some threads in CAE Current * * Activity. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. Query Monitor logic based on an assumption that distributed threads would have only PLANNAME = DISTSERV. 2. ABENDS378-1C happened during Query Monitor restart subsequent to a prior failure to start the Query Monitor master address space. 3. Residual cursor name in a control block not related to SQL statement exceptions. 4. For a child thread, "Package version" should be copied from the original unit work. This problem only affects Current activity. For Summary Exceptions this issue has been fixed earlier. Note: For a "COMMIT" statement, the "Package Version" is blank. 5. Authorization error is raised if the user restarts the CAE Server and stops one of the CAE Agents when in the Activity Browser. The Web Client then prompts the user to login against the stopped CAE Agent that leads to an authorization error. 6. Authorization error appears in the CAE Alerts feature if the user restarts the CAE Server and stops one of the CAE Agents when in the CAE Alerts message board. The Web Client then prompts the user to login against the stopped CAE Agent that leads to an authorization error. 7. The user can see both "N/A" and "Empty" values for "Cursor Name" field in Activity Browser if a cursor name is not specified during a program execution. 8. Incorrect evaluation of the Buffer Pool Hit Ratio field due to some methods logic changes in Java 1.8. 9. Some threads not showing SQL texts in CAE Current Activity in single mode or in data sharing mode in CAE and CQM ISPF.
Problem conclusion
1. Logic updated to be use published Db2 flags. 2. Query Monitor restart logic corrected. 3. Filtering improved to correctly populate cursor name. 4. Algorithms were fixed. 5. Always refresh a system select upon opening a login dialog. Was added an error message when client tries to connect to a closed CAE Agent after the CAE Server restart. 6. A SQLTextException gets thrown if the CAE Server aren't able to reach the CAE Agent with the correct error message. 7. It was decided to align the ISPF and Web Client behavior. Now the user will see only "N/A" value for "Cursor Name" field in Activity Browser if the cursor name is not specified during the program execution. 8. The Java methods have been changed according to Java 1.8 capability. 9. Logic was changed to process SQL texts in CAE single mode, data sharing mode in CAE and CQM ISPF in the same way as single mode in CQM ISPF. Search Keywords: HOSTVARS CICS THREAD Package Version ABEND S378-1C CQM1031E CQM1028E QUERY MONITOR RESTART INCORROUT CURSOR_NAME CQM_SQLCODE_DET CQM132E Authorization error CAE DATASHARING CURRENT ACTIVITY SQL TEXT
Temporary fix
Comments
APAR Information
APAR number
PH37889
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-06-04
Closed date
2021-10-05
Last modified date
2021-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI77449
Modules/Macros
CQM#ALSX CQM#BCMX CQM#CLNR CQM#CQMI CQM#CTLF CQM#DRVX CQM#ERLY CQM#GPRF CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#MSSP CQM#PARM CQM#QAPI CQM#QAPX CQM#QSQL CQM#SCLV CQM#SDAQ CQM#SDIR CQM#SSMN CQM#STAB CQM#SWTX CQM$CALL CQM$OBJS CQM$QLCA CQM$STMT CQM$ZCMD CQM@LSTM CQM@WDB2 CQMBLOB CQMCPXPT CQMEOSHV CQMISMTS CQMJAR CQMMACTX CQMMCALX CQMMCMDX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEMTX CQMMEXCX CQMMEXXX CQMMFREX CQMMFRX1 CQMMINDX CQMMMETX CQMMPGEX CQMMQAPX CQMMSACX CQMMSAPX CQMMSARX CQMMSASX CQMMSBCX CQMMSBPX CQMMSBRX CQMMSBSX CQMMSCCX CQMMSCPX CQMMSCRX CQMMSCSX CQMMSQLX CQMMSRCX CQMMSRVX CQMMVRFX CQMPARSE CQMQSTAT CQMTTGEX CQMTTXTX
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI77449
UP21/10/09 P F110
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.3.0"}]
Document Information
Modified date:
02 November 2021