Typically, the database administrator (DBA) is responsible for the tasks listed in Table 1.
To help you manage your database, Sybase IQ provides two primary tools:
Sybase Central is an application for managing Sybase databases. It helps you manage database objects and 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.
DBISQL, also called Interactive SQL, is an application that allows you to enter SQL statements interactively and send them to a database. DBISQL has a window-like user interface on all platforms. Sybase IQ supports both a Java-based DBISQL, and the C-based DBISQL provided in previous releases.
The Introduction to Sybase IQ explains how to use Sybase Central and DBISQL 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.
In addition to these tools, Sybase IQ provides a number of stored procedures that perform system management functions. See “Stored procedures” for more information. 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 Chapter 6, “Automating Tasks Using Schedules and Events,” in System Administration Guide: Volume 2 for details.
In addition to the stored procedures, Sybase IQ provides a tool to monitor the performance of its buffer caches. This monitor collects statistics on the buffer cache, memory, and I/O functions taking place within Sybase IQ, and stores them in a log file. See Performance and Tuning Guide for details.
A few administrative tasks, such as selecting a collation, rely on command-line utilities. These utilities are discussed in other chapters of this book, and described in the Utility Guide.
