Viewing or Modifying Table Partition Properties

View table partition details or change the table partition details and definition of an existing table partition.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	View any table partition property page – none. Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have one of: DBA authority SPACE ADMIN authority CREATE permission on the dbspace to which the partition is being moved along with one of: ALTER permission on the underlying table You own the table Modify any other table partition property: 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	View any table partition property page – none. Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege MANAGE ANY DBSPACE system privilege One of the following: CREATE ANY OBJECT system privilege CREATE permission on the dbspace to which the partition is being moved Along with one of: ALTER permission on the underlying table You own the underlying table Modify any other table partition property: 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

Database Version

Table Partition Privileges

SAP Sybase IQ 15.3 and 15.4

View any table partition property page – none.

Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have one of:

DBA authority
SPACE ADMIN authority
CREATE permission on the dbspace to which the partition is being moved along with one of:
- ALTER permission on the underlying table
- You own the table

Modify any other table partition property:

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

View any table partition property page – none.

Modify any table partition property pertaining to moving partition location or separate column storage for a partition – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
MANAGE ANY DBSPACE system privilege
One of the following:
- CREATE ANY OBJECT system privilege
- CREATE permission on the dbspace to which the partition is being moved
- Along with one of:
  - ALTER permission on the underlying table
  - You own the underlying table

Modify any other table partition property:

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).

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 partition from the list and click Edit.
View or modify table partition properties. The properties differ depending on the partition type.
- When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
- If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.

Click OK.

The Properties view appears.

Hash Partition Properties

Area	Description
General	These properties cannot be edited. Name – Hash (Hash partitions are unnamed.). Type – Hash. Composite – N/A for a hash partition.. Partition key – Name of column(s) for the partition key.

Area

Description

General

These properties cannot be edited.

Name – Hash (Hash partitions are unnamed.).

Type – Hash.

Composite – N/A for a hash partition..

Partition key – Name of column(s) for the partition key.

Range Partition Properties

Area	Description
General	Name – Name of the range partition. Type – Range. Composite – N/A. Partition key – Name of the column for the partition key. Value – Value of the range partition. Dbspace – Dbspace that contains the range partition.
Columns	Column details for columns contained by the range partition. See Managing Column Storage in Table Partition Properties.

Area

Description

General

Name – Name of the range partition.

Type – Range.

Composite – N/A.

Partition key – Name of the column for the partition key.

Value – Value of the range partition.

Dbspace – Dbspace that contains the range partition.

Columns

Column details for columns contained by the range partition. See Managing Column Storage in Table Partition Properties.

Hash-Range Partition Properties

Area	Description
General	Name – Name of the hash-range partition. Type – Range. Composite – Hash-Range. Partition key – Name of the hash-range partition. Value – Value of the hash-range partition. Dbspace – Dbspace that contains the hash-range partition.
Column	Column details for columns contained by the hash- range partition. See Managing Column Storage in Table Partition Properties.

Area

Description

General

Name – Name of the hash-range partition.

Type – Range.

Composite – Hash-Range.

Partition key – Name of the hash-range partition.

Value – Value of the hash-range partition.

Dbspace – Dbspace that contains the hash-range partition.

Column

Column details for columns contained by the hash- range partition. See Managing Column Storage in Table Partition Properties.

Tip: You can modify changes in progress before they commit by clicking Properties and then making corrections.

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.