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

To create a Quick I/O database file using setext

Access the VxFS mount point and create a file:

# cd /mount_point

# touch .filename

Use the setext command to preallocate space for the file:

# /opt/VRTS/bin/setext -r size -f noreserve -f chgsize \

.filename

Create a symbolic link to allow databases or applications access to the file

using its Quick I/O interface:

# ln -s .filename::cdev:vxfs: filename

Change the owner and group permissions on the file:

# chown sybase:sybase .filename

# chmod 660 .filename

An example to show how to access the mount point for Sybase /db01, create

a datafile, preallocate the space, and change the permissions:

# cd /db01

# touch .dbfile

# /opt/VRTS/bin/setext -r 100M -f noreserve -f chgsize .dbfile

# ln -s .dbfile::cdev:vxfs: dbfile

# chown sybase:sybase .dbfile

# chmod 660 .dbfile

Creating database files as Quick I/O files with

qiomkfile

The best way to preallocate space for tablespace containers and to make them

accessible using the Quick I/O interface is to use the qiomkfile. You can use the

qiomkfile to create the Quick I/O files for either temporary or permanent

tablespaces.

59Improving Sybase performance with Veritas Quick I/O

Creating database files as Quick I/O files with qiomkfile