Defining an output logical log file

This procedure explains how to define a logical log data file and its associated logical log control file.

Before you begin

Ensure that you understand the concepts presented in the following sections:
- Output file definitions
- Logical log output files
Define the time frame and filters for the log scan step.

To define a logical log file as output

From the task dialog panel, select Define Report and File Outputs and press Enter.
Log Master displays the Report and File Outputs panel.
In the ACT column, type I and press Enter.
Log Master displays the Output Options panel.

Select Logical Log File Outputs and press Enter.

Log Master displays the Logical Log Output panel (see following figure).

 ============================== Logical Log Output =============================
 Command ===> __________________________________________________________________
                                                                     SSID: DBAN
Logical Log . . . . . . . . . . . .   _ (E=Edit)                               
    FILE: &SYSUID..D&DATE..T&TIME..LLOG.DATA                                  
Logical Log Control . . . . . . . .   _ (E=Edit)                               
    FILE: &SYSUID..D&DATE..T&TIME..LLOG.CNTL                                  
Logical Log XMLSTRING Control . . .   _ (E=Edit)                               
                                                                              
 Date Format      . . . . . . . . . . D  (D=DB2I, S=SASTIME)
 Expand VARCHAR columns . . . . . . . N  (Y=Yes, N=No)

 Create Include/Exclude Columns . . . _  (E=Edit)

 Include Rollback . . . . . . . . . . N  (Y=Yes, O=Only, N=No)                  
 Include Command Records . . . . . . .N  (Y=Yes, O=Only, N=No) 
 Include DDL Objects . . . . . . . . .N  (Y=Yes, N=No)                          
 Include LOBS . . . . . . . . . . . . N  (Y=Yes, N=No)                          
 Include XML  . . . . . . . . . . . . N  (Y=Yes, N=No)                          
 Include SYNONYMS . . . . . . . . . . N  (Y=Yes, N=No) 
 Include STATUS CHANGES . . . . . . . N  (Y=Yes, O=Only, N=No)

In the Logical Log field, type E and press Enter.
Log Master displays the Output Dataset Information panel for the logical log data set.
Edit the default data set name and file attributes (this file must be a variable blocked file) and press F3.
Log Master displays the Logical Log Output panel.
In the Logical Log Control field, type E and press Enter.
Log Master displays the Output Dataset Information panel.
Edit the default data set name and file attributes (this file must be a variable blocked file), and press F3.
Log Master displays the Logical Log Output panel.
Specify the remaining logical log output file attributes as required and press F3 twice to return to the first panel of the task dialog.

Where to go from here

For additional tasks associated with creating a log scan step, see Defining a log scan step.

Related topic

Defining a log scan step

Defining an output logical log file

Before you begin

To define a logical log file as output

Where to go from here

Comments