VERITAS File System 4.1 Administrator's Guide

Quick I/O for Databases
Cached Quick I/O For Databases
Chapter 11174
NOTE This command enables caching for all the Quick I/O files on this file system.
You can make this setting persistent across mounts by adding a file system entry in the file
/etc/vx/tunefstab. For example:
/dev/vx/dsk/datadg/database01 qio_cache_enable=1
/dev/vx/dsk/datadg/database02 qio_cache_enable=1
For information on how to add tuning parameters, see the tunefstab(4) manual page.
Enabling Cached Quick I/O for Individual Files
There are several ways to enable caching for a Quick I/O file.Use the following syntax to
enable caching on an individual file:
$ qioadmin -S filename=on mount_point
To enable caching for the Quick I/O file /database01/names.dbf, enter:
$ qioadmin -S names.dbf=ON /database01
To disable the caching for that file, enter:
$ qioadmin -S names.dbf=OFF /database01
To make the setting persistent across mounts, create a qiotab file, /etc/vx/qioadmin, to list
files and their caching advisories. Based on the following example, the file
/database/sell.dbf will have caching turned on whenever the file system /database is
mounted:
device=/dev/vx/dsk/datadg/database01
dates.dbf,off
names.dbf,off
sell.dbf,on
NOTE The cache advisories operate only if Cached Quick I/O is enabled for the file
system. If the qio_cache_enable flag is zero, Cached Quick I/O is OFF for all
the files in that file system even if the individual file cache advisory for a file is
ON.
To check on the current cache advisory settings for a file, enter:
$ qioadmin -P names.dbf /database01