Recreating Quick I/O files after restoring a database


Recreating Quick I/O files after restoring a database
Prev	Using Veritas Quick I/O	Next

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:

Prerequisites	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.
Usage notes	The qio_recreate command supports only conventional Quick I/O files. Refer to the qio_recreate(1M) manual page for more information.

To recreate Quick I/O files after recovering a database

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:

If...	Then...
a Quick I/O file is missing	the Quick I/O file is recreated.
a symbolic link from a regular VxFS file to a Quick I/O file is missing	the symbolic link is recreated.
a symbolic link and its associated Quick I/O file are missing	both the link and the Quick I/O file are recreated.
a Quick I/O file is missing and the regular VxFS file that it is symbolically linked to is not the original VxFS file	the Quick I/O file is not recreated and a warning message is displayed.
a Quick I/O file is smaller than the size listed in the mkqio.dat file	the Quick I/O file is not recreated and a warning message is displayed.

Prev	Up	Next
Monitoring tablespace free space with DB2 and extending tablespace containers	Home	Disabling Quick I/O