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

To extract a list of DB2 containers to convert
◆
With the database instance up and running, run the qio_getdbfiles command
from a directory for which you have write permission:
$ cd /extract_directory
$ export DB2DATABASE=database_name
$ /opt/VRTSdb2ed/bin/qio_getdbfiles
The qio_getdbfiles command extracts the list file names from the database
system tables and stores the file names and their size in bytes in a file called
mkqio.dat under the current directory.
Note: Alternatively, you can manually create the mkqio.dat file containing
the DB2 database container names that you want to convert to use Quick I/O.
You can also manually edit the mkqio.dat file generated by qio_getdbfiles,
and remove files that you do not want to convert to Quick I/O files.
Note: To run the qio_getdbfiles command, you must have permission to
access the database and permission to write to the /extract_directory.
The mkqio.dat list file should look similar to the following:
/data11r1/VRTS11r1/redo01.log 52428800
/data11r1/VRTS11r1/redo02.log 52428800
/data11r1/VRTS11r1/redo03.log 52428800
/data11r1/VRTS11r1/sysaux01.dbf 632553472
/data11r1/VRTS11r1/system01.dbf 754974720
/data11r1/VRTS11r1/undotbs01.dbf 47185920
/data11r1/VRTS11r1/users01.dbf 5242880
/data11r1/nqio1.dbf 104857600
47Improving DB2 performance with Veritas Quick I/O
Converting DB2 containers to Quick I/O files