LOGTHRSH—Log write threshold
Use the Modify Log Write Threshold panel or the LOGTHRSH command to specify the new value of the log write threshold, which indicates the number of log buffers to be filled before starting to write. The new value takes effect immediately. If the value is reduced below the number of log buffers waiting to be written, the write takes place when Db2 has the next log buffer ready to write.
Modify Log Write Threshold panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : # OF FULL BUFFERS BEFORE WRITE
Type the new log write threshold value that you wish to change to. Then press Enter.
Log Write Parameter
Threshold value . . . . . . _____ (1-256 or delta)
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 | Log wait threshold (the number of log buffers that will be filled before they are written). 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 |
|---|---|---|---|---|
Threshold value | DSNTIPL | LOGTHRSH | DSN6LOGP | WRTHRSH |