Filter
Top Products
CHAPTER 1 Introduction
Configuration Guide 9
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
For Solaris, HP-UX, IBM AIX, and Linux
For all databases you can use either a raw partition or a file.
Sybase Adaptive Server supports the database devices on NFS- and
CIFS-mounted devices with Network Appliance Filers for storing data.
Network appliance filers provide the same performance and data integrity as
raw devices. There are no changes needed to the operating system or to Sybase
Adaptive Server to use network appliance filers.
NFS mounted devices have been tested on Solaris, HP-UX, IBM AIX, and
Linux.
For All Platforms
You may need to repartition the disk you choose. Contact your operating
system administrator for assistance.
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
120MB 120MB (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
5MB 7MB; more for
specialized auditing