LOBVALA—User LOB storage limit
Use the Modify User LOB Storage Limit panel or the LOBVALA command to specify the maximum amount of storage that can be allotted to each user for storing LOB values.
Modify User LOB Storage Limit panel
Command ===> ________________________________________________________________
Command: CURRENT
Description . . . . . . . . : LOB USER STORAGE LIMIT
Type the new User LOB storage limit that you wish to change to. Then press Enter.
User LOB Storage Limit
Storage Limit . . . . . . . _______ (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). |
value | LOB storage limit (maximum amount of storage (in kilobytes) that each user can use for storing LOB values). Specify one of the following values:
You specify the value in kilobytes (K), and the macro will convert the value to bytes (B). |
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 |
|---|---|---|---|---|
Storage limit | DSNTIP7 | LOBVALA | DSN6SYSP | LOBVALA |