The sybsystemdb device, The sysprocsdev device, Optional devices and databases – Sybase DC35823-01-1500-04 User Manual

Page 22

Advertising
background image

Adaptive Server devices and system databases

6

Adaptive Server Enterprise

The sample databases,

pubs2

and

pubs 3

, are stored on the master device

at installation, but should be moved to a user-defined device after
installation.

Note

For recovery purposes, Sybase recommends that you do not create

other system or user databases or user objects on the master device.

The sybsystemdb device

For new installations the

master

device also contains the

sybsystemdb

database. The

sybsystemdb

device stores the

sybsystemdb

database, which

stores information about transactions in progress, and which is also used during
recovery.

The

sybsystemdb

database is required to support distributed transaction

management (DTM) features. Before installation, make sure you have enough
space available on the default segment to support

sybsystemdb

.

The sysprocsdev device

The sybprocsdev devices stores the

sybsystemprocs

database, which contains

most of the Sybase-supplied system procedures. System procedures are a
collection of SQL statements and flow-of-control statements that perform
system tasks, for example,

sp_configure

.

The system procedures that are needed during recovery situations are stored in
the

master

database.

Note

sysprocsdev

is the default system name for this device. However, it is

frequently referred to as the

sybsystemprocs

device, since it stores the

sybsystemprocs

database.

Optional devices and databases

The devices and databases described in the following sections are optional.

The sample
databases

The sample databases are:

Advertising