CHAPTER 1 Introduction

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 tempdbs. 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.

Configuration Guide

5

Page 21
Image 21
Sybase DC35823-01-1500-04 manual Adaptive Server devices and system databases, Master device