A fix is available
APAR status
Closed as new function.
Error description
New function toleration support for SQL optimization OEM products. * This enhancement also addresses the following: 1. The valid minumum value for the SMEM_SIZE parameter is increased to 3: Example: SMEM_SIZE(3) - 2. Formatting improvements for message CQM1203I.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Query Monitor Tool. * **************************************************************** * PROBLEM DESCRIPTION: New function toleration support for * * SQL optimization OEM products. * * This enhancement also addresses the * * following: * * 1. The valid minumum value for the * * SMEM_SIZE parameter is increased to 3: * * Example: SMEM_SIZE(3) - * * 2. Formatting improvements for message * * CQM1203I. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Temporary fix
Comments
Apply the PTF.
APAR Information
APAR number
PM63303
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-04-25
Closed date
2012-06-12
Last modified date
2012-07-02
APAR is sysrouted FROM one or more of the following:
PM63301
APAR is sysrouted TO one or more of the following:
UK79509
Modules/Macros
CQM$ABND CQM$ACES CQM#ALSX CQM#ARCX CQM#BCMX CQM#CCSD CQM#CIDC CQM#COMX CQM#CQMA CQM#CQMC CQM#CQMD CQM#CQMI CQM#CQML CQM#CQMR CQM#CQMT CQM#CQM0 CQM#CQ31 CQM#CQ32 CQM#CTLF CQM#DRVX CQM#DSPX CQM#EXCP CQM#FDSN CQM#GPRF CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#LCSD CQM#LCSX CQM#LOAX CQM#LOGX CQM#MAIN CQM#MSIN CQM#MSLC CQM#MSSN CQM#MSSP CQM#MSTB CQM#PARM CQM#PCIQ CQM#PCIX CQM#PCMX CQM#RCVX CQM#RESM CQM#REST CQM#RS1X CQM#RS2X CQM#RS3X CQM#RS4X CQM#RS5X CQM#RS6X CQM#SCLV CQM#SDIR CQM#SDMP CQM#SSCT CQM#SSDM CQM#SSMN CQM#STAB CQM#STLB CQM#SVPX CQM#SWTX CQM#SYSP CQM#UINX CQM#WDMX CQM#XQMX CQMISMAX CQMISMPX CQMISMSX CQMLLOGX CQMMABA1 CQMMAB81 CQMMAB91 CQMMALOX CQMMALRX CQMMAUDX CQMMCALX CQMMCLA1 CQMMCLOX CQMMCL81 CQMMCL91 CQMMCMA1 CQMMCMDX CQMMCMOX CQMMCMXX CQMMCM81 CQMMCM91 CQMMCOA1 CQMMCO81 CQMMCO91 CQMMCRA1 CQMMCR81 CQMMCR91 CQMMC2A1 CQMMC281 CQMMC291 CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEMTX CQMMESA1 CQMMESQX CQMMES81 CQMMES91 CQMMEXCX CQMMEXXX CQMME8CX CQMME8PX CQMME8RX CQMME8SX CQMME9CX CQMME9PX CQMME9RX CQMME9SX CQMMFREX CQMMFRX1 CQMMGNMX CQMMHSTX CQMMHSX9 CQMMINDX CQMMINIX CQMMINST CQMMLCA1 CQMMLC81 CQMMLC91 CQMMLRA1 CQMMLR81 CQMMLR91 CQMMMETX CQMMMFRR CQMMPRA1 CQMMPR81 CQMMPR91 CQMMRRA1 CQMMRR81 CQMMRR91 CQMMSACX CQMMSAPX CQMMSARX CQMMSASX CQMMSCLX CQMMSQA1 CQMMSQLX CQMMSQ81 CQMMSQ91 CQMMSRA1 CQMMSRCX CQMMSRVX CQMMSR81 CQMMSR91 CQMMSSQX CQMMSTRX CQMMS8CX CQMMS8PX CQMMS8RX CQMMS8SX CQMMS9CX CQMMS9PX CQMMS9RX CQMMS9SX CQMMTPA1 CQMMTP81 CQMMTP91 CQMOINIX CQMOINST CQMOREDX CQMOXGAX CQMOXG8X CQMOXG9X CQMPARSE CQMTEDA1 CQMTED81 CQMTED91 CQMTTEX1 CQMTTXTX CQMTXLA1 CQMTXL81 CQMTXL91 CQMWTOMX H238310J
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R310 PSY UK79509
UP12/07/02 P F206
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.1.0"}]
Document Information
Modified date:
17 March 2021