PK45083: ALL ZEROS ON THE STATISTICS FOR THE DYNAMIC SQL CACHE STATISTICS PANEL (EDDT)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ALL ZEROS ON THE STATISTICS FOR THE DYNAMIC SQL CACHE STATISTICS
  PANEL (EDDT)
  
  
  
  
  
  
  SQL Cache Statistics shows zeroes;
  > DYNAMIC SQL CACHE STATISTICS
  >
  > place an 'a' before the EDDT command to get average for times
  and
  counts
  >
  EDDT
  + *
  + Times CPU Elapsed Wait Get- Sync Sync
  + Exec. Time Time Time Pages Reads Writes
  + ------ ------------ ------------ ------------ ------ ------
  ------
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  + 0 00:00:00.000 00:00:00.000 00:00:00.000 0 0 0
  
  
  Also, the Count of Entries is over 60k and that is way off...
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   OMEGAMON Server                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Dynamic SQL Cache Statistics are all    *
  *                      zeros. Monitor trace is being turned    *
  *                      off when a Classic user logs off. On    *
  *                      ZEDDT panel all lines show same data.   *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  When a user logged off of OMEGAMON Classic IFCID 318 was being
  stopped. This causes DB2 to clear all Dynamic SQL Statistics.
  

Problem conclusion

• Leave IFCID 318 trace active. Use correct key to not display
  same row more than once.
  KEYWORDS : Dynamic SQL Statics IFCID 318 316 ZEDDT
  

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:

  UK27514 UK27513

Modules/Macros

•    KO2CCAFA KO2CCAFS KO2CCAF2 KO2CIFIA KO2CIFIS
  KO2CIFI2 KO2ICOLA KO2ICOLS KO2ICOL2 KO2XSY2A KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK27513

     UP07/07/28 P F707

• R410 PSY UK27514

     UP07/07/28 P F707

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.