GENERATE_PARTITION_SCHEME

GENERATE_PARTITION_SCHEME_SQL

The GENERATE_PARTITION_SCHEME_SQL administration method is available to administrators and superusers. These additional restrictions apply:

The method is available only on version 6.5 repositories.

Running the method generates a script, which can then be run to partition the repository. The GENERATE_PARTITION_SCHEME_SQL administration method has three options:

DB_PARTITION (Database Partition)
Generate a script to upgrade or convert a non-partitioned repository to a Documentum 6.5 partitioned repository.
ADD_PARTITION (Add Partition)
Add a partition to a partitioned type.
EXCHANGE_PARTITION (Exchange Partition)
Generate a script for bulk ingestion by loading data from an intermediate table into a new partition of a partitioned table.

To run the GENERATE_PARTITION_SCHEME_SQL administration method:

Navigate to Administration > Job Management > Administration Methods.
The system displays the Administration Methods list page.
Click GENERATE_PARTITION_SCHEME_SQL.
The system displays the Parameters page.
Enter parameters for the method, as described in Table 7.16.
Click Run to execute the method.
The GENERATE_PARTITION_SCHEME_SQL method creates a script object in the /Temp folder in the repository when the method successfully completes. The partition script is not automatically executed; you must execute it separately.
Click Close to return to the Administration Methods list page.

Table 7.16. GENERATE_PARTITION_SCHEME_SQL parameters

Parameter	Description
Operation	Select an operation from the dropdown list box to define the subcommand. The options are: DB_PARTITION: Generates a script to upgrade or convert a repository to a 6.5 partitioned repository. If selected: Select Partition Type or Table Name. If Table Name is defined, optionally define the Owner Name. Include object type is optional. Select to apply the partition operation to the dmi_object_type table. Last Partition and Last Tablespace are optional. In the Partitions section, Partition Name, Range, and Tablespace are required. ADD_PARTITION: Generates a script to add a partition to a partitioned type. If selected: Select Partition Type or Table Name. If Table Name is defined, optionally define the Owner Name. Include object type is optional. Select to apply the partition operation to the dmi_object_type table. In the Partitions section, Partition Name, Range, and Tablespace are required. EXCHANGE_PARTITION: Generates a script for bulk ingestion by loading data from an intermediate table into a new partition of a partitioned table. If selected: Partition Type and Table Name are mutually exclusive. If Table Name is defined, optionally define the Owner Name. Include object type is optional. Select to apply the partition operation to the dmi_object_type table. Partition Name, Range, and Tablespace are required. Temp Table Suffix is optional.
Partition Type	Select a partition type from the dropdown list box, which displays a list of the partition types available for the repository. Allis the default for DB_PARTITION and ADD_PARTITION, but is not available for EXCHANGE_PARTITION. If you select Partition Type, then you cannot select Table Name.
Table Name	Type a table name. If you select Table Name, then you cannot select Partition Type.
Include object type	Optionally, select to apply the partition operation to the dmi_object_type table.
Owner Name	Type an owner name. This field is enabled only if Table Name is selected.
Last Partition	Optionally, type a name for the last partition. This field appears only when DB_PARTITION is selected as the operation.
Last Tablespace	Optionally, type a tablespace name for the last partition. This field appears only when DB_PARTITION is selected as the operation.
Partition Name	Type a name for the partition. For DB_PARTITION and ADD_PARTITION operations, you must first click Add in the Partitions section to add information for each partition.
Range	Type the upper limit for the partition key range. For DB_PARTITION and ADD_PARTITION operations, you must first click Add in the Partitions section to add information for each partition.
Tablespace	Type the partition tablespace name. If not specified, the default tablespace is used. For DB_PARTITION and ADD_PARTITION operations, you must first click Add in the Partitions section to add information for each partition.
Temp Table Suffix	Type a temporary table suffix. This field is enabled and optional only if EXCHANGE_PARTITION is selected as the operation.