EDM Pool Activity

This topic shows detailed information about Statistics - EDM Pool Activity.

Statistics - EDM Pool Activity

The field labels shown in the following sample layout of Statistics - EDM Pool Activity are described in the following section.


EDM POOL                     QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
PAGES IN DBD POOL (ABOVE)         N/A      N/A      N/A      N/A
  HELD BY DBD                   87.00      N/A      N/A      N/A
    STEALABLE PAGES              0.00      N/A      N/A      N/A
  FREE PAGES                      N/A      N/A      N/A      N/A
% PAGES IN USE                   6.96      N/A      N/A      N/A
FAILS DUE TO DBD POOL FULL       0.00     0.00      N/C     0.00

PAGES IN STMT POOL (ABOVE)    1250.00      N/A      N/A      N/A
  HELD BY STATEMENTS             3.54      N/A      N/A      N/A
  FREE PAGES                  1246.46      N/A      N/A      N/A
FAILS DUE TO STMT POOL FULL      0.00     0.00      N/C     0.00

PAGES IN SKEL POOL (ABOVE)        N/A      N/A      N/A      N/A
  HELD BY SKCT                   0.00      N/A      N/A      N/A
  HELD BY SKPT                  16.53      N/A      N/A      N/A
    STEALABLE PAGES             16.53      N/A      N/A      N/A
  FREE PAGES                      N/A      N/A      N/A      N/A
% PAGES IN USE                   0.00      N/A      N/A      N/A
FAILS DUE TO SKEL POOL FULL      0.00     0.00      N/C     0.00

DBD REQUESTS                    18.00     0.10      N/C     0.55
DBD NOT FOUND                    0.00     0.00      N/C     0.00
DBD HIT RATIO (%)              100.00      N/A      N/A      N/A
CT REQUESTS                      0.00     0.00      N/C     0.00
CT NOT FOUND                     0.00     0.00      N/C     0.00
CT HIT RATIO (%)                  N/C      N/A      N/A      N/A
PT REQUESTS                     17.00     0.09      N/C     0.52
PT NOT FOUND                     1.00     0.01      N/C     0.03
PT HIT RATIO (%)                94.12      N/A      N/A      N/A

PKG SEARCH NOT FOUND             0.00     0.00      N/C     0.00
PKG SEARCH NOT FOUND INSERT      0.00     0.00      N/C     0.00
PKG SEARCH NOT FOUND DELETE      0.00     0.00      N/C     0.00

STATEMENTS IN GLOBAL CACHE       1.18      N/A      N/A      N/A

PAGES IN DBD POOL (ABOVE)

This field shows the number of pages in the DBD pool above the 2 GB bar.

Field Name: QISEDPGE

HELD BY DBD

The current number of pages used for database descriptors (DBDs). This is a snapshot value.

Field Name: QISEDBD

STEALABLE PAGES

The current number of stealable pages used for database descriptors (DBDs).

Field Name: QISEDLRU

FREE PAGES (Prior to Db2 12)

This field shows the number of free pages in the DBD pool above the 2 GB bar.

Field Name: QISEDFRE

This is an exception field.

% PAGES IN USE

The percentage of DBD pages in use expressed as a ratio of non-stealable HELD BY pages to the total number of pages in DBD pool (QISEDPGE).

Field Name: SISEDPIU

FAILS DUE TO DBD POOL FULL

This field shows the total number of failures because the DBD pool above the 2 GB bar was full.

Field Name: QISEDFAL

This is an exception field.

PAGES IN STMT POOL (ABOVE)

The current number of pages in the EDM Statement pool above the 2 GB bar. This is a snapshot value.

Field Name: QISECPGE

HELD BY STATEMENTS

The number of pages in the EDM Statement pool above the 2 GB bar that is used for cached dynamic SQL statements. This is a snapshot value.

Field Name: QISEDYNP

FREE PAGES

The number of pages currently not used by any object in the EDM Statement pool above the 2 GB bar.

Field Name: QISECFRE

FAILS DUE TO STMT POOL FULL

The total number of failures because the EDM Statement pool above the 2 GB bar was full. For Db2 12 this field shows N/A.

Field Name: QISECFAL

PAGES IN SKEL POOL (ABOVE)

The current number of pages in the EDM skeleton pool above the 2 GB bar.

Field Name: QISEKPGE

HELD BY SKCT

The current number of pages used for skeleton cursor tables (SKCTs). This is a snapshot value.

Field Name: QISESKCT

HELD BY SKPT

The current number of pages used for skeleton package tables (SKPTs). This is a snapshot value.

Field Name: QISESKPT

STEALABLE PAGES

The current number of stealable pages used for skeleton cursor and package tables.

Field Name: QISEKLRU

FREE PAGES (Prior to Db2 12)

The number of pages currently not used by any object in the EDM skeleton pool above the 2 GB bar.

Field Name: QISEKFRE

% PAGES IN USE

The percentage of skeleton pages in use expressed as a ratio of non-stealable HELD BY pages to the total number of pages in SKEL pool (QISEKPGE).

Field Name: SISEKPIU

FAILS DUE TO SKEL POOL FULL

The total number of failures because the EDM skeleton pool above the 2 GB bar was full.

Field Name: QISEKFAL

DBD REQUESTS

The number of requests for database descriptors (DBDs).

Field Name: QISEDBDG

DBD NOT FOUND

The total number of times database descriptors were loaded from DASD.

To find the number of times the DBD was already in the EDM pool, subtract this value from the value of Requests for sections - DBD field.

Field Name: QISEDBDL

This is an exception field.

DBD HIT RATIO (%)

The ratio of successful requests for database descriptors (DBD) from the EDM pool to the total number of requests for database descriptors expressed as a percentage.

Field Name: SERDBLR

This is an exception field.

CT REQUESTS

The number of requests for cursor table (CT) sections.

Field Name: QISECTG

This is an exception field.

CT NOT FOUND

The number of times a cursor table section was loaded from DASD.

To find the number of times the CT was found in the EDM pool, subtract this value from the value of the Requests for sections - CT field.

Field Name: QISECTL

This is an exception field.

CT HIT RATIO (%)

The ratio of successful requests for cursor tables from the EDM pool to the total number of requests for cursor tables expressed as a percentage.

Field Name: SERCTLR

This is an exception field.

PT REQUESTS

The number of requests for package table (PT) sections.

Field Name: QISEKTG

This is an exception field.

PT NOT FOUND

The number of times a package table section was loaded from DASD.

To find the number of times the PT was already in the EDM pool, subtract this value from the value of the Requests for sections - PT field.

Field Name: QISEKTL

This is an exception field.

PT HIT RATIO (%)

The ratio of successful package table requests from the EDM pool to the total number of package table requests, expressed as a percentage.

Field Name: SERPTLR

This is an exception field.

PKG SEARCH NOT FOUND

When a package is bound with a wild card (*) for package names, in the form of PKLIST(COL1.*,COL2.*.....), EDM generates a NOT-FOUND record to avoid future I/O if a collection ID/package name combination does not exist.

This field shows how often a cached record was located during package binding.

Field Name: QISEKNFM

PKG SEARCH NOT FOUND INSERT

This field shows how often a record was added to the cache during package binding.

Field Name: QISEKNFA

PKG SEARCH NOT FOUND DELETE

This field shows how often a record was removed from the cache during package binding.

Field Name: QISEKNFR

STATEMENTS IN GLOBAL CACHE

Number of statements in the global cache.

Field Name: QISESTMT