IBM Support

PH70673: MISSING -805 IN SQLCODE REPORTING

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • -805 SQL Code is not captured in IBM CQM for distributed
    connection
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Query Monitor for z/OS          *
    ****************************************************************
    -805 SQL Code is not captured for distributed connection.
    

Problem conclusion

  • The code was updated to improve -805 SQL Code processing.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH70673

  • 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

    2026-03-25

  • Closed date

    2026-04-24

  • Last modified date

    2026-05-02

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

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

Modules/Macros

  • CQM#ALSX CQM#ARCX CQM#BCMX CQM#CIDC CQM#COMX CQM#DRVX CQM#DSPX
    CQM#EXCP CQM#FDSN CQM#INIX CQM#INTX CQM#LCSD CQM#LCSX CQM#LOAX
    CQM#LOGX CQM#PCIX CQM#RCVX CQM#SCLV CQM#SDAQ CQM#SSMN CQM#STLB
    CQM#SWTX CQM#UINX CQM#WDMX CQM#XLVL CQM#XQMX CQM$ADMN CQMC0292
    CQMHSQCE CQMHSQCF CQMHSQCL CQMMACTX CQMMCMDX CQMMECCX CQMMECPX
    CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMEMTX
    CQMMEXCX CQMMEXXX CQMMINIX CQMMMETX CQMMSQLX CQMMSRCX CQMODP
    CQMPARSE CQMTTGEX CQMTTXTX CQMZEMTR CQMZEXCP CQMZEXCS
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R340 PSY UO07586

       UP26/04/28 P F604

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:
02 May 2026