Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Importing a CDL, DDL, or DML file to Change Manager

Use the following procedure to import a CDL, DDL, or DML file in the 

BMC AMI Change Manager for Db2

 product. For DDL and CDL files, you can use an inbound migrate profile to specify change rules for the import

Tip

To create an alter-type work ID, see Creating-an-alter-type-work-ID. To create an inbound migrate profile, see Creating-an-inbound-migrate-profile-in-Change-Manager.

To import a CDL, DDL, or DML file

  1. On the BMC AMI Change Manager for Db2  Main Menu, select WORKID, and press Enter.
  2. On the WORKID Action Menu, type the name of the WORKID and select Import CDL, DDL or DML to a WORKID. Then, press Enter.
  3. On the Import Interface panel, specify the information to import the file.
    1. (Optional for CDL and DDL files) Type the name of an inbound migrate profile, or type a wildcard pattern to display a list of migrate profiles.
    2. Select the Source Type.
    3. Select the Run Type.
    4. Press Enter.
  4. On the Import JCL Processing Interface panel, specify the data set names to be used by Import.
    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, DDL, or DML file that you want to import.
    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 4.c, specify the Sysout Class.
  5. Select the options for importing the source file.
    1. To review or modify the source file before it is stored as entries in the CD tables, type S to select Edit CDL, Edit DDL, or Edit DML.
    2. To create the input, select one of the following options:
      • (Foreground run type) Type S to select Create Input.
      • (Batch run type) Type S to select Create JCL.
    3. To review or modify input to the 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.
    4. To import the file, select one of the following options:
      • (Foreground run type) Type S to select Run.
      • (Batch run type) Type S to select Submit JCL.
    5. Press Enter.

  6. Press END.The WORKID Action Menu is displayed.

    Now that the CDL, DDL, or DML file has been imported , you can analyze a work ID and execute a worklist.


 

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