Skip to Content

Estimating the primary and secondary quantities in table space and index partitions by importing DML

Use the following procedure to import DML to create a task ID that performs space estimation for all table space partitions and index partitions in a database.

To estimate the primary and secondary quantities in a tablespace and index partitions


Warning

Important

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 statements to match the one shown in the following figure. Customize the database name to match your local requirements.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

    Success

    Tip

    You can copy the DML statements to estimate the space for all table spaces and indexes in a database from the member ACMDMLU5 in the HLQ.BMCCNTL data set.

    SET SPACE ESTIMATION IMPLICIT -- turn space estimation on
    --     PQTY = BMCSPACE           -- default options
    --    ,SQTY = BMCSPACE/10
    ;
    UPDATE DATABASE SET
    WHERE
     NAME = 'yourDB'-- select database
    ;

    The DML specifies to implicitly estimate the space for all table space partitions and index partitions in a database. The primary quantity is set to the value that is returned from space estimation. The secondary quantity is set to one tenth of the value that is returned from space estimation.

  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 13.1