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 4.3, which ships with Sybase IQ 12.6, to administer Sybase IQ 12.6 servers and databases. You must use Sybase Central version 3.2, which ships with earlier versions of Sybase IQ, to administer earlier versions.

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 the Sybase IQ Reference Manual 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,” in the Sybase IQ System Administration Guide for details.

For more information about Sybase IQ utilities, see Chapter 3, “Database Administration Utilities,” in the Sybase IQ 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.