Adaptive server devices and system databases, The master device – Sybase DC35823-01-1500-04 User Manual

Page 21

Advertising
background image

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.

Advertising