CACHEDYN—Cache dynamic SQL
Use the Modify Cache Dynamic SQL panel or the CACHEDYN command to determine whether prepared dynamic SQL is cached in the EDM pool for use by later processes. You can use this element to determine if performance may be improved by enabling or disabling dynamic SQL caching for a package.
Modify Cache Dynamic SQL panel
Command ===>
Command: CURRENT
Description . . . . . . . . : CACHE DYNAMIC SQL
Type the new Cache Dynamic SQL value you wish to change to. Then
press Enter.
Cache Dynamic SQL Parameter
Enabled . . . . . . . . . . (Y or N)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
Y | Dynamic SQL statements are cached and saved. |
N | Dynamic SQL statements are not cached and saved. |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Enabled | DSNTIP4 | CACHEDYN | DSN6SPRM | CACHEDYN |