Sybase DC35823-01-1500-04 manual Adaptive Server database devices

CHAPTER 1 Introduction

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

		Minimum	Minimum
Device	Purpose	size	recommended size
master	Stores system	24MB for 2K pages	30MB
	databases	45MB for 4K pages	60MB
			120MB
		89MB for 8K pages
			240MB
		177MB for 16K
		pages
sysprocsdev	Stores the	120MB	120MB (plus any
(also called the	sybsystemprocs		space for holding
sybsystemprocs	database		stored procedures that
device)			you have created)
sybsystemdb	Transaction	3MB for 2K pages	5 – 24MB
	processing	6MB for 4K pages
		12MB for 8K pages
		24MB for 16K pages
sybsecurity (optional)	Required for	5MB	7MB; more for
	auditing		specialized auditing

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.

Configuration Guide 9