IBM Support

PH60500: KQQJSTPS MISSING. SDA=Y

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • : Query Monitor / OMEGAMON Db2 integration activation fails when
    SDA is in use.
    (65EA0562.0000-21:kfastinh.c,1114,"KFA_InsertNodestatus")
    Affinity not loaded for node <db2ssid:cqmssid:KQQ> thrunode
    <TR01> affinities <%IBM.KQQ 000000000E0000yA043>. Node Status
    Ignored.
    
    (65EA0562.0001-21:kpxreqhb.cpp,974,"HeartbeatInserter") Remote
    node <db2ssid:cqmssid:KQQ> is ON-LINE.
    
    (65EA07BA.0000-21:kfastinh.c,1114,"KFA_InsertNodestatus")
    Affinity not loaded for node <db2ssid:cqmssid:KQQ> thrunode
    <TR01> affinities <%IBM.KQQ 000000000E0000yA043>. Node Status
    Ignored.
    
    (65EA07BA.0001-21:kpxreqhb.cpp,974,"HeartbeatInserter") Remote
    node <db2ssid:cqmssid:KQQ> is ON-LINE.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM Db2 Query Monitor CAE           *
    ****************************************************************
    KQQJSTPS missing. SDA=Y
    Query Monitor / OMEGAMON Db2 integration activation fails when
    SDA is in use.
    (65EA0562.0000-21:kfastinh.c,1114,"KFA_InsertNodestatus")
    Affinity not loaded for node <db2ssid:cqmssid:KQQ> thrunode
    <TR01> affinities <%IBM.KQQ 000000000E0000yA043>. Node Status
    Ignored.
    (65EA0562.0001-21:kpxreqhb.cpp,974,"HeartbeatInserter") Remote
    node <db2ssid:cqmssid:KQQ> is ON-LINE.
    (65EA07BA.0000-21:kfastinh.c,1114,"KFA_InsertNodestatus")
    Affinity not loaded for node <db2ssid:cqmssid:KQQ> thrunode
    <TR01> affinities <%IBM.KQQ 000000000E0000yA043>. Node Status
    Ignored.
    (65EA07BA.0001-21:kpxreqhb.cpp,974,"HeartbeatInserter")
    Remote node <db2ssid:cqmssid:KQQ> is ON-LINE.
    

Problem conclusion

  • The build was updated to make sure that KQQJSTPS is packaged
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH60500

  • 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-03-21

  • Closed date

    2024-06-19

  • Last modified date

    2024-07-01

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

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

    UI97342

Modules/Macros

  • CQM#QAPI CQM#QAPX CQM#QSQL CQM#RDSC CQM#RDSE CQM#RDSG CQM#RSSC
    CQM#RSSE CQM#RSSG CQM#RSSO CQM#SWTX CQM#UINX CQM$$PRM CQM$SM01
    CQM$SQCM CQMBLOB  CQMCFPAX CQMCPXPT CQMDSC   CQMDSE   CQMDSG
    CQMJAR   CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX
    CQMMEDRX CQMMEDSX CQMMEMTX CQMMQAPX CQMMZIIP CQMPIKEY CQMPRKEY
    CQMPRMCR CQMPROC  CQMSSC   CQMSSE   CQMSSG   CQMSSO   CQMSSV
    CQMSTGOB CQMSTGRL CQMZCALC CQMZEMTR CQMZEXCP CQMZEXCS
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R340 PSY UI97342

       UP24/06/22 P F406

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 July 2024