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.
Device |
Purpose |
Minimum size |
Minimum recommended size |
|---|---|---|---|
master |
Stores system databases |
14MB for 2K pages 27MB for 4K pages 50MB for 8K pages 105MB for 16K pages |
30MB 60MB 120MB 240MB |
sysprocsdev (also called the sybsystemprocs device) |
Stores the sybsystemprocs database |
100MB |
100MB (plus any space for holding stored procedures that you have created) |
sybsystemdb |
Transaction processing |
4MB |
5 – 20MB |
sybsecurity (optional) |
Required for auditing |
0–5MB |
7MB; more for specialized auditing |
By default, Adaptive Server 12.5 opens database devices
with the O_SYNC flag to ensure recoverability in the event
of power failure, operating system crash or Adaptive Server crash.
This significantly affects performance. You can turn off the O_SYNC
flag by starting the server with -T1623 trace flag.
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, Windows NT, and Linux.
You may need to repartition the disk you choose. Contact your operating system administrator for assistance.
Sybase recommends that to configure raw devices, you
use Adaptive Server version 12.5.0.1 released on kernel 2.4.7 and
deploy it on a system with at least the same operating system release
level.
For a description of how to configure Adaptive Server for raw devices, see Appendix B, “Creating Raw Partitions.”
