Validating a System Store Table

Check the validity of a system store (IQ catalog store) table. This feature is available only for tables in the system store.

Prerequisites
Database Version Table Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • VALIDATE authority
SAP Sybase IQ 16.0 You must have the VALIDATE ANY OBJECT system privilege.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables.
  3. Select one or more tables from the right pane and either:
    • Click the arrow to the right of the name and select Validate, or
    • From the Administration Console menu bar, select Resource > Validate.
    Use Shift-click or Control-click to select multiple tables.
    The Validate Tables view appears indicating the validation status of each selected table.
    If the table does not validate, try one of these solutions:
    • Drop all the indexes and keys on a table and recreate them. Recreate any foreign keys to the table.
    • If you suspect a particular index, you can execute an ALTER INDEX ... REBUILD statement to rebuild the corrupted index.
    • Unload and reload your entire database.
  4. 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.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table with No Partitions in the IQ Main Store
Creating a Table with No Partitions in the IQ (Catalog) System Store
Creating a Table with a Hash Partition
Creating a Table with a Range Partition
Creating a Table with a Hash-Range Partition
Creating a Global Temporary Table
Creating a Proxy Table
Viewing Table Data in the Execute SQL Window
Deleting a Table
Generating Table DDL Commands
Moving a Table to Another Dbspace
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Enabling or Disabling Row-Level Versioning in a Table
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Executing a SQL Query
Authenticating a Login Account for a Managed Resource
Related reference
Table Privilege Summary