Merging Partitions

Merge adjacent range partitions or subpartitions in a table.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	Table owned by self – none. Table owned by other users – you must have one of: DBA authority ALTER permission on the table
SAP Sybase IQ 16.0	Table owned by self – none. Table owned by other users – you must have 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 must be 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 left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables.
Select an IQ main store table from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Table Properties view appears.
In the left pane, 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.
Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.