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

Note: It is recommended that you create a Storage Checkpoint before converting
to or from Quick I/O.
See “Creating a Storage Checkpoint” on page 275.
Before converting database files to Ouick I/O files, the following conditions must
be met:
■ Log in as the DB2 instance owner (typically, the user ID db2inst1)
to run the qio_getdbfiles and qio_convertdbfiles
commands.
■ You must predefine the DB2 environment variable $DB2DATABASE.
■ The SFDB repository must exist before you can convert to Quick
I/O files. Run the db2ed_update command to update or create
the repository.
■ Files you want to convert must be regular files on VxFS file systems
or links that point to regular VxFS files
Prerequisites
■ Converting existing database files to Quick I/O files may not be
the best choice if the files are fragmented. Use the -f option to
determine the fragmentation levels and choose one of two
approaches: Either exclude files that are highly fragmented and
do not have sufficient contiguous extents for Quick I/O use, or
create new files with the qiomkfile command, rather than
convert them with the qio_convertdbfiles command.
■ If you choose to create new files, they will be contiguous. You must
then move data from the old files to the new files using the DB2
database export/import facility db2move or restore redirect,
and then define the new files to the database.
■ qio_getdbfiles skips any tablespaces that have a type of system
managed space (SMS), as these tablespaces are based on a directory
format and not suitable for conversion.
The qio_getdbfiles command retrieves a list of database files
and saves them in a file named mkqio.dat in the current directory.
■ Instead of using the qio_getdbfiles command, you can
manually create the mkqio.dat file containing the DB2 instance
filenames that you want to convert to Quick I/O files.
■ The qio_convertdbfiles command 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.
Usage notes
The following options are available for the qio_getdbfiles command:
45Improving DB2 performance with Veritas Quick I/O
Converting DB2 containers to Quick I/O files