Direct link to fix
APAR status
Closed as program error.
Error description
Minor 3.4.0 defect fixes including ODP performance
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor * **************************************************************** * PROBLEM DESCRIPTION: Minor 3.4.0 defect fixes * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** - Minor 3.4.0 defect fixes including ODP performance - Address issue with "$" in userid - Update ISPF settings page for SQL PA integration - Improved zIIP performance for fetch intensive workloads - Address unexpected growth in METRDATA files with Java workload - Add a ++DELETE statement to scrub out LMOD CQM@ITXT
Problem conclusion
Minor defects addressed
Temporary fix
Comments
APAR Information
APAR number
PH58452
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
340
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-11-29
Closed date
2024-01-30
Last modified date
2024-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI95488
Modules/Macros
CQM CQM#EXCP CQM#INIX CQM#IVSM CQM#QAPI CQM#QAPX CQM#QSQL CQM#SSMN CQM#TIAR CQM$$PRM CQM$ABND CQM$ACTV CQM$ADM1 CQM$ADMN CQM$CALL CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2 CQM$DSCV CQM$FILT CQM$FLT2 CQM$FLTC CQM$HSTV CQM$INTD CQM$INTV CQM$OPTN CQM$PRFG CQM$PRFS CQM$PROF CQM$QLCA CQM$RANG CQM$SLIP CQM$SM01 CQM$SM02 CQM$SQLT CQM$TEXT CQM$VSTR CQM$ZCMD CQMBLOB CQMCFPAX CQMCPXPT CQMEOAPI CQMEOSET CQMICSF CQMJAR CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMEMTX CQMMEXXX CQMMFREX CQMMINDX CQMMQAPX CQMMVRFX CQMMZIIP CQMPARMS CQMZEMTR
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R340 PSY UI95488
UP24/02/01 P F401
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"340","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 February 2024