PH19094: INVALID %UAT VALUES SHOWN IN OPERATIONAL SUMMARIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Invalid %UAT values shown in Operational Summaries ISPF panel
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION: Invalid %UAT values shown in            *
  *                      Operational Summaries.                  *
  *                                                              *
  *                      NullPointerException displayed in       *
  *                      alerts when SQL text of alert with      *
  *                      built-in administrator user is viewed.  *
  ****************************************************************
  The %UAT parameter indicates the percent of unaccounted time
  (the amount of time not accounted for by SQL calls). This value
  represents the time for which Db2 does not track or report in
  statistics.
  Incorrect calculation caused %UAT to be displayed as greater
  than 100% in ISPF and as negative in CAE.
  
  Attempt to view SQL text and HVs in alerts using built-in
  administator user leads to NullPointerException.
  

Problem conclusion

• Additional verification for incorrect times was added in the
  calculations for %UAT values.
  
  If Text/Host Vars tab in message details window is clicked
  and current user is built-in administrator, additional login
  dialog is displayed.
  
  Search Keywords:
  ABENDC78 %UAT ALERTS HOST VARIABLES
  

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#BCMX CQM#LOAX CQM#QAPI CQM#QAPX CQM#QSQL CQM$BUFP CQM$DELY
  CQM$LOCK CQM$QRPT CQM$SM01 CQM$SM02 CQMBLOB  CQMCAEPT CQMCPXPT
  CQMJAR   CQMPTFRM CQMSSV   CQMSWD   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI68008

     UP20/03/02 P F002

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.