IBM Support

PH45746: OPTKEY SETTINGS FROM CQMPARMS NOT HONORED WHEN RUNNING WITHOUT APROFILE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The CQMPARMS OPTKEY parameters do not get set when QM is started
    without a monitoring profile
    

Local fix

  • Create a profile and add the MONITOR parameter in CQMPARMS
    similar to the following example:
    MONITOR(DSN,profile)
    or use option 6 in the CQM ISPF interface to change the profile
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Query Monitor                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: OPTKEY settings from CQMPARMS not       *
    *                      honored when running without a profile  *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    OPTKEYS in CQMPARMS ignored if no monitoring profile defined for
    Db2 Subsystem.
    

Problem conclusion

  • OPTKEYS from CQMPARMS always applied prior to processing
    monitor profile.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH45746

  • 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

    2022-04-18

  • Closed date

    2022-06-24

  • Last modified date

    2022-09-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI81169

Modules/Macros

  • CQM#IVSM CQM#MSSP CQM#SSMN CQM$ABND CQM$ACTV CQM$BUFP CQM$CALL
    CQM$CHLP CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2 CQM$DELY CQM$DSCV
    CQM$ERRP CQM$FILT CQM$FLT2 CQM$FLTC CQM$HSTV CQM$INTD CQM$INTV
    CQM$LINK CQM$LOCK CQM$MAIN CQM$OBJS CQM$OPTN CQM$PRFS CQM$PROF
    CQM$QLCA CQM$QRPT CQM$RANG CQM$SLIP CQM$SM01 CQM$SM02 CQM$SMKY
    CQM$SQC2 CQM$SQC3 CQM$SQCD CQM$SQCE CQM$SQCI CQM$SQCL CQM$SQCM
    CQM$SQCP CQM$SQCS CQM$SQLT CQM$TEXT CQM$XQVE CQM$YLOG CQM$YXLG
    CQM$ZCMD CQMBLOB  CQMCFPAX CQMCHMOD CQMCPXPT CQMJAR   CQMMEBCX
    CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX
    CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMOD   CQMPARSE CQMSSV
    CQMUPXPT
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R330 PSY UI81169

       UP22/07/01 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.

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 September 2022