Determining the location, type, and size of a database device

Adaptive Server requires several database devices. Table 1-1 below shows baseline values for each of the devices. See the release bulletin for any last minute changes to these values.

Table 1-1: Adaptive Server database devices

Device

Purpose

Minimum size

Minimum recommended size

master

Stores system databases

24MB for 2K pages

45MB for 4K pages

89MB for 8K pages

177MB for 16K pages

30MB 60MB 120MB 240MB

sysprocsdev (also called the sybsystemprocs device)

Stores the sybsystemprocs database

136MB

140MB (plus any space for holding stored procedures that you have created)

sybsystemdb

Transaction processing

3MB for 2K pages

6MB for 4K pages

12MB for 8K pages

24MB for 16K pages

5 – 24MB

sybsecurity (optional)

Required for auditing

10MB or size of the model database (the larger of the two)

Depends on specific auditing needs; see “Adding auditing”