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

Recreating Quick I/O files after restoring a database
If you need to restore your database and were using Quick I/O files, you can use
the qio_recreate command to automatically recreate the Quick I/O files after
you have performed a full database recovery. The qio_recreate command uses
the mkqio.dat file, which contains a list of the Quick I/O files used by the database
and the file sizes.
For information on recovering your database, refer to the documentation that
came with your database software.
Before recreating Quick I/O with the qio_recreate command, make sure the
following conditions have been met:
■ Recover your database before attempting to recreate the Quick I/O
files.
■ Log in as the DB2 instance owner (typically, the user ID db2inst1)
to run the qio_recreate command.
■ In the directory from which you run the qio_recreate command,
you must have an existing mkqio.dat file.
■ The DB2DATABASE environment variable must be set.
See “Converting DB2 containers to Quick I/O files” on page 44.
DB2 Prerequisites
■ The qio_recreate command supports only conventional Quick
I/O files.
■ Refer to the qio_recreate(1M) manual page for more
information.
Usage notes
To recreate Quick I/O files after recovering a database
◆
As DBA, use the qio_recreate command as follows:
$ /opt/VRTSdb2ed/bin/qio_recreate
You will not see any output if the command is successful.
When you run the qio_recreate command, the following actions occur:
Then...If...
the Quick I/O file is recreated.a Quick I/O file is missing
the symbolic link is recreated.a symbolic link from a regular VxFS file to a
Quick I/O file is missing
both the link and the Quick I/O file are
recreated.
a symbolic link and its associated Quick I/O
file are missing
55Improving DB2 performance with Veritas Quick I/O
Recreating Quick I/O files after restoring a database