Manipulating active logs


You can use OPERTUNE to add, remove, or create active logs dynamically in an active Db2 subsystem. Maintain logs by performing the following actions:

  • Remove the data sets
  • Repair the data sets offline
  • Add the data sets back

Select the Active log manipulation option from the Operational Assist Menu to display the Add/Remove Active Logs panel, as displayed in the following figure:

DDTAOLG 1 Add/Remove Active Logs
Command ===> ________________________________________________ Scroll ===> PAGE

Commands: ADD
 REMOVE
 CREATE
 ZPARMS
 SWITCHLOG
Active Log Commands Input Fields   CANCEL OFFLOAD
Copy 1 Data Set Name . . . .
Copy 2 Data Set Name . . . .

Select the name to be placed in the corresponding copy data set name field or type it in manually. Then type in the desired command and press Enter.
S=Select DD=Display Data Component Info DV=List Volume Info

Sel Log Data Set Name Copy Status Rem
.. DSNDFG.DFG1.LOGCOPY1.DS01 1 REUS   Y
.. DSNDFG.DFG1.LOGCOPY1.DS02 1 REUS,CUR   N
.. DSNDFG.DFG1.LOGCOPY1.DS03 1 REUS   Y
.. DSNDFG.DFG1.LOGCOPY2.DS01 2 REUS   Y
.. DSNDFG.DFG1.LOGCOPY2.DS02 2 REUS,CUR   N
.. DSNDFG.DFG1.LOGCOPY2.DS03 2 REUS   Y
******************************* Bottom of data ********************************

This panel displays a list of currently defined copy 1 log data sets and copy 2 log data sets, and the following information about each data set:

Field

Description

Log Data Set Name

The name of the log data set

Copy

The type of log (copy 1 or copy 2)

Status

The status of the log:

  • CUR—current
  • REUS—reusable
  • NREUS—not reusable
  • NEW—new
  • TRUN—truncated
  • STOP—stopped

Rem

Whether the log is removable without using the FORCE option

You can specify the log data sets that you want to affect by using the following input fields:

  • Copy 1 Data Set Name
    This input field is used as the copy 1 log data set parameter for the ADD, REMOVE, and CREATE commands. Type a name for the copy 1 data set, or type S in the Act field to select a copy 1 log data set from the list of log data sets. The data set name is copied to this field.
  • Copy 2 Data Set Name
    This input field is used as the copy 2 log data set parameter for the ADD, REMOVE, and CREATE commands. Type S in the Act field to select a copy 2 log data set from the list of log data sets. The data set name is copied to this field.

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*