Converting VxFS files to Quick I/O using qio_convertdbfiles<a class="indexterm" name="id465773"></a><a class="indexterm" name="id465777"></a><a class="indexterm" name="id465784"></a><a class="indexterm" name="id465791"></a>


Converting VxFS files to Quick I/O using qio_convertdbfiles
Prev	About the command line interface	Next

Converting VxFS files to Quick I/O using qio_convertdbfiles

After running qio_getdbfiles, you can use the qio_convertdbfiles command to convert database files to use Quick I/O. This command is for use with VxFS file systems only.

The qio_convertdbfiles command converts regular files or symbolic links that point to regular files on VxFS file systems to Quick I/O. The qio_convertdbfiles command converts only those files listed in the mkqio.dat file to Quick I/O. The mkqio.dat file is created by running qio_getdbfiles. It can also be created manually.

Before converting files, 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.
Remove any non-VxFS files from mkqio.dat before running qio_convertdbfiles. The qio_convertdbfiles command will display an error message if any of the database files in mkqio.dat are not on a VxFS file system.

Usage notes

The qio_convertdbfiles command expects all files to be owned by the database administrator.
Converting existing database files to Quick I/O is not recommended if the files are fragmented. In this case, it is recommended that you create new files with the qiomkfile command (these files are guaranteed not to be fragmented) and then convert the data from the old files (using a command such as dd).
Ensure that the database is shut down before running qio_convertdbfiles.
See the qio_convertdbfiles(1M) manual page for more information.

Table: qio_convertdbfiles command options lists options for the qio_convertdbfiles command.

Table: qio_convertdbfiles command options

Option	Description
-T	Forces the behavior for a specific database type. The database options that are supported are ora, syb, and db2. Use this option in environments with more than one type of database.
-a	Changes regular files to Quick I/O files using absolute pathnames. Use this option when symbolic links need to point to absolute pathnames. By default, relative pathnames are used.
-f	Reports on current fragmentation levels for files listed in mkqio.dat. Fragmentation is reported at four levels: not fragmented, slightly fragmented, fragmented, and highly fragmented.
-h	Displays a help message.
-i	Creates extra links for all database files and log files in the /dev directory to support the SAP command.
-u	Changes Quick I/O files back to regular files.

To convert VxFS files to Quick I/O files

After running the qio_getdbfiles command, shut down the database:

Warning:

Running qio_convertdbfiles with any option except -f while the database is up and running can cause severe problems for your database, including data loss and corruption. Make sure the database is shut down before running the qio_convertdbfiles command.

Run the qio_convertdbfiles command to convert the list of files in mkqio.dat to Quick I/O files:
```
$ /opt/VRTSdb2ed/bin/qio_convertdbfiles
```
You must remove any non-VxFS files from mkqio.dat before running qio_convertdbfiles. The qio_convertdbfiles command will display an error message if any of the database files in mkqio.dat are not on a VxFS file system.
Restart the database to access these database files using the Quick I/O interface.

To undo a previous run of qio_convertdbfiles

Use the qio_convertdbfiles as follows:
```
$ /opt/VRTSdb2ed/bin/qio_convertdbfiles -u
```
```
.dbfile::cdev:vxfs: --> dbfile
```
This reverts a previous run of qio_convertdbfiles and changes Quick I/O files back to regular VxFS files.

If the database is up and running, an error message will be displayed stating that you need to shut it down before you can run qio_convertdbfiles.

Prev	Up	Next
Identifying VxFS files to convert to Quick I/O using qio_getdbfiles	Home	Recreating Quick I/O files using qio_recreate