EDM STATEMENT CACHE field (EDMSTMTC subsystem parameter)

The EDMSTMTC subsystem parameter determines the upper limit on the amount of EDM pool storage that is used for cached dynamic statements. The EDMSTMTC value is in kilobytes. This storage pool is located above the 2 GB bar.

Acceptable values: 5000–4194304
Default: 113386 1
Update: press ENTER on panel DSNTIPB
DSNZPxxx: DSN6SPRM EDMSTMTC
Notes:
  1. Db2 calculates the value when you run the installation CLIST with INSTALL for INSTALL TYPE on panel DSNTIPA1, based on values that you specify on panel DSNTIPD.

    When you run the installation CLIST with MIGRATE for INSTALL TYPE on panel DSNTIPA1, Db2 13 uses the Db2 12 field value. For more information, see Calculating storage requirements with the installation CLIST

The Override column of panel DSNTIPC controls whether Db2 uses the calculated value:
  • To accept the calculated value, ensure that the Override column contains no value.
  • To override the calculated value, specify a value in the Override column.

You can use the SET SYSPARM command to change this value. If the amount of storage that is used exceeds the value of EDMSTMTC, Db2 reduces the amount of storage to the value of EDMSTMTC.

Storage for cached dynamic statements is allocated as it is needed. When the EDMSTMTC value is reached, and new statements are added to the dynamic statement cache, statements that are already in the cache and are not currently in use are removed, to keep the storage that is in use below the EDMSTMTC value.