EDM Pool (DB2 10) Workspace

The EDM Pool (DB2 10) workspace provides an overview of the Environmental Descriptor Manager (EDM) pool activity connected with DB2. You can view this information if DB2 10 is installed.

The EDM Pool (DB2 10) workspace is comprised of the following views:

EDM Statistics (table view)

Lists total counts, counts during the last sample period, and the "per second" count for a variety of tasks associated with the EDM pool.

EDM Pool Load Activity Summary (bar chart view)

Provides activity details of the EDM pool, including the number of pages dedicated to a type of pool usage and the percentage of the EDM pool dedicated to that type of usage.

EDM Pool Utilization (bar chart view)

Shows the relative distribution of available pages, cursor table pages, database descriptor pages, and package table pages.

DBD Pool (table view)

Lists information about database descriptors (DBDs).

DBD Pool Utilization (pie chart view)

Shows information about the utilization of the database descriptor (DBD) pool.

PKG Search / STMT in Global Cache (table view)

Lists information about package search and statement in global cache.

SKEL Pool (table view)

Lists information about the EDM skeleton pool.

Statement Pool (table view)

Lists information about the statements.

SKEL Pool Utilization (pie chart view)

Shows information about the EDM skeleton pool.

Statement Pool Utilization (pie chart view)

Shows information about the statements.

You can use the HTML navigation feature to navigate from one workspace to another, while passing context information to the next workspace. The workspaces that belong to the same functional unit are linked using HTML navigation. Tivoli Enterprise Portal workspaces are grouped into the following units: Thread Summary workspaces, Thread Detail workspaces, and Statistics workspaces.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.