DDL output files

BMC AMI 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, BMC AMI Log Master can generate a Catalog Activity report, generate a command output file, or update the Repository. BMC AMI Log Master cannot include other forms of output in the same log scan, such as other reports or SQL.

Related topic

Output-file-definitions

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*