A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Certain datasharing group configurations can experience inefficiencies in processing Query Monitor intervals via the INTERVAL command resulting in long response times.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Query Monitor INTERVAL * * command * **************************************************************** Optimize INTERVAL command processing in DSGs
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH57073
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
330
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-09-20
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:
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":"330","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 February 2024