Recreating Quick I/O files using qio_recreate<a class="indexterm" name="id466397"></a><a class="indexterm" name="id466401"></a><a class="indexterm" name="id466408"></a>


Recreating Quick I/O files using qio_recreate
Prev	About the command line interface	Next

Note:

This command is not available in Veritas Storage Foundation for DB2 on Linux.

You can use the qio_recreate command to automatically recreate Quick I/O files when the database is recovered.

Before converting files to Quick I/O, the following conditions must be met:

Prerequisites

To use this command for DB2, the DB2DATABASE environment variable must be set.

You must be logged in as the instance owner to use this command.

Usage notes

The qio_recreate command expects to find a file named mkqio.dat in the directory where the command is run. The mkqio.dat file contains a list of the Quick I/O files used by the database and their sizes. If the mkqio.dat file is not in the directory, you will be prompted to create it using qio_getdbfiles.

See Identifying VxFS files to convert to Quick I/O using qio_getdbfiles.
The qio_recreate command supports conventional Quick I/O files only (that is, Quick I/O files in the following form: file --> .file::cdev:vxfs:). In creating a Quick I/O file, the qio_convertdbfiles command renames the regular VxFS file, file, to .file with the Quick I/O extension (:cdev::vxfs:) and creates a symbolic link to it. By default, the symbolic link uses a relative path name.
There are no options for the qio_recreate command and no output is returned when the command runs successfully.
See the qio_recreate(1M) manual page for more information.

The qio_recreate command follows these rules in recreating Quick I/O files when a database is recovered:

If a Quick I/O file (.file::cdev:vxfs:) is missing, then qio_recreate recreates it.
If both a symbolic link (file) and its associated Quick I/O file (.file::cdev:vxfs:) are missing, qio_recreate recreates both the symbolic link and the Quick I/O file.
If a symbolic link (file) from a regular VxFS file to its associated Quick I/O file (.file::cdev:vxfs:) is missing, then qio_recreate recreates the symbolic link.
If a Quick I/O file (.file::cdev:vxfs:) is missing and the regular VxFS file that is symbolically linked to it is not the same one that originally created it, then qio_recreate issues a warning message and does not recreate the Quick I/O file.
If a Quick I/O file (.file::cdev: vxfs:) is smaller than the size listed in mkqio.dat, qio_recreate issues a warning message.

To automatically recreate Quick I/O files when the database is recovered

Use the qio_recreate command as follows:
```
$ /opt/VRTSdb2ed/bin/qio_recreate
```

Prev	Up	Next
Converting VxFS files to Quick I/O using qio_convertdbfiles	Home	Appendix B. Using third-party software to back up files