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 you 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, verify the following
condiitons are met:
■ Recover your database before attempting to recreate the Quick I/O
files.
■ Log in as the Database Administrator (typically, the user ID sybase)
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 SYBASE and DSQUERY environment variables must be set.
See “Converting Sybase files to Quick I/O files” on page 64.
Sybase
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/VRTSsybed/bin/qio_recreate
You do 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
Improving Sybase performance with Veritas Quick I/O
Recreating Quick I/O files after restoring a database
74