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 Requires one of:
  • DBA authority.
  • VALIDATE authority.
SAP Sybase IQ 16.0 Requires VALIDATE ANY OBJECT system privilege.
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 > 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. Click OK.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table
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