IINSTALL PARAMETER: EDMPOOL STORAGE SIZE

ZPARM NAME: EDMPOOL

Specifies the size of the EDM Pool in KB. The EDM pool contains:

• Database descriptors (DBDs)
• Skeleton cursor tables (SKCTs)
• Cursor tables (CTs), or copies of the SKCTs
• Skeleton package tables (SKPTs)
• Package tables (PTs), or copies of the SKPTs
• An authorization cache block for each plan, for plans not bound with CACHESIZE(0)
• Skeletons of dynamic SQL if Dynamic SQL caching is enabled

IINSTALL PARAMETER: EDM STATEMNT CACHE on panel DSNTIPC

ZPARM NAME: EDMSTMTC in DSN6SPRM

Specifies the size of the statement cache (in KB) that can be used by the Environmental Descriptor Manager (EDM).

This value is used at DB2 startup time as the minimum value. You can increase and subsequently decrease this value with the SET SYSPARM command. This value cannot be decreased below the value that is specified at DB2 startup. The CLIST calculates a statement cache size. This storage pool is located above the 2-GB bar.

The value used at DB2 startup time is either calculated by the CLIST based on input from other installation information or an override value.

Valid values are 5000 through 1048576 kilobytes. Default is 5000 kilobytes.

IINSTALL PARAMETER: EDM DBD CACHE on panel DSNTIPC

ZPARM NAME: EDMDBDC in DSN6SPRM

Specifies the minimum size (in KB) of the DBD cache that can be used by the Environmental Descriptor Manager (EDM).

This value is used at DB2 startup time as the minimum value. You can increase and subsequently decrease the value with the SET SYSPARM command. This value cannot be decreased below the value that is specified at DB2 startup. The CLIST calculates the DBD cache size. This storage pool is located above the 2-GB bar.

The value used at DB2 startup time is either calculated by the CLIST based on input from other installation information or an override value.

Valid values are 5000 through 2097152 kilobytes. Default is 5000 kilobytes.

This field can be modified by overtyping the value, provided you have

• Appropriate authorization
• BMC Software's OPERTUNE for DB2 product installed

• Possible values are:

• 5000 to 2097152
• A delta value

• Default is 5000 for DB2 8.1 and later.

EDMBFIT=YES,
EDMDBDC=10000, = 2500 Pages
EDMPOOL=15000, = 3750 Pages
EDMSTMTC=10000, = 2500 Pages

More keywords:

• MAX_OPEN_CURSOR
• to reduce DBD Cache -> Reorg DBD's

Total EDM pool space

Use the following variables to calculate EDM pool space for plans, packages, dynamic statements, and DBDs:

 Let concplans be the number of concurrently executing plans. This is the sum of the values that are specified for the MAX USERS and MAX REMOTE ACTIVE fields on installation
panel DSNTIPE.

 Let maxplans be the maximum number of unique plans that you want in the EDM pool at any given time. Estimate this by taking one fourth of the total number of plans.

 Let plansize be the average plan size.

 Let concdb be the number of concurrent databases, which is specified on installation panel DSNTIPE.

 Let dbdsize be the DBD size. Then, calculate as follows:

(concplans + maxplans) * plansize + (concdb * dbdsize)

Then, add 50 KB for overhead.

The default, as calculated by the DSNTINST CLIST, is

((200 + 200)+ 50) * 25 + (100 * 223) = 33550 KB

Then, the CLIST adds 50 KB for overhead to give the result of 33 600 KB.