EDM Pool Information
This panel provides information about the activity in the EDM pool and its performance.
Depending on the DB2® version that is used, the content of this panel is different.
The following panel shows the display of DB2
10:
________________ ZEDMP VTM O2 V540./C SZ91 07/30/13 2:04:12 2
> Help PF1 Back PF3 Up PF7 Down PF8
> R.C
>
> A-EDM POOL SNAPSHOT H-HISTORICAL
===============================================================================
> EDM POOL INFORMATION
EDMP
+ Collection Interval: REALTIME Start: 07/30 02:04:09
+ Report Interval: 1 sec End: 07/30 02:04:12
+
+ Pool Usage Pages Pct Percent of Total EDM Pool
+ ----------- ------- ---- |---10---20---30---40---50---60---70---80---90--100|
+ DBD Pool: | |
+ Total 25600 100% | |
+ DBD Held 169 1% |> . . . . . . . . . .|
+ Stealable 83 0% | . . . . . . . . . .|
+ Free 25431 99% |------------------------------------------------->|
+ In Use 86 0% | . . . . . . . . . .|
+
+ SKEL Pool: | |
+ Total 25600 100% | |
+ SKCT Held 1 0% | . . . . . . . . . .|
+ SKPT Held 22 0% | . . . . . . . . . .|
+ Stealable 23 0% | . . . . . . . . . .|
+ Free 25577 100% |------------------------------------------------->|
+ In Use 0 0% | . . . . . . . . . .|
+
+ STMT Pool: | |
+ Total 28346 100% | |
+ STMT Held 4 0% | . . . . . . . . . .|
+ Free 28342 100% |------------------------------------------------->|
+ |---10---20---30---40---50---60---70---80---90--100|
+
+
+ xProc Request 0
+ xProc Total Allocation 0
+ Plan Below the Bar Allocation 0
+ Package Below the Bar Allocation 0
+ Plan Above the Bar Allocation 16896
+ Package Above the Bar Allocation 0
+
+ +
+ TOTAL INTERVAL /SECOND /THREAD /COMMIT
+ QUANTITY QUANTITY ( 342) ( 3) ( 28)
+ -------- -------- ------- ------- -------
+
+ Database Descriptor (DBD) Reqs 4827113 108 .32 36.00 3.86
+ DBD Loads 3 0 .00 .00 .00
+ % of DBD Loads from DASD .00% .00% n/c n/c n/c
+
+ Cursor Table (CT) Reqs 149 3 .01 1.00 .11
+ CT Loads 3 0 .00 .00 .00
+ % of CT Loads from DASD 2.01% .00% n/c n/c n/c
+
+ Package Table (PT) Reqs 825 28 .08 9.33 1.00
+ PT Loads 32 0 .00 .00 .00
+ % of PT Loads from DASD 3.88% .00% n/c n/c n/c
+
+ Dynamic Sql (DSC) Reqs 1655 71 .21 23.67 2.54
+ DSC Loads 17 0 .00 .00 .00
+ CATALOG Loads 20 0 .00 .00 .00
+ % of CATALOG Loads into Pool 1.21% .00% n/c n/c n/c
+ % of DSC Loads into Pool 1.03% .00% n/c n/c n/c
+
+ PKG Search Not Found 0 0 .00 .00 .00
+ PKG Search Not Found Insert 0 0 .00 .00 .00
+ PKG Search Not Found Delete 0 0 .00 .00 .00
+ Number of Statements 36 0 .00 .00 .00
===============================================================================The following panel shows the display of DB2 11 and later
versions:
________________ ZEDMP VTM O2 V540./C SE11 07/30/13 1:53:27 2
> Help PF1 Back PF3 Up PF7 Down PF8
> R.C
>
> A-EDM POOL SNAPSHOT H-HISTORICAL
===============================================================================
> EDM POOL INFORMATION
EDMP
+ Collection Interval: REALTIME Start: 07/30 01:41:19
+ Report Interval: 4 sec End: 07/30 01:53:27
+
+ Pool Usage Pages Pct Percent of Total EDM Pool
+ ----------- ------- ---- |---10---20---30---40---50---60---70---80---90--100|
+ DBD Pool: | |
+ Total 25600 100% | |
+ DBD Held 108 0% | . . . . . . . . . .|
+ Stealable 13 0% | . . . . . . . . . .|
+ Free 25492 100% |------------------------------------------------->|
+ In Use 95 0% | . . . . . . . . . .|
+
+ SKEL Pool: | |
+ Total 25600 100% | |
+ SKCT Held 8 0% | . . . . . . . . . .|
+ SKPT Held 124 0% | . . . . . . . . . .|
+ Stealable 132 1% |> . . . . . . . . . .|
+ Free 25468 99% |------------------------------------------------->|
+ In Use 0 0% | . . . . . . . . . .|
+
+ STMT Pool: | |
+ Total 28346 100% | |
+ STMT Held 28338 100% |------------------------------------------------->|
+ Free 8 0% | . . . . . . . . . .|
+ |---10---20---30---40---50---60---70---80---90--100|
+
+
+ Shareable Static SQL Requests 15
+ Total Allocation for Shareable Static SQL 23624
+ Plan Below the Bar Allocation 0
+ Package Below the Bar Allocation 0
+ Plan Above the Bar Allocation 21120
+ Package Above the Bar Allocation 0
+
+ + TOTAL INTERVAL /SECOND /THREAD /COMMIT
+ QUANTITY QUANTITY ( 4) ( 11) ( 10)
+ -------- -------- ------- ------- -------
+ Failures due to DBD Pool Full 0 0 .00 .00 .00 *DB2 11
+ Failures due to STMT Pool Full 0 0 .00 .00 .00 *DB2 11
+ Failures due to SKEL Pool Full 0 0 .00 .00 .00 *DB2 ll
+
+ Database Descriptor (DBD) Reqs 786 36 9.00 3.27 3.60
+ DBD Loads 7 1 .25 .09 .10
+ % of DBD Loads from DASD .89% 2.78% n/c n/c n/c
+
+ Cursor Table (CT) Reqs 304 6 1.50 .55 .60
+ CT Loads 6 0 .00 .00 .00
+ % of CT Loads from DASD 1.97% .00% n/c n/c n/c
+
+ Package Table (PT) Reqs 214 0 .00 .00 .00
+ PT Loads 23 0 .00 .00 .00
+ % of PT Loads from DASD 10.75% .00% n/c n/c n/c
+
+ Dynamic Sql (DSC) Reqs 6024 0 .00 .00 .00
+ DSC Loads 6011 0 .00 .00 .00
+ qisedspl-reqs 75 0 .00 .00 .00
+ qisedspc-rows 1 0 .00 .00 .00
+ qisedspm-text 1 0 .00 .00 .00
+ CATALOG Loads 1 0 .00 .00 .00 *DB2 12
+ % of CATALOG Loads into Pool .00% .00% n/c n/c n/c *DB2 12
+ % of DSC Loads into Pool 99.78% .00% n/c n/c n/c
+ PKG Search Not Found 0 0 .00 .00 .00
+ PKG Search Not Found Insert 0 0 .00 .00 .00
+ PKG Search Not Found Delete 0 0 .00 .00 .00
+ Number of Statements 2583 0 .00 .00 .00
=============================================================================== Highlighting
OMEGAMON® XE for DB2 PE highlights some fields in this panel to
draw your attention to their current status:
| Field | Exception | Reason |
|---|---|---|
| Pages In Use | EDMU | The utilization of the EDM pool has reached or exceeded its threshold. |
| Pct In Use | EDMU | The utilization of the EDM pool has reached or exceeded its threshold. |
Navigation
For additional information about
- the contents of the EDM pool, select option A-EDM Pool Snapshot. For more information, see the description of panel EDM Pool Snapshot Summary.
- the corresponding near-term history display, enter H on the top line and press Enter.
- other topics, use the PF keys.
Fields
- Collection Interval
- In this field, always REALTIME is displayed to indicate that you are looking at the realtime version of this panel instead of the corresponding near-term history panel. On the EDM Pool Information panel, the collection interval and the report interval are the same.
- Start
- The start time of the report interval that is currently displayed.
- Report Interval
- The amount of time in the last cycle, for example, the time between two presses of the Enter key.
- End
- The end time of the report interval that is currently displayed.
- Pool Usage
- The following types of EDM pools are available:
- EDM Database Descriptor (DBD) Pool
- EDM Statement (STMT) Pool
- EDM Skeleton (SKEL) Pool
- Pages
- The number of pages that is dedicated to a particular type of pool usage.
- PCT
- The percentage of the EDM pool dedicated to that type of usage.
- Total
- The total number of pages in this type of type of EDM pool. For DB2 12 the Total Pages is based on DSNZPARM configured Maximum.
- Held
- The number of pages held in this type of type of EDM pool.
- SKCT Held
- Pages held in SKEL pool for skeleton cursor tables.
- DBD Held
- Pages held in DBD pool.
- STMT Held
- Pages held in STMT pool.
- Stealable
- The total number of pages that can be reused.
- Free
- The number of pages currently not used by any object in this type of EDM pool.
- In Use
- The number of pages that are used in this type of EDM pool.
- This applies only to DBD and SKEL pools.
- The percentage of DBD In Use is calculated like this:
The percentage of SKEL in Use is calculated like this:((In Use - Stealable/Reusable)/Total)*100((SKCTs + SKPTs) - Stealable/Reusable)/Total)*100
- xProc Request (QISEKSPG)
- The total number of requests for PROCS.
- This applies to DB2 10.
- xProc Total Allocation (QISEKSPA)
- The total number of pages that are allocated for xPROCS.
- This applies to DB2 10.
- Shareable Static SQL Requests (QISEKSPG)
- The number of shareable static SQL statement requests.
- This applies to DB2 11 or higher.
- Total Allocation Shareable Static SQL (QISEKSPA8)
- The total storage that is allocated to shareable static SQL statements.
- This applies to DB2 11 or higher.
- SKEL Reusable (QISEKLRU)
- The total number of SKPT and SKCT pages that can be reused.
- This applies to DB2 10 or higher.
- DBD Reusable (QISEDLRU)
- The total number of DBD pages that can be reused.
- This applies to DB2 10 or higher.
- Plan Below the Bar Allocation (QISESQCB)
- The amount of storage below the bar that is allocated for plans.
- This applies to DB2 10 or higher.
- Package Below the Bar Allocation (QISESQKB)
- The amount of storage below the bar that is allocated for packages.
- This applies to DB2 10 or higher.
- Plan Above the Bar Allocation (QISESQCA)
- The amount of storage above the bar that is allocated for plans.
- This applies to DB2 10 or higher.
- Package Above the Bar Allocation (QISESQKA)
- The amount of storage above the bar that is allocated for packages.
- This applies to DB2 10 or higher.
For each of the following fields, the following
statistics are provided:
- TOTAL QUANTITY
- The amount of activities that occurred since DB2 is started.
- INTERVAL QUANTITY
- The amount of activities that occur during the interval.
- /SECOND
- Rate per second. The number under /SECOND (in parentheses) is the number of seconds in the interval.
- /THREAD
- Rate per thread. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
- /COMMIT
- Rate per Commit. The number under /COMMIT (in parentheses) is the number of Commit requests (including abort requests) during the interval.
- Failures due to DBD Pool Full
- Failures that occurred because the DBD pool is full. DB2 10 and DB2 11 only.
- Failures due to STMT Pool Full
- Failures that occurred because the STMT pool is full. DB2 10 and DB2 11 only.
- Failures due to SKEL Pool Full
- Failures that occurred because the SKELpool is full. DB2 10 and DB2 11 only.
- Database Descriptor (DBD) Reqs
- Requests for database descriptors.
- DBD Loads
- Database descriptors that have to be loaded from DASD.
- % of DBD Loads from DASD
- The percentage of DBD requests that result in DT loads from DASD.
- This value should be kept low. 20% or lower is considered acceptable.
- Cursor Table (CT) Reqs
- Requests for cursor tables.
- CT Loads
- Cursor tables that have to be loaded from DASD.
- % of CT Loads from DASD
- The percentage of CT requests that resulted in CT loads from DASD.
- This value should be kept low. 20% or lower is considered acceptable.
- Package Table (PT) Reqs
- Requests for package tables.
- PT Loads
- Package tables that had to be loaded from DASD.
- % of PT Loads from DASD
- The percentage of PT requests that result in PT loads from DASD.
- This value should be kept low. 20% or lower is considered acceptable.
- Dynamic SQL (DSC) Reqs
- Requests to cache dynamic SQL.
- DSC Loads
- Dynamic SQL caches that had to be loaded from DASD.
- CATALOG Loads
- Dynamic SQL cache statements that had to be loaded from CATALOG. DB2 12 and later. (Field name:
QISEDPSF)
- % of CATALOG Loads into Pool
The percentage of dynamic SQL cache requests that resulted in CATALOG loads into the EDMpool. The higher the value, the more stabilized queries from catalog are used to avoid full prepare. Formula for calculation: QISEDPSF/QISEDSG. DB2 12 and later.
- % of DSC Loads into pool
- The percentage of dynamic SQL cache requests that result in DSC loads into the EDM pool.
- This value should be kept low. 40% or lower is considered acceptable.
- Number of Statements
- The number of statements in the EDM pool.