Use the EDM Pool window to examine statistics on the efficiency
of the EDM buffer pool, and to determine the size of the EDM pool
for optimum system performance.
To display this window, select EDM Pool from the DB2® Statistics Detail panel. Figure 1. EDM Pool
window
DGOMSWEP EDM Pool
INTERVAL 3:32.419
More: - +
Requests for CT sections . . . . . . . . . . : 89
CT section not found in EDM pool . . . . . . : 12
CT requests/CT not in EDM pool . . . . . . . : 7.4
Requests for PT sections . . . . . . . . . . : 16
PT section not found in EDM pool . . . . . . : 9
PT requests/PT not in EDM pool . . . . . . . : 1.8
Requests for DBD sections . . . . . . . . . : 137
DBD section not found in EDM pool . . . . . : 5
DBD requests/DBD not in EDM pool . . . . . . : 27.4
EDM Pool full . . . . . . . . . . . . . . . : 0
EDM Pool pages in use (%) . . . . . . . . . : 1.6
Pages in EDM pool . . . . . . . . . . . . . : 1425
Free pages in free chain . . . . . . . . . . : 1402
Pages used for CT . . . . . . . . . . . . . : 1
Pages used for SKCT . . . . . . . . . . . . : 9
Pages used for PT . . . . . . . . . . . . . : 0
Pages used for SKPT . . . . . . . . . . . . : 4
Pages used for DBD . . . . . . . . . . . . . : 9
Inserts for dynamic cache . . . . . . . . . : 91381
Requests for dynamic cache section . . . . . : 117202
Pages used cache . . . . . . . . . . . . . . : 1310
Command ===> ________________________________________
F1=Help F2=Split F3=Exit F5=Auto
F6=History F7=Up F8=Down F9=Swap
F10=Delta F11=Interval F12=Cancel F16=Look
F17=Collect
The EDM pool size should be large enough to store the cursor tables
(CTs), package tables (PTs), and database descriptors (DBDs) for the
most frequently used applications.
The following list describes some of the important
fields that are shown in this panel:
EDM Pool pages in use (%)
The percentage of the EDM pool pages that are in use. If this
percentage is consistently less than 50%, the EDM pool size is probably
too large. The size can be reduced without affecting the efficiency
ratios (CT requests/CT not in EDM pool, PT
requests/PT not in EDM pool, and DBD requests/DBD
not in EDM pool) significantly. However, driving the EDM
pool toward 100% usage can cause performance problems.
EDM pool
use varies during the day. It is not only the pages that are in use,
but also the pages that are not in use, waiting to avoid I/O, that
are important for performance.
CT requests/CT not in EDM pool
Ratio of number of requests for CT sections and number of times
CT sections were not already in the EDM pool.
PT requests/PT not in EDM pool
Ratio of number of requests for PT sections and number of times
PT sections were not already in the EDM pool.
DBD requests/DBD not in EDM pool
Ratio of number of requests for DBDs and number of times DBDs
were not already in the EDM pool.