Skip to Content

Converting a partition-by-growth table space to a range-partitioned table space with relative page numbering

(BMC.DB2.SPE2501)

Use the following procedure to convert a partition-by-growth table (PBG) space to a range-partitioned table space with relative page numbering. With this procedure, Analysis generates an ALTER PARTITIONING TO PARTITION BY RANGE clause in an ALTER TABLE statement, so that you can specify the partitioning key columns, the new number of partitions, and the corresponding high limit keys. 

Warning

Important

Analysis ignores any other change requests in this work ID.

Related topics

Accomplishing-your-data-structure-modification-goals

Analyzing-an-alter-type-work-ID-and-generating-a-worklist-in-Change-Manager

Executing-an-alter-type-worklist

  1. On the BMC AMI Change Manager for Db2 Main Menu panel, select WORKID and press Enter.
  2. On the WORKID Action Menu panel, enter the name of an alter-type WORKID or enter a wildcard pattern to display a list of work IDs. Then select Specify Db2 definitions and press Enter.

  3. On the Object Specification panel, specify the name of a PBG table space (or use wildcard characters) and press Enter.

    Success

    Tip

    The object type TSG indicates that the object is a PBG table space.

  4. On the Mixed List panel, type E in the Act column next to a table in the table space, and press Enter.
  5. On the Table Detail panel, type S to select Convert to Partition by Range, and press Enter.
  6. Specify partitioning key columns, add partitions to the table space, and specify limit keys for each partition.

  7. Keep pressing End until the WORKID Action Menu panel is displayed.

    Success

    Tip

    If the table space that you are converting is in an implicit database, you must explicitly change the database's name. On the Table Detail panel, change the database name to DSNDB04 or specify a user-defined name. The table space must already exist in the Db2 catalog, or you must create the table space in the work ID.

Now that the table space has been converted, you can analyze a work ID and execute a worklist.

Where to go from here

After you execute the worklist to materialize the changes to the table space, you can create a new alter-type work ID to modify the DSSIZE of the table space and index partitions, or to make any other modifications to the table space, table, or indexes.

 

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