Merging Partitions

Merge adjacent range partitions in a table.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	Table owned by self – None required. Table owned by other users – Requires one of: DBA authority. ALTER permission on the table.
SAP Sybase IQ 16.0	Table owned by self – None required. Table owned by other users – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. ALTER permission on the table.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
You are licensed for the Very Large Database Management option (IQ_VLDBMGMT).
Partitions are adjacent and reside in the same dbspace. No data movement is required.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables, select the table in the right pane, click the drop-down arrow that appears beside the table name, and select Properties.
Select Partitions.
Select a single range or hash-range partition from the list and click Merge.
Select an adjacent partition from the drop-down list and click OK. The drop-down list is empty if no lower or higher partition exists in the same dbspace.
Click Apply or OK to complete the merge.