DDL output files
Log Master
enables you to generate DDL files to migrate changes (called MIGRATE DDL), or to reverse the changes (called UNDO DDL).
When you generate a DDL output file, Log Master can generate a Catalog Activity report, generate a command output file, or update the Repository. Log Master cannot include 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 an additional, separate log scan step. To generate DDL, you must also set the Process DB2 Catalog Records field on the Run Time Options panel to Y.
You access the DDL Output panel as shown in the following figure from the Output Options panel. Define an output DDL file by specifying values on this panel. For descriptions of the options on this panel, press F1 to access the online Help.
Command ===>
SSID : DHA
UNDO DDL . . . . . . . . . . . . . . (E=Edit, D=Delete)
DSN: &SYSUID..D&DATE..T&TIME..UNDO.DDL
MIGRATE DDL . . . . . . . . . . . . (E=Edit, D=Delete)
DSN: &SYSUID..D&DATE..T&TIME..MIGRATE.DDL
Additional Options:
Include Comments . . . . . . . . . N (Y=Yes, N=No)
Commit Frequency . . . . . . . . . 1 (Number of Transactions, 0=All)
Set SQLID. . . . . . . . . . . (Generate SET SQLID)
Related topic