Sybase Adaptive Server, Configuration Manual

Page: 21 / 150

CHAPTER 1 Introduction
Configuration Guide
5
When using the source files: SYBASE.csh or SYBASE.sh, the following
paths are prepended to the LIBPATH environment variable:
$SYBASE/$SYBASE_ASE/lib:$SYBASE/$SYBASE_OCS/
lib: $SYBASE/SYBASE_FTS/lib, etc.
Adaptive Server devices and system databases
Devices are files or portions of a disk that are used to store databases and
database objects. You can initialize devices using raw disk partitions or
operating system files.
Adaptive Server requires the following devices:
•
master
– to store system databases.
•
sybsystemdb
– to store information about distributed transaction.
•
sysprocsdev
– to store system procedures.
The master, sybsystemdb, and sysprocsdev devices are created when you
create a new Adaptive Server.
The master device
The master device contains the following databases:
•
master
– controls the operation of Adaptive Server as a whole and stores
information about all users, user databases, devices, objects, and system
table entries. The
master
database is contained entirely on the master
device and cannot be expanded onto any other device.
•
model
– provides a template for new user databases. The
model
database
contains required system tables, which are copied into a new user database
with the
create database
command.
•
tempdb
– the work area for temporary databases in Adaptive Server.
Adaptive Server supports multiple
tempdb
s. See “create temporary
database” in the T-SQL User’s Guide. Each time Adaptive Server is
started, the
tempdb
database is cleared and rebuilt from the
model
database.