Sybase Central and database management

Sybase Central is a database management tool installed with Sybase IQ. You can use it to start Sybase IQ servers and create databases. It exposes database settings, properties, and utilities in a graphical user interface.

NoteYou must use Sybase Central version 6.0, which ships with Sybase IQ 15.1, to administer Sybase IQ 15.1 servers and databases.

Database administration tasks typically fall into two categories:

Sybase Central provides an interface for both kinds of tasks.

Data definition tasks that you can carry out with Sybase Central can also be carried out using DBISQL to send SQL statements to the database engine or server. (See Reference: Statements and Options for SQL statement syntax.) However, since administrating a multiplex requires managing multiple servers or message agents on multiple systems sharing a single IQ Store, you must coordinate some activities. Therefore Sybase recommends that certain functions, such as creating multiplex databases and query servers, be performed using Sybase Central. See Chapter 5, “Working with Database Objects,” Working with Database Objects in the System Administration Guide: Volume 1 for details.

Database Administration Utilities

For more information about Sybase IQ utilities, see Chapter 3, “Database Administration Utilities” in the Utility Guide.

NoteThis version of Sybase IQ supports only Sybase Central Java Edition, which is shortened to “Sybase Central” throughout this book. Although Sybase Central Java Edition can also be used to manage other Sybase databases, this chapter describes only how to use Sybase Central Java Edition with Sybase IQ databases. Please see your product documentation for information about Sybase Central support.