Generating a CDL file from a work ID

To generate a CDL file from a work ID

1. On the BMC AMI Change Manager for Db2 Main Menu, select WORKID, and press Enter.
2. On the WORKID Action Menu panel, type the name of a WORKID and select Convert Alter WORKID to CDL. Then, press Enter.
3. On the Compare CDL Options panel, type Y or N for each object type that you want to include in or exclude from the comparison.
4. Type S to display a list of the object attributes to include in or exclude from the comparison.
5. On the Compare Object Attributes panel, if you selected to display a list of the object attributes, specify the object attributes.
   1. To include an object attribute in the comparison, type Y adjacent to the attribute.
   2. If you specified to include the partition attributes in step Step 5.a, you can exclude one or more of the partition attributes. Type N adjacent to the attributes that you want to exclude.
   3. Press END.
6. On the Compare CDL Options panel, type S to generate comparison report information as comments in the CDL file.
7. (Optional) Specify the name of an outbound migrate profile. The outbound migrate profile must contain change rules and locations. BMC AMI Change Manager for Db2 applies the rules after it performs the comparison (when it generates the CDL).
8. Select a Run Type and press Enter. Be aware that specifying foreground for large comparisons might make your TSO session unavailable for a lengthy period of time.
9. On the Compare JCL Processing Interface panel, specify the data set names to be used in the comparison.
   1. (Batch run type) Type the data set name for the JCL that is generated by this process.
   2. Type the data set name for the CDL that is generated by this process.
   3. Type one of the following options for Diagnostics:
      • (Foreground run type) To display the diagnostics on the terminal, type TERM.
      • To write the diagnostics to a sequential file, type the name of the data set.
      • To write the diagnostics to a print data set, type SYSOUT.
   4. (Foreground run type) If you specified SYSOUT in Step 9.c step , specify the Sysout Class.
10. Type S to select Override Compare defaults to change data set allocation parameters or to control the content of the CDL that is generated by the comparison process. Press Enter.
11. On the Compare Override Options panel, if you selected to override the defaults, specify the data set and CDL options.
    1. To specify the data set allocation parameters for new data sets, type a value for the Unitname, Volume, Priqty, or Secqty.
    2. To include CDL statements for created, altered, or dropped objects, type S to select the statements.
    3. To display, in the CDL, the change rules from an outbound migrate profile or the automatic change rules, type S for Display change rules applied to Compare2 BEFORE the Compare.
    4. Press END.
12. On the Compare JCL Processing Interface panel, select your options for the comparison.
    1. To create the input for the comparison, select one of the following options:
       • (Foreground run type) Type S to select Create Input.
       • (Batch run type) Type S to select Create JCL.

    2. To review or modify input to the comparison process, select one of the following options:

       • (Foreground run type) Type S to select Edit Input.
       • (Batch run type) Type S to select Edit JCL.

       The following figure shows an example of the ALUIN input stream.

       Press END.

       SSID DEBA
       CMPTYPE1 WORKID
       CMPIN1 RDACRJ.ALT01
       INCLUDE (ALTER CREATE DROP )
       NODEFINE

    3. To run the comparison, select one of the following options:

       • (Foreground run type) Type S to select Run Compare.
       • (Batch run type) Type S to select Submit JCL.

       Change Manager generates a CDL file and a diagnostic output file.

    4. To edit the CDL file that is generated by the comparison, type S to select Edit CDL File.

       Warning

       Do not attempt to edit the CDL file while the comparison is in progress, or the file will be locked, and the Compare component will not be able to access it.

    5. Press Enter.