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

To convert the DB2 database files to Quick I/O files

Make the database inactive by either shutting down the instance or disabling

user connections.

Warning: Running the qio_convertdbfiles command while the database is

up and running can cause severe problems with your database, including loss

of data and corruption.

Run the qio_convertdbfiles command from the directory containing the

mkqio.dat file:

$ cd /extract_directory

$ export DB2DATABASE=database_name

$ /opt/VRTSdb2ed/bin/qio_convertdbfiles

The list of files in the mkqio.dat file is displayed. For example:

file1 --> .file1::cdev:vxfs:

file2 --> .file2::cdev:vxfs:

file3 --> .file3::cdev:vxfs:

file4 --> .file4::cdev:vxfs:

file5 --> .file5::cdev:vxfs:

Run the qio_convertdbfiles command (with no options specified) to rename

the file filename to .filename and creates a symbolic link to .filename with

the Quick I/O extension. By default, the symbolic link uses a relative path

name.

The qio_convertdbfiles script exits and prints an error message if any of

the database files are not on a VxFS file system. If this happens, you must

remove any non-VxFS files from the mkqio.dat file before running the

qio_convertdbfiles command again.

Make the database active again.

You can now access these database files using the Quick I/O interface.

Improving DB2 performance with Veritas Quick I/O

Converting DB2 containers to Quick I/O files