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.

# chmod 660 .filename

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

container, 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 db2inst1:db2iadm1 .dbfile

# chmod 660 .dbfile

Accessing regular VxFS files as Quick I/O files

You can access regular VxFS files as Quick I/O files using the ::cdev:vxfs: name

extension.

While symbolic links are recommended because they provide easy file system

management and location transparency of database files, the drawback of using

symbolic links is that you must manage two sets of files (for instance, during

database backup and restore).

43Improving DB2 performance with Veritas Quick I/O

Accessing regular VxFS files as Quick I/O files