Tools for managing Sybase IQ databases are Sybase Central, Sybase Control Center, and Interactive SQL.
Sybase Central is a graphical application for managing database objects. You can use Sybase Central to perform common administrative tasks such as creating databases, backing up databases, adding users, adding tables and indexes, enabling databases for multiplex capability, and monitoring database performance. Sybase Central has a Java-based graphical user interface, and can be used with any operating system that allows graphical tools.
Interactive SQL is a utility that allows you to enter SQL statements interactively and send them to a database, or execute them as scripts. Interactive SQL has two forms: Java-based dbisql and the Open Client utility iqisql.
The Introduction to Sybase IQ explains how to use Sybase Central and Interactive SQL to perform simple administrative tasks. If you are not already familiar with these tools, you should read about them in the Introduction to Sybase IQ and use the tutorials provided there.
Sybase Control Center for Sybase IQ is a Web-based tool for managing and monitoring Sybase IQ single-node and multiplex servers. The two main features are administration and monitoring.
The Sybase Control Center architecture allows a small number of Sybase Control Center servers to monitor all Sybase IQ servers in an enterprise using the Sybase Control Center agent.
The Sybase Control Center agent is installed with each Sybase IQ server.
See Sybase Control Center 3.2.0 > Sybase Control Center for Sybase IQ.
In addition to these tools, Sybase IQ provides a number of stored procedures that perform system management functions. You can also create your own procedures and batches. You may wish to take advantage of IQ’s event-handling capability to develop your own system management tools.
See System Administration Guide: Volume 2 > Automating Tasks Using Schedules and Events.
A few administrative tasks, such as selecting a collation, rely on command-line utilities described in the Utility Guide.