Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment >
Converting Nonpartitioned Tables to Partitioned Tables
Siebel eBusiness Applications support two scenarios for converting nonpartitioned tables to partitioned tables.
NOTE: In the procedures below, source table refers to your current nonpartitioned table, and target table refers to the destination partitioned table.
To convert to a nonpartitioned table for a partitioned table space configuration
- Use your preferred database tool to manually move every nonpartitioned table (every table that you intend to convert) to a temporary table space, and then drop their original table spaces.
- Use the dbconfig.xls utility to modify the storage control file, changing the mode of the table spaces to partitioned.
- Run the Siebel Software Configuration Utility: Migrate Development to Production. This process automatically rebuilds the source tables in the new partitioned table space and drops the original nonpartitioned table.
- Manually drop the temporary table space that you created in Step 1.
To convert nonpartitioned tables to partitioned tables using alternate tools