IBM Support

PH59517: BAD PROGRAM NAMES GENERATED FROM DISTRIBUTED COMMIT/ROLLBACKS CQM1153E RETURN CODE 04 IN OFFLOAD BATCH JOB.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Bad program names generated from distributed commit/rollbacks
    Description: When collecting commit and rollback metrics from
    distributed workloads, bad program names are generated
    affecting offload and possibly other features during Unicode
    conversion
    CQM1153E RETURN CODE 04 in OFFLOAD batch job.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Bad program names generated from distributed commit/rollbacks
    

Problem conclusion

  • Detected a bad program length for commit/rollback
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH59517

  • 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

    2024-01-31

  • Closed date

    2024-02-23

  • Last modified date

    2024-04-01

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

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

Modules/Macros

  • CQM$BUFP CQM$INTV CQM$LINK CQM$MAIN CQM$MALT CQM@LSTM CQM@SETP
    CQM@STX8 CQM@TBL8 CQM@WDB2 CQMBLOB  CQMCAE   CQMCAPI  CQMCFPAX
    CQMCLIST CQMCPXPT CQMCREOR CQMICSF  CQMJAR   CQMMEBCX CQMMEBPX
    CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX
    CQMMEDPX CQMMEDRX CQMMEDSX CQMMSBCX CQMMSBPX CQMMSBRX CQMMSBSX
    CQMMSCCX CQMMSCPX CQMMSCRX CQMMSCSX CQMMSDCX CQMMSDPX CQMMSDRX
    CQMMSDSX CQMODP   CQMUPXPT
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R330 PSY UI95792

       UP24/02/29 P F402

  • R340 PSY UI95793

       UP24/03/12 P F403

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:
04 April 2024