PK19475: INCORRECT DDF STATISTICS SUMMARY DISPLAY IN NEAR TERM HISTORY FOR DB2 VERSION 8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INCORRECT HISTORY IN DISTRIBUTED DISPLAY
  
  1. logon Classic
  2. Type H.A.E.
  
  Environment:  z/OS 1.6,  DB2 V8, OM/DB2 V540
  Problem Description:   When going into distributed data, then
  historical the display shows zero for all time periods except
  the current one, and the current time only shows '1' for the #
  of RMTS which is not right.
  
  
   ________________ ZHDFS    VTM     O2       V540./C D81D
  11/21/05 17:43:51   2
  >       Help PF1      Back PF3      Up PF7      Down PF8
  Zoom PF11
  > H.A.E
  >                   Enter a selection letter on the top line.
  >
  > A-SUBSYSTEM SUPPORT      B-BIND              C-BUFFER POOL
  D-GROUP BP
  > *-DISTRIBUTED DATABASE   F-EDM POOL          G-LOG MANAGER
  H-OPEN/CLOSE
  > I-SQL/RID/PARALLEL/PROC  J-LOCK/CLAIM/DRAIN  K-GLOBAL LOCK
  L-DB2 COMMANDS
  > O-OPTIONS
  ================================================================
  ===============
  >       DISTRIBUTED DATA FACILITY STATISTICS SUMMARY BY REPORT
  INTERVAL
   HDFS
  + Collection Interval:   5 min                           Start:
  11/21 12:25
  + Report Interval:       5 min   Combine Level:  NONE      End:
  11/21 17:43
  +
  +             # of  Total  Total  Total  Total  Total  Total
  Total  Total Total
  + Interval    Rmts  Trans    SQL   Rows   Msgs  Bytes Commit
  Abort   Conv Convq
  + ----------- ---- ------ ------ ------ ------ ------ ------
  ----- ------ -----
  + 11/21 17:43    1      5   1870      0   3786   108M      6
  0      5     0
  + 11/21 17:40    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:35    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:30    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:25    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:20    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:15    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:10    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:05    0      0      0      0      0      0      0
  0      0     0
  + 11/21 17:00    0      0      0      0      0      0      0
  0      0     0
  + 11/21 16:55    0      0      0      0      0      0      0
  0      0     0
  + 11/21 16:50    0      0      0      0      0      0      0
  0      0     0
  + 11/21 16:45    0      0      0      0      0      0      0
  0      0     0
  + 11/21 16:40    0      0      0      0      0      0      0
  0      0     0
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDF STATISTICS ARE NOT COLLECTED        *
  *                      CORRECTLY BY NEAR TERM HISTORY FOR      *
  *                      DB2 VERSION 8.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• COLLECT DDF STATISTICS CORRECTLY IN DB2 VERSION 8.
  SYSMOD Title: Various forward fits
  Keywords: INCORROUT NTH DDF STATS NEAR TERM HISTORY ZHDFS
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  OA14350

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    DUMM1KO2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM/

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSN UK13001

     UP06/03/29 P F603

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.