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

If Quick I/O is not available in the kernel, or a Veritas Storage Foundation Standard

or Enterprise product license is not installed, a file system mounts without Quick

I/O by default, the Quick I/O file name is treated as a regular file, and no error

message is displayed. If, however, you specify the -o qio option, the mount

command prints the following error message and terminates without mounting

the file system.

VxFDD: You don't have a license to run this program

vxfs mount: Quick I/O not available

Depending on whether you are creating a new database or are converting an

existing database to use Quick I/O, you have the following options:

If you are creating a new DB2 database to use Quick I/O:

■ You can use the qiomkfile command to preallocate space for database files

and make them accessible to the Quick I/O interface.

■ You can use the setext command to preallocate space for database files and

create the Quick I/O files.

If you are converting an existing database:

■ You can create symbolic links for existing VxFS files, and use these symbolic

links to access the files as Quick I/O files.

See “Accessing regular VxFS files as Quick I/O files” on page 43.

■ You can convert your existing DB2 database files to use the Quick I/O interface

using the qio_getdbfiles and qio_convertdbfiles commands.

See “Converting DB2 containers to Quick I/O files” on page 44.

Creating database containers as Quick I/O files using

qiomkfile for DB2

You can create Database Managed Space (DMS) containers with the type 'DEVICE'

using Quick I/O. 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.

■ You can create Quick I/O files only on VxFS file systems.

■ If you are creating containers on an existing file system, run fsadm

(or similar utility) to report and eliminate fragmentation.

■ You must have read/write permissions on the directory in which

you intend to create DB2 Quick I/Ofiles.

Prerequisites

Improving DB2 performance with Veritas Quick I/O

Creating database containers as Quick I/O files using qiomkfile for DB2