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 sa -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
|
