ARCHIVE—Log archiving switch
Use the Modify Log Archiving Indicator panel or the ARCHIVE command to turn Db2 log archiving on or off. When archiving is off, the subsystem switches active logs without off-loading them. The subsystem will be unable to recover a thread whose records are not contained in one of the active log data sets. When archiving is on, the new value is used the next time an active log data set is full. Use this element to turn off Db2 archiving if you have storage problems and recoverability of your Db2 workload is not critical. Once you have corrected the problem, use this element to turn archiving back on.
Modify Subsystem Log Archiving Indicator panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : LOG ARCHIVING SWITCH
Type the new archive log offload value that you wish to change to. Then press
Enter.
Log Archiving Parameter
Offload switch . . . . . . . _ ( 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 | Log archiving is turned on |
N | Log archiving is turned off (the subsystem switches active logs without offloading them and will be unable to recover a thread whose records are not contained in one of the active log data sets). |
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 |
|---|---|---|---|---|
Offload switch | None | None | None | None |