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 Server Configuration utility (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

1. 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.
2. Use the Siebel Database Storage Configurator (dbconf.xls) to modify the storage control file, changing the mode of the table spaces to partitioned.
3. Run the Database Server Configuration utility 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.
4. Manually drop the temporary table space that you created in Step 1.

To convert nonpartitioned tables to partitioned tables using alternate tools

• You can use alternate tools (for example, BMC Change Manager or IBM Compare Utility) to convert nonpartitioned tables to partitioned table spaces. In this case, after applying all changes, change the schema version by executing the following SQL:

  update S_APP_VER

  set CUSTOM_SCHEMA_VER = char(integer(CUSTOM_SCHEMA_VER) + 1)

  This SQL is stored in ddlview.sql and can be executed outside of the Siebel application.