Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

DDL Output panel

                                   DDL Output                                 
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)

Was this page helpful? Yes No Submitting... Thank you

Comments