VERITAS File SystemÖ 3.5 (HP OnlineJFS/JFS3.5) AdministratorÆs Guide (December 2002)

Chapter 8

Quick I/O for Databases

Using Quick I/O with Sybase Databases

Quick I/O works similarly on Sybase database devices.

To create a new database device, preallocate space on the file system by using the qiomkfile command, then

use the Sybase buildmaster command for a master device, or the Transact SQL disk init command for a

database device. qiomkfile creates two files: a regular file using preallocated, contiguous space, and a

symbolic link pointing to the ::cdev:vxfs: name extension. For example, to create a 100 megabyte master

device masterdev on the file system /sybmaster, enter:

$ cd /sybmaster

$ qiomkfile -s 100m masterdev

You can use this master device while running the sybsetup program or sybinit script. If you are creating the

master device directly, type:

$ buildmaster -d masterdev -s 51200

To add a new 500 megabyte database device datadev to the file system /sybdata on your dataserver, enter:

$ cd /sybdata

$ qiomkfile -s 500m datadev

...

$ isql -U

-P

sa_password -S dataserver_name

1> disk init

2> name =

“logical_name”

3> physname = “

/sybdata/datadev

”,

4> vdevno = “

device_number

”,

5> size = 256000

6> go

Enabling and Disabling Quick I/O

If the Quick I/O feature is licensed and installed, Quick I/O is enabled by default when a file system is

mounted. Alternatively, the VxFS mount -o qio command enables Quick I/O. The mount -o noqio

command disables Quick I/O.

If Quick I/O is not installed or licensed, a file system mounts by default without Quick I/O and no error

message is displayed. However, if you specify the -o qio option, the mount command terminates without

mounting the file system.