Veritas File System 4.1 Administrator's Guide (HP-UX 11i v3, February 2007)

Quick I/O for Databases
Cached Quick I/O For Databases
Chapter 11158
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
names.dbf,OFF
To check the setting of the qio_cache_enable flag for a file system, enter:
$ vxtunefs -p /database01