PH36875: OMEGAMON DB2 INTEGRATION: NULL POINTER EXCEPTION DURING DATASHARING DISCOVERY PROCESS

IBM Db2 Query Monitor for z/OS CAE Browser Client download
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2s, with types marked as "MEMBER" in OMPE collector log are
  not processed correctly by the Query Monitor / OMEGAMON
  integration feature. We see the following message near these
  Db2s in CAE Browser: "not monitored by specified TEMS" resulting
  in no workload activity for these Db2s in the Query Monitor
  embedded 3270 current activity panel.
  A NullPointerException in the CAE Server log during the
  re-discovery process of the DSG members in ITM Agent (for both
  for 4 chars Db2 names and 3 chars Db2 names) results in an
  incorrect host name descriptor of KQQ Agent for 3 char Db2
  names.
  The asynchronous collector thread processing is incorrect for
  DSG members. Requests sent to the CAE Server from OMPE leads to
  "ERROR" in "Active SQL Count" field on OMPE "Acct" panel.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON Db2 integration: null pointer       *
  *                 exception during datasharing discovery       *
  *                 process                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: OMEGAMON integration does not work for  *
  *                      data sharing members having 3           *
  *                      characters in Db2 name.                 *
  *                      NullPointerException is thrown during   *
  *                      re-discovery of ITM Agent.              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Db2s, with types marked as "MEMBER" in OMPE collector log are
  not processed correctly by the Query Monitor / OMEGAMON
  integration feature. The CAE browser shows "not monitored
  by specified TEMS" resulting
  in no workload activity for these Db2s in the Query Monitor
  embedded 3270 current activity panel.
  A NullPointerException in the CAE Server log during the
  re-discovery process of the DSG members in ITM Agent (for both
  for 4 chars Db2 names and 3 chars Db2 names) results in an
  incorrect host name descriptor of KQQ Agent for 3 char Db2
  names.
  The asynchronous collector thread processing is incorrect for
  DSG members. Requests sent to the CAE Server from OMPE leads to
  "ERROR" in "Active SQL Count" field on OMPE "Acct" panel.
  

Problem conclusion

• NullPointerException in ITM Agent discovery was fixed.
  3-character Db2s which belongs to data sharing systems
  are processed correctly by CAE Server.
  

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:

Modules/Macros

• CQM#IDB2 CQM#INIX CQM#PARM CQM#PCIX CQM#QAPI CQM#QAPX CQM#QSQL
  CQM$BUFP CQM$DELY CQM$LOCK CQM$QRPT CQM$SM01 CQM$SM02 CQM$SQLT
  CQM$TEXT CQMBLOB  CQMCAE   CQMCAEPT CQMCAPI  CQMCFPAX CQMCPXPT
  CQMJAR   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI76411

     UP21/08/09 P F107

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.