Defining an output DDL file

This procedure explains how to generate an output DDL file.

When you generate an output DDL file, Log Master can generate a Catalog Activity report, generate an output command file, or update the Repository, but it cannot generate other forms of output in the same log scan, such as other reports or SQL. To generate any other forms of output that you need in the same work ID, add a separate log scan step.

Before you begin

Ensure that you understand the concepts presented in the following sections:
Define the time frame and filters for the log scan step.
To generate DDL, you must also set the Process DB2 Catalog Record run time option to Y.

To define a DDL 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.
If the task dialog that you are using automatically generates default reports or output files, delete all default reports and output files from the log scan step by typing D in the ACT column for each one. Press Enter.
In the ACT column, type I and press Enter.
Log Master displays the Output Options panel.
Select DDL File Outputs and press Enter.
Log Master displays the DDL Output panel.
To define an UNDO DDL output file, type E in the UNDO DDL field and press Enter.
Log Master displays the Output Dataset Information panel.
For the UNDO DDL output file, edit the default data set name and file attributes and press F3.
Log Master displays the DDL Output panel.
To define a MIGRATE DDL output file, type E in the MIGRATE DDL field and press Enter.
Log Master displays the Output Dataset Information panel.
For the MIGRATE DDL output file, edit the default data set name and file attributes and press F3.
Log Master displays the DDL Output panel.
Finish specifying the other DDL file attributes and press F3 twice to return to the task dialog panel.

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

Before you begin

To define a DDL file as output

Where to go from here

Comments