PI66957: CQM ISPF CLIENT DOESN'T SHOW ALL AVAILABLE DATA IN DATASHARING VIEW IN EXCEPTIONS AND SQLCODES PERSPECTIVES WHEN REQUESTS FAIL

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

• Datasharing views show results from multiple requests
  (one request per member). Sometimes one or more requests
  can fail, while others can succeed. Even at least one
  request fails CAE Server doesn't send data to ISPF Client
  in Exceptions and SQLCODES perspectives. CAE Server
  should send all available data from all succeeded member
  and report warning about failed members.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Datasharing views show results from     *
  *                      multiple requests (one request per      *
  *                      member). Sometimes one or more requests *
  *                      can fail, while others can succeed.     *
  *                      Even at least one request fails CAE     *
  *                      Server doesn't send data to ISPF Client *
  *                      in Exceptions and SQLCODES              *
  *                      perspectives. CAE Server should send    *
  *                      all available data from all succeeded   *
  *                      member and report warning about failed  *
  *                      members.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI45127 UI45128

Modules/Macros

• CQM$SQCD CQM$SQCE CQM$SQCL CQM$SQCM CQM$SQCP
  CQM$SQCS CQM$SQC2 CQM$SQC3 CQMBLOB  CQMCAE   CQMCAEPT CQMCAPI
  CQMCPXPT CQMEO    CQMJAR
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI45127

     UP17/03/07 P F703

• R330 PSY UI45128

     UP17/03/07 P F703

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.