Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

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

To define a logical log file as output

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

  3. 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)
  4. In the Logical Log field, type E and press Enter.Log Master displays the Output Dataset Information panel for the logical log data set.
  5. 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.
  6. In the Logical Log Control field, type E and press Enter.Log Master displays the Output Dataset Information panel.
  7. 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.
  8. 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

 

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