Download View this book as PDF

Chapter 2
Installation Requirements
dsync option on by default for database device files
The dsync option is used with the disk init and disk reinit commands. By default,
Adaptive Server enables dsync for database device files. This option ensures
that Adaptive Server can recover data from devices on file systems. However,
dsync can cause a degradation in performance for device files that experience
high write activity.
When you install a new 12.x Adaptive Server, by default dsync is set on for all
devices.
When you upgrade a UNIX server that stores databases on UNIX file system
devices, by default dsync is set:
•
on for the master device
•
off for all other devices.
See also, sp_deviceattr, and sp_helpdevice in the Reference Manual.
Determining the location, type, and size of a database device
Adaptive Server requires several database devices. Table 2-13 below shows
baseline values for each of the devices. See the release bulletin for any
last-minute changes to these values.
Table 2-13: Adaptive Server database devices
Minimum
size
Minimum
recommended size
Stores system
databases
14MB for 2K pages
27MB for 4K pages
50MB for 8K pages
105MB for 16K
pages
30MB
60MB
120MB
240MB
sysprocsdev
Stores the
100MB
(also called the
sybsystemprocs
sybsystemprocs
database
100MB (plus any
space for holding
stored procedures that
you have created)
4MB
5 – 20MB
5MB
7MB; more for
specialized auditing
Device
Purpose
master
device)
sybsystemdb
sybsecurity (optional)
Transaction
processing
Required for
auditing
For all databases you can use either a raw partition or a file.
27