The sybsystemdb device, The sysprocsdev device, Optional devices and databases – Sybase DC35823-01-1500-04 User Manual
Page 22
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: