Generate UNDO or REDO DDL Statements

The DDL Activity function can be used to generate executable DDL statements to redo the creation and alteration of an object, or undo the dropping and alteration of an object. The UNDO DDL option can provide the DDL of an accidental object drop. The REDO DDL option can be used to create source objects on a mirror system.
The DDL statements that are generated provide a starting point for executing the DDL. 
CA Log Analyzer™ for DB2 for z/OS
 attempts to generate complete DDL statements, but we recommend reviewing the statements before using them.
Follow these steps:
  1. Select 
    Process Log
     from the 
    CA Log Analyzer™ for DB2 for z/OS
     Main Menu.
    The 
    Process Log - Report Specification
     panel (LAPRM) opens.
  2. Select 
    DDL Activity
     and press 
    Enter
    .
    The 
    DDL Activity Report Options
     panel (LAPRDDL) appears.
  3. Complete the following fields:
    1. Specify 
      U
       (to create UNDO DDL) or 
      D
       (to create REDO DDL) in the 
      Output Format Field
      .
    2. Specify 
      D
       (Detail) in the 
      Level of Detail field
      .
    3. Specify 
      I
       (Include) in the 
      Primary Authids
       field under 
      Log Data Filter Options
       and enter the authorization ID of the person or process that dropped the object.
    4. Use the 
      Miscellaneous Options
       to include or exclude other types of data from the DDL statements. You can also specify whether to generate table OBIDs.
    5. Specify 
      I
       (Include) in the 
      LOB Column Data
       field.
    6. Specify 
      Y
       in the
       Redo/Undo URID
       header field to make it easier to find the relevant DDL when it is generated.
  4. Press 
    PF3
     until the 
    Report Source Specification
     panel (LAPRLRNG) appears.
  5. Specify the log data to analyze by entering the starting and ending parameters under 
    Log Processing Range
     and the data sources to use under 
    Source Options
    .
    To enter a log label name or a date/time expression that exceeds the field length in the panel, type 
    slash (/)
     in the field and press 
    Enter
    . The expanded field pops up. Enter the value in the field and press PF3 (End).
  6. Press PF3 (End).
    The 
    Output Specifications
     panel (LAPOS14) appears.
  7. Specify a data set name for the DDL statements in the 
    Dataset Name
     field and press 
    PF3
    .
    The 
    Output Specifications
     panel (LAPOS21) opens.
  8. Specify a data set name for the 
    LOB file
    . This step is necessary only when you process LOB columns.
  9. Press 
    PF3
    .
    The 
    Report Submission
     panel (LAPREPEX) opens.
  10. Specify an execution mode and press Enter.
    The DDL statements are generated based on the specified execution mode and saved to the specified destination.