PH60500: KQQJSTPS MISSING. SDA=Y

Obtain the fix for this APAR.

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 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.