Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

To create a database file as a Quick I/O file using qiomkfile
1
Create a database file using the qiomkfile command:
$ /opt/VRTS/bin/qiomkfile -s file_size /mount_point/filename
2
Add a device to the Sybase dataserver device pool for the Quick I/O file using
the disk init command:
$ isql -Usa -Psa_password -Sdataserver_name
> disk init
> name=”device_name”,
> physname=”/mount_point/filename”,
> vdevno=”device_number”,
> size=51200
> go
> alter database production on new_device=file_size
> go
The size is in 2K units. The Enterprise Reference manual contains more
information on the disk init command.
See the Sybase Adaptive Server Enterprise Reference Manual.
3
Use the file to create a new segment or add to an existing segment.
To add a new segment:
$ isql -Usa -Psa_password -Sdataserver_name
> sp_addsegment new_segment, db_name, device_name
> go
To extend a segment:
$ isql -Usa -Psa_password -Sdataserver_name
> sp_extendsegment segment_name, db_name, device_name
> go
See the Sybase Adaptive Server Enterprise Reference Manual.
An example to show how to create a 100MB database file named dbfile on the
VxFS file system /db01 using a relative path name:
$ /opt/VRTS/bin/qiomkfile -s 100m /db01/dbfile
$ ls -al
-rw-r--r-- 1 sybase sybase 104857600 Oct 2 13:42 .dbfile
lrwxrwxrwx 1 sybase sybase 19 Oct 2 13:42 dbfile -> \
.dbfile::cdev:vxfs:
61Improving Sybase performance with Veritas Quick I/O
Creating database files as Quick I/O files with qiomkfile