Skip to Content

 

  

Information
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.

Converting VCAT-defined partitions to STOGROUP-defined partitions by importing DML

Use the following procedure to import DML to create a task ID that converts table space and index partitions from VCAT to STOGROUP.

The script sets the storage allocation to implicit and removes invalid field values. If you specify a new primary or secondary space allocation in the DML statement, CM/PILOT uses those values. Otherwise, CM/PILOT calculates the new values from the VCAT fields for each partition.

To convert VCAT-defined partitions to STOGROUP defined partitions

 

Warning

Note

You can also perform this task by using the CM/PILOT DML_STRUCTURE_CHG script. For more information, see Changing-data-structures-by-using-DML.

  1. In an ISPF editor, type the DML statement to match the one shown in the following figure and provide the information that is unique to your site.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

    Success

    Tip

    You can copy the DML statements to convert the partitions from member ACMDMLU7 in the HLQ.BMCCNTL data set.

    UPDATE TABLEPARTS
    SET STORTYPE = 'I',
        STORNAME = 'ACMX',
        VCATNAME = ''
    WHERE
        VCATNAME = 'DEBACAT'
    ;
    UPDATE INDEXPARTS
    SET STORTYPE = 'I',
        STORNAME = 'ACMX',
        VCATNAME = ''
    WHERE
        VCATNAME = 'DEBACAT'
    ;

    In the preceding figure, the DML sets the type of storage allocation to implicit (STOGROUP) for the specified VCAT.

  2. Import the DML file.Now that the 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*

ALTER and BMC AMI Change Manager for Db2 12.1