CONTSTOR—Free unused thread storage
Use the Modify Free Unused Thread Storage panel or the CONTSTOR command to specify whether Db2 periodically contracts the working storage area for each thread and to specify at what intervals this occurs.
Modify Free Unused Thread Storage panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : CONTRACT THREAD WORKING STORAGE
Type the new Free Unused Thread Storage parameters you wish to change to. Then Press Enter.
Free Unused Thread Storage
Enabled . . . . . . . . . . _ (Y or N)
Thread Commit Threshold . . _______ (1 - 32767 or delta)
Storage Limit Threshold . . _________ (1 - 2097152 or delta) Kilobytes
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 | Db2 determines the need for a storage contraction for a thread after each commit. If the number of commits since the last contraction or the amount of long term storage acquired has exceeded a global threshold, unused storage is freed |
N | Db2 does not periodically contract each thread’s working storage area. |
globalCommitT | Global threshold for the number of commits that must occur before unused thread storage is freed. Specify one of the following values:
|
globalLongStorageT | Global threshold for the amount of long term storage acquired (in kilobytes) that must be exceeded before unused thread storage is freed. Specify one of the following values:
|
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 | DSNTIPE | CONTSTOR | DSN6SPRM | CONTSTOR |