Sybase ASE Structure

Sybase ASE Structure

System and Databases:

This paper describes the system databases that reside on all Adaptive Server systems. It also describes optional Sybase-supplied databases that you can install, and a database that Sybase Technical Support may install for diagnostic purposes.

Overview of system databases :

When you install Adaptive Server, it includes these system databases:
* The master database
* The model database
* The system procedure database, sybsystemprocs
* The temporary database, tempdb

Optionally, you can install:
* The auditing database, sybsecurity
* The two-phase commit transaction database, sybsystemdb
* The sample databases, pubs2 and pubs3
* The dbcc database, dbccdb

The master, model, and temporary databases reside on the device named during installation, which is known as the master device. The master database is contained entirely on the master device and cannot be expanded onto any other device. All other databases and user objects should be created on other devices.

Note : Do not store user databases on the master device. Storing user databases on the master device makes it difficult to recover the system databases if they become damaged. Also, you will not be able to recover user databases stored on the master device.

You should install the sybsecurity and sybsystemdb databases on their own devices and segment.
You can install the sybsystemprocs database on a device of your choice. You may want to modify the installation scripts for pubs2 and pubs3 to share the device you create for sybsystemprocs.

The installpubs2 and the installpubs3 scripts do not specify a device in their create database statement, so they are created on the default device. At installation time, the master device is the default device.

Master Database :

The master database controls the operation of Adaptive Server and stores information about all user databases and their associated database devices.
Because the