A fix is available
APAR status
Closed as program error.
Error description
SQL statements with comments and newline characters causing issues when exporting statement SQLPA
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: USERS of IBM Db2 Query Monitor for z/OS * * users of component: * * - SQL Text * * - CAE Server * * - CAE QM Subsys Mgmt * * - Profiles * **************************************************************** * PROBLEM DESCRIPTION: 1. SQL statements with comments and * * newline characters are causing issues * * when exporting SQLPA statement. * * 2. ANOTHER REQUEST ACTIVE message * * during Deactivate monitoring or Refresh * * profile. * * 3. NullPointerException may be thrown * * for some CAE Agents during the first * * discovery process (during WAN file * * creation). * * 4. Instead of the warning message * * "Unable to connect to CAE Agent" * * in Activity Browser, the logon dialog * * appears for the user. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** 1. SQL text can have comments inside of it if there is a newline character at the end of every comment. Query Monitor replaced newline characters with blanks during displaying therefore SQLPA failed when trying to read this SQLs. 2. "CQMC2500E:CAE agent: ANOTHER REQUEST ACTIVE..." error message appears in QM Subsystem Management during Deactivate monitoring or Refresh profile for Db2 if it is done directly after start and before viewing any profile. 3. Incomplete synchronization between adding WAN and adding CAE Agents to map. As a result, race condition is raised. 4. Logon dialog appears for the user if they logon to a different LPAR, but he looks at statistics on another LPAR. At this moment the CAE Agent was stopped. Instead the Web Client should show "Unable to connect to CAE Agent" warning message.
Problem conclusion
1. Logic was corrected to keep newline characters during exporting SQL into SQLPA. 2. The checks were done incorrectly and required an internal structure which did not exist for Deactivate monitoring or Refresh profile. The checks were corrected. 3. Better synchronization has been implemented in order to fix the race condition between adding a new WAN and the CAE Agents into the map. 4. "Unable to connect to CAE Agent" warning message is shown in case the CAE Agent was stopped for some reason. Search Keywords: SQLPA FAILS SQL WITH COMMENTS ANOTHER REQUEST ACTIVE CAE DEACTIVATE REFRESH
Temporary fix
Comments
APAR Information
APAR number
PH37434
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-05-21
Closed date
2021-07-22
Last modified date
2021-08-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PH39110 UI76411
Modules/Macros
CQM#IDB2 CQM#INIX CQM#PARM CQM#PCIX CQM#QAPI CQM#QAPX CQM#QSQL CQM$BUFP CQM$DELY CQM$LOCK CQM$QRPT CQM$SM01 CQM$SM02 CQM$SQLT CQM$TEXT CQMBLOB CQMCAE CQMCAEPT CQMCAPI CQMCFPAX CQMCPXPT CQMJAR CQMUPXPT
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI76411
UP21/07/27 P F107
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:
10 August 2021