Converting a partitioned table space to a partition-by-growth table space

Use the following procedure to convert one of the following objects to a partition-by-growth table space:

Index-controlled partitioned table space
Table-controlled partitioned table space
Range-partitioned table space

In this task, you perform the following subtasks:

Display the list of partitioned table spaces.
Convert to an explicit table space, or to an implicit database or table space.
Change the partitioned indexes.

To display the list of partitioned table spaces

On the BMC AMI Change Manager for Db2 Main Menu, select WORKID, and press Enter.
On the WORKID Action Menu, type the name of an alter-type WORKID or type a wildcard pattern to display a list of work IDs. Then, select Specify Db2 definitions and press Enter.
On the Object Specification panel, specify the name of a partitioned table space that uses index-controlled or table-controlled partitioning (or use wildcard characters). Then, press Enter.The Mixed List panel is displayed.

To convert to an explicit table space

On the Mixed List panel, type E in the Act column adjacent to a table space that you want to convert.
Success
Tip
The TSI object type indicates that the object is an index-controlled partitioned table space. The TST object type indicates that the object is a table-controlled partitioned table space. The TSR object type indicates that the object is a range-partitioned table space.
On the Tablespace Detail panel, type S to select Tablespace Partition List.
On the Tablespace Parts List panel, perform the following actions:
1. For the partitioning status, select Partition by Growth.A dialog is displayed (see the following figure).
  Warning
  Note
  The messages that are displayed in the dialog vary, depending on the values that you have set for the DSSIZE and SEGSIZE, and whether you are converting from a range-partitioned table space.
  ALUS2TSP R   ---------------------- Tablespace Parts List ---------------------
  Command ===>                                                    Scroll. . PAGE
  
  WORKID . . . . : MVSSXS1.SCB0929A                            Commands: CANCEL
  
  Database Name . . : R1ALL                           Select partitioning status.
  Tablespace Name . : M04TCP                           3 1. Regular Partitioned
  Dssize . . . . . . 0     GB Segsize . . 0    (0-64)   2. Large Partitioned
  Variable CISIZE . .       (Blank for SG, Y/N for VCAT) 3. Partition by Growth
  Pagenum . . . . . . A     (A/R)                         *. Non-Partitioned
  Maxpartitions . . . 0
  Rotate Parts . . . 0     (First to Last)
  +-----------------------------------------------------------------------------+
  | ALUSTSG                                                                     |
  | Command ===>                                                                |
  |                                                                             |
  | You have requested that this Tablespace be converted to Partition           |
  | by Growth. The following actions must be taken prior to conversion:         |
  |                                                                             |
  |   All but 1 partition must be dropped                                       |
  |   DSSize must have a non-zero value (Default is 4G)                         |
  |   Segsize must have a non-zero value (Default is 4)                         |
  |                                                                             |
  |                                                                             |
  | Would you like for the product to perform these actions for you?            |
  | Y (Y-Yes, N-No)                                                            |
  |                                                                             |
  | F1=HELP        F2=SPLIT       F3=EXIT        F4=CKPANELS    F9=SWAP        |
  | F12=PREVIOUS                                                                |
  +-----------------------------------------------------------------------------+
2. To have the product perform the following actions, press END:
  - Delete all of the partitions except the first partition.
  - Set the value of DSSIZE to 4 GB.
  - Set the value of SEGSIZE to 4.
  Success
  Tip
  You can change the value of DSSIZE and SEGSIZE on the Tablespace Parts List panel.
3. In the Maxpartitions field, type the maximum number of partitions for the partition-by-growth table space.
4. Press END.

To convert to an implicit database or table space

If you are converting to an implicit database or table space, perform one of the following tasks:

To make the database implicit, edit the table in the table space and change the name of the database to <DEFLT>. The table space name will automatically change to <DEFLT>.
To make only the table space implicit, edit the table in the table space and change the name of the table space to <DEFLT>.

To change the partitioned indexes

If partitioned indexes exist in the table space, you must convert the indexes to nonpartitioned indexes.

On the Mixed List, type E in the Act column adjacent to an index that you want to convert.
On the Index Detail panel, type S to select Partitions.
On the Index Parts List, in the Act column, type D adjacent to all of the partitions except the first one and press Enter.
For the partitioning status, select Non-Partitioned.
Press END.Now that the table space has been converted, you can analyze a work ID and execute a worklist.