IBM Support

PQ60068: CQM DISPLAYS INCORRECT STATISTICS, TRUNCATED STATISTICS AND EXTRA CHARACTERS ON DISPLAY PANELS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Correction of incorrect displays of statistics, truncated
    statistics and extra characters on several display panels.
    The problems have been noted on panels CQM$IUDP, CQM$DUDP
    and CQM$DPLM.
    *
    Incorrect display of statistical percentages for detail
    items may exceed 100% and can occur for current and past
    interval data. Display of extra characters and truncation
    of leading digits in very large counts may occur for past
    interval data only
    ADDITIONAL SYMPTOMS
    from PQ60063
    LOOP IN CQM MODULE CQMTTPC CAUSES UNRESOLVED WAIT ON DB2 LOT_ECB
    CAN ALSO CAUSE TSO USER SESSION TO HANG IN SUMMARY MODE.HIGH CSA
    ***
    This APAR circumvents a CICS task's suspension due to an
    extended ECB WAIT on completion of a DSN3TERM call where
    increased CPU usage may be observed.
    This APAR also corrects a loop in CQM module CQMTTPC that
    results in a TSO user hang when viewing Summary activity.
    *
    Keywords: DSN3TERM,  DB2, LOT_ECB, CICS, CQMTTPC
    
    ADDITIONAL SYMPTOMS:
    We have not IPL'd for 10days and are now seeing High CSA
    in the DB2 DIST address space 30-40% of the CPU in the LPAR.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 Query Monitor Users                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Correction of incorrect displays of     *
    *                      statistics, truncated statistics and    *
    *                      extra characters on several display     *
    *                      panels.The problems have been noted on  *
    *                      panels CQM$IUDP, CQM$DUDP and CQM$DPLM. *
    *                      *                                       *
    *                      Incorrect display of statistical        *
    *                      percentages for detail items may        *
    *                      exceed 100% and can occur for           *
    *                      current and past interval data.         *
    *                      Display of extra characters and         *
    *                      truncation of leading digits in very    *
    *                      large counts may occur for past         *
    *                      interval data only                      *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Code changes have been made to correct these problems
    

Problem conclusion

  • APPLY PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PQ60068

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2002-04-12

  • Closed date

    2002-05-21

  • Last modified date

    2002-10-29

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

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

Modules/Macros

  •    CQM$DPLN CQM$DTHR CQM$DUDP CQM$DUPL CQM$DUSM
    CQM$IPLN CQM$MAIN CQM#ALRT CQM#BIND CQM#CMON CQM#EXCP CQM#FILT
    CQM#LOAD CQM#RELD CQM@FTHR CQM@IBUF CQM@INTV CQM@IPLN CQM@ISQL
    CQM@ITHR CQM@IUSM CQM@LDB2 CQM@MINT CQM@NEXT CQM@PREV CQM@SETP
    CQM@UDB2 CQM@WDB2 CQMABHK  CQMBIND7 CQMCHAIN CQMCMDHK CQMCNVHK
    CQMCOMHK CQMCOMM  CQMCOMPC CQMCOMPD CQMCOMPS CQMDDFHK CQMEOTHK
    CQMHOSTV CQMINTVP CQMISQLH CQMMAIN  CQMRECV2 CQMSQLHK CQMSSDIR
    CQMSSTAT CQMTTHK  CQMTTPC  H238110J
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R110 PSY UQ66475

       UP02/06/10 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":"110"}]

Document Information

Modified date:
31 March 2021