Managing Column Storage in a Table Partition

Store data for individual columns in a range or hash-range partition separately from the dbspace for the partition.

Prerequisites
Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires 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 required.
  • Table owned by other users – Requires one of:
    • DBA authority.
    • ALTER permission on the table.
SAP Sybase IQ 16.0 View any table partition property page – None required.
Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires 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 required.
  • Table owned by other users – Requires one of:
    • ALTER ANY TABLE system privilege.
    • ALTER ANY OBJECT system privilege.
    • ALTER permission on the table.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Schema Objects > Tables.
  3. Select Tables, select a base table in the right pane, click the drop-down arrow that appears beside the table name, and select Properties. (Global temporary tables and proxy tables cannot be partitioned.)
  4. Select Partitions.
  5. Select a hash-range or range partition from the list and click Edit.
  6. On the Columns page, click Add to specify new column storage for an existing partition. Select a column and click Delete to remove a column storage definition or Move to move the column data to a different dbspace or back to the partition dbspace.
    • Moving column data to a new dbspace adds the column to the list of those with separate storage, in Partition Properties and in the Partitions page of Table Properties. Moving the column back to the partition dbspace removes the column from those lists.
    • When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
    • If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
  7. Click Apply.
Parent topic: Table Partitions
Related tasks
Creating a Hash Partition
Creating a Range Partition
Creating a Hash-Range Partition
Deleting a Partition
Unpartitioning a Table
Merging Partitions
Splitting Partitions
Moving a Partition
Viewing or Modifying Table Partition Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Partition Privilege Summary