Overview of System Databases

A default SAP ASE installation includes a number of system databases.

Optionally, you can install:

For information about installing the master, model, sybsystemprocs, tempdb, and sybmgmtdb databases, see the installation guide for your platform. For information about installing dbccdb, see System Administration Guide: Volume 2 > Checking Database Consistency. For information about using Job Scheduler, see the Job Scheduler Users Guide.

The master, model, sybsystemdb, and temporary databases reside on the master device which is named during installation. The master database must be contained entirely on the master device and cannot be expanded onto any other device. Create all other databases and user objects on other devices.

Warning!   Do not store user databases on the master device; doing so makes it difficult to recover both the system databases and any user databases stored on the master device.

Install the sybsecurity and sybmgmtdb databases on their own devices and segment. See the installation documentation for your platform.

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.

Use the installjsdb script (located in $SYBASE/ASE-15_0/scripts) to install the sybmgmtdb database. installjsdb looks for a device named sybmgmtdev on which to create the sybmgmtdb database and its accompanying tables and stored procedures. If the sybmgmtdb database already exists, installjsdb creates the Job Scheduler tables and stored procedures in the existing database. If installjsdb cannot find either a sybmgmtdev device or a sybmgmtdb database, it creates sybmgmtdb on the master device. However, SAP strongly recommends that you remove the sybmgmtdb database from the master device.

The installpubs2 and the installpubs3 scripts do not specify a device in their create database statement, so they are created on the default device. During installation, the master device is the default device. To change this, edit the scripts.