When you install Adaptive Server, it includes these system databases:
The master database
The model database
The system procedure database, sybsystemprocs
The two-phase commit transaction database, sybsystemdb
The temporary database, tempdb
Optionally, you can install:
The auditing database, sybsecurity
The sample databases, pubs2 and pubs3
The dbcc database, dbccdb
The Job Scheduler database, sybmgmtdb
For information about installing the master, model, sybsystemprocs, tempdb, and sybmgmtdb databases, see the installation documentation for your platform. For information on installing dbccdb, see Chapter 10, “Checking Database Consistency.” For information about using Job Scheduler, see the Job Scheduler User’s Guide.
The master, model, sybsystemdb, 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.
WARNING! 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 cannot recover user databases stored on the master device.
You should install the sybsecurity and sybmgmtdb databases on their own devices and segment. For more information, see the installation documentation for your platform.
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.
You install the sybmgmtdb database with the installjsdb script (located in $SYBASE/ASE-15_0/scripts). 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, Sybase 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. At installation time, the master device is the default device. To change this, you can either edit the scripts or follow the instructions in Chapter 7, “Initializing Database Devices,” for information about adding more database devices and designating default devices.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
