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 load file

This procedure explains how to define a load file and its associated control file.

Before you begin

To define a load 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 Load File Outputs and press Enter.Log Master displays the Load Output panel (see following figure).

                                       Load Output                                  
     Command ===>                                                                   
                                                                        SSID : DJV  
                                                                        More:     +
     Load File . . . . . . . . . . . . .    (E=Edit)                                
         FILE: &SYSUID..D&DATE..T&TIME..LOAD.DATA                                   
     Load Control File . . . . . . . . .    (E=Edit)                                
         FILE: &SYSUID..D&DATE..T&TIME..LOAD.CNTL                                   
     Record Format . . . . . . . . . . . V  (V=VB, S=VBS)                           
     Spanned . . . . . . . . . . . . . . N  (N=No, Y=Yes  LOB/XML for LOADPLUS)     
     Format of Load File Output. . . . . L  (L=Log Master, U=Unload Plus,           
                                             C=CSV, S=Standard Format, E=EDIT CSV)  
     Separate Dataset per Table  . . . . N  (Y=Yes, N=No)                           
     Generate Empty Files  . . . . . . . N  (Y=Yes, N=No)                           
     Expand VARCHAR columns  . . . . . . Y  (Y=Yes, N=No)                           
     Include INFO Columns with Data. . . N  (A=All, U=Urid Only, N=Urid None,       
                                             E=Edit, S=User Prev Specified)         
     Separate Unit of Recovery Info  . . N  (Y=Yes, N=No)                           
     Update Record Options . . . . . . . S  (A=After Image Only,B=Before Image Only,
                                             S=Both Separately, T=Both Together)    
     Create Include/Exclude Columns  . .    (E=Edit)                                
     Sort  . . . . . . . . . . . . . . . Y  (Y=Yes, N=No)                           
     Include Rollback. . . . . . . . . . N  (Y=Yes, O=Only, N=No)                   
     Include XML . . . . . . . . . . . . Y (Y=Yes, N=No, T=Template, E=Edit)                 
     Include LOBS. . . . . . . . . . . . N (Y=Yes, N=No, I=Inline, T=Template, E=Edit)
     PeriodOverride . . N IgnoreFields . N (Y=Yes, N=No)
     Delimit Column Name . . . . . . . . O  (O=Only, N=None, A=ALL)

  4. In the Load File field, type E and press Enter.Log Master displays the Output Dataset Information panel for the load file data set. 

                                    Load Output
    .------------------------------------------------------------------------------.
    |                          Output Dataset Information                          |
    |                                                                              |
    | Load File Dataset                                                            |
    | Dataset Name (PDS Member Allowed) . . .                                      |
    |    &SYSUID..D&DATE..T&TIME..LOAD.DATA                                        |
    | Disposition  . . . . . N              (N=New, M=Mod, O=Old, S=Shr)           |
    | LRECL  . . . . . . . . _____          (81-32760 For REPORT or LOAD)          |
    |                                                                              |
    | Unit . . . . . . . . . SYSDA                                                 |
    | Allocation Type  . . . C              (C=Cyls, T=Trks)                       |
    | Space  . . . . . . . . 1     , 1      (Primary, Secondary)                   |
    | Release  . . . . . . . Y              (Y=Yes, N=No)                          |
    | Max Volumes  . . . . . ___                                                   |
    | Expiration Date  . . . ________       (yyddd or yyyy/ddd)                    |
    | Retention Period . . . ____                                                  |
    | Model DSCB . . . . . . ____________________________________________          |
    | Data Compaction  . . . _              (Y=Yes, N=No  For TAPE Only)           |
    | Data Class . . . . . . ________       (For SMS Only)                         |
    | Management Class . . . ________       (For SMS Only)                         |
    | Storage Class  . . . . ________       (For SMS Only)                         |
    | Volser(s)  . . . . . . ______ , ______ , ______ ,______ , ______ , ______    |
    | F13=Help   F15=Exit   F24=Cancel                                             |
    '------------------------------------------------------------------------------'
  5. Edit the default data set name and file attributes and press F3.Log Master displays the Load Output panel (see figure in step 3).
  6. (optional) To edit the default data set name of the load control file, or to change data set attributes, type E in the Load Control File field and press Enter.Log Master displays the Output Dataset Information panel for the load control data set.
  7. Edit the default data set name and file attributes and press F3.Log Master displays the Load Output panel.
  8. Specify the remaining output load file attributes as needed.For more information about the options on this panel, press F1 to access the online Help.
  9. 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*