Overview of Sybase IQ System Administration

Understanding Sybase® IQ design and functionality provides a foundation for system administration.

• Audience
  Sybase IQ system administrators manage database setup, connections, loading, security, backup, and troubleshooting.
• Sybase IQ Design and Purpose
  Sybase IQ is a high-performance decision support server designed specifically for data warehousing.
• Tools for System Administration
  Tools for managing Sybase IQ databases are Sybase Central, Sybase Control Center, and Interactive SQL.
• The Database Server
  The database server is the “brain” of your Sybase IQ system.
• Data Storage in Sybase IQ
  Tablespaces, dbspaces, dbfiles, and stores are units in which Sybase IQ stores data.
• SQL Anywhere and Sybase IQ
  SQL Anywhere is a relational database system that can exist with or without IQ.
• Security Overview
  Sybase IQ provides security controls by means of the privileges you can assign to users.
• Concurrent Operations
  Sybase IQ allows multiple users to query a database at the same time, while another user inserts or deletes data, or backs up the database.
• Multiplex Capability
  Multiplex is a powerful feature in Sybase IQ that allows you to scale your applications by using multiple machines in a clustered system to mount and open a single IQ database residing on a shared disk storage.
• Stored Procedures
  Sybase IQ stored procedures give you information about your database and users and carry out various operations on the database.
• System Tables and Views
  Sybase IQ system tables and views are objects that contain all of the information the database server needs to manage your Sybase IQ system. System views present the information from their corresponding system tables in a more readable format.
• Commands and Functions
  All Sybase IQ commands are SQL statements. SQL stands for Structured Query Language, a language commonly used in database applications.
• Message Log Contents
  An IQ message log file exists for each database to capture messages from the server about operations.
• The Utility Database
  The utility database never holds data, but is created automatically for performing certain administrative tasks.
• Scalability
  Sybase IQ’s patented design permits databases to scale to contain many terabytes of data.