Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment >
Converting Nonpartitioned Tables to Partitioned Tables
Siebel Business Applications support two scenarios for converting nonpartitioned tables to partitioned tables.
NOTE: In the following scenarios, source table refers to your current nonpartitioned table, and target table refers to the destination partitioned table.
- Source table and target table are defined in different table spaces.
If the source table and target table are defined in different table spaces, and the target table space is a new table space that does not yet exist in your current database, no special action is required. Run the two utilities available in the Database Configuration Wizard (Migrate Repository and Synchronize Schema Definition) to automatically rebuild the table in the new partitioned table space and drop the original table.
- Source table and target table are defined in the same table space.
Database operations do not support rebuilding a table space from nonpartitioned to partitioned. Therefore, if the source table and target table are defined in the same table space (for example, if you used the dbconf.xls spreadsheet to convert an existing table space from nonpartitioned to partitioned), you must perform one of the following procedures (as appropriate for your configuration) to convert the nonpartitioned table to a 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 the original table space.
- Use the Siebel Database Storage Configurator (dbconf.xls) to modify the storage control file, changing the mode of the table spaces to partitioned. See About Modifying Storage Control Files for further information.
- Run the Database Configuration Wizard and select the Migrate Repository option. 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