EDM Pool Statistics Summary by Report Interval
This panel provides an overview of the Environmental Descriptor Manager (EDM) pool activity that was recorded during a series of report intervals.
________________ ZHEDS VTM O2 V540.#P SC11 07/11/16 19:18:55 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.F
> Enter a selection letter on the top line.
>
> A-SUBSYSTEM SUPPORT B-BIND C-BUFFER POOL D-GROUP BP
> E-DISTRIBUTED DATABASE *-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
===============================================================================
> EDM POOL STATISTICS SUMMARY BY REPORT INTERVAL
HEDS
+ Collection Interval: 15 min Start: 07/08 19:00
+ Report Interval: 15 min Combine Level: NONE End: 07/11 19:18
+
+ DBD DBD CT CT PT PT DSC DSC
+ Interval Pages Load% Pages Load% Pages Load% Pages Load%
+ ----------- ----- ----- ----- ----- ----- ----- ----- -----
+ 07/11 19:18 8572 .00% 0 .00% 0 .00% 191 .00%
+ 07/11 19:00 8572 .00% 0 .00% 0 .00% 191 .00%
+ 07/11 18:45 8572 .00% 0 .00% 0 .00% 191 .00%
+ 07/11 18:30 8572 .00% 0 .00% 0 .00% 191 .00%
+ 07/11 18:15 8572 .00% 0 .00% 0 .00% 191 .00%
+ 07/11 18:00 8572 .00% 0 .00% 0 1.30% 191 .50%
+ 07/11 17:45 8572 .00% 0 .00% 0 .00% 177 .00%
+ 07/11 17:30 8572 .00% 0 .00% 0 .00% 177 .00%
+ 07/11 17:15 8572 .00% 0 .00% 0 .00% 177 .00%
+ 07/11 17:00 8572 .00% 0 .00% 0 .00% 177 .00%
+ 07/11 16:45 8572 .00% 0 .00% 0 .00% 177 .00%
+ 07/11 16:30 8572 .66% 0 8.33% 0 1.11% 177 .99%
+ 07/11 16:15 8571 .00% 0 .00% 0 .00% 169 .00%
+ 07/11 16:00 8571 .00% 0 .00% 0 .00% 169 .00%
===============================================================================
Highlighting
The following table shows the
field that might be highlighted in the panel above to indicate the
current status:
| Field | Exception | Reason |
|---|---|---|
| Pages in Use % | EDMU | The utilization of the EDM pool has reached or exceeded the specified threshold. |
Navigation
For additional information about
- a report interval, move the cursor to the required line and press F11 (Zoom). (Each date/time displayed reflects the end of an interval.)
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
- Start
- The start time of the first interval in this display.
- Report Interval
- This field determines the report interval. It is set on the Near-Term History Report Option panel.
- Combine Level
- This field reflects the selected combine level.
If Combine Level is NONE, the report interval is the same as the collection
interval. Possible values:
- HOURLY
- Data will be reported in hourly intervals.
- NONE
- Data will be reported in the time unit specified by the collection interval.
- End
- The end time of the last interval in this display.
- Interval
- Provides the date and time that mark the end of the report interval.
- DBD Pages
- The number of pages used for database descriptors (DBDs).
- DBD Load %
- The percentage of DBD requests that resulted in DBD loads from DASD.
- CT Pages
- The number of pages used for cursor tables (CTs).
- CT Load%
- The percentage of CT requests that resulted in CT loads from DASD.
- PT Pages
- The number of pages used for package tables (PTs).
- PT Load%
- The percentage of PT requests that resulted in PT loads from DASD.
- DSC Loads
- Dynamic SQL caches (DSCs) that had to be loaded from DASD.
- DSC Load%
- The percentage of dynamic SQL cache requests that resulted in DSC loads into pool. This value should be kept low.