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: