CACHEDYN_FREELOCAL in macro DSN6SPRM

Indicates whether DB2® can free cached dynamic statements to relieve DBM1 below-the-bar storage. CACHEDYN_FREELOCAL applies only when the KEEPDYNAMIC(YES) bind option is active.

If you specify 0, DB2 does not free cached dynamic statements to relieve high use of storage by dynamic SQL caching.

The default value is 1, which means that DB2 frees some cached dynamic statements to relieve high use of storage when the cached SQL statement pools have grown to a certain size.