Home > Veritas Storage Foundation™ for DB2 Manual Pages


User Commands

Table of contents


qio_getdbfiles_db2 - retrieve database files for Quick I/O conversion

qio_convertdbfiles_db2 - convert database files to Quick I/O files


qio_getdbfiles_db2 [ -d directory ] [ -h ]

qio_convertdbfiles_db2 [ -f | -i | -u | -a | -h ]


This command is part of Veritas Storage Foundation for DB2. To determine whether this product is installed on an \1 system, type:

lslpp -L VRTSdb2ed


These commands are the DB2-specific version of the qio_getdbfiles and qio_convertdbfiles commands, which are available in the /opt/VRTSdb2ed/bin directory. These commands are used to identify DB2 Database Managed Space container files and convert them to Quick I/O files.

Note: Veritas Storage Foundation for DB2 on 1 does not support converting existing DB2 containers or VxFS files to or from Quick I/O files due to a DB2 limitation.

In a DB2 environment, these commands are called directly by the qio_getdbfiles and qio_convertdbfiles commands. To use these commands the DB2DATABASE environment variable must be set.

For general usage information for the qio_getdbfiles or qio_convertdbfiles commands, see the corresponding man pages.


The following options are supported by the qio_convertdbfiles_db2 command:
Reports on current fragmentation levels for files listed in the mkqio.dat file. Fragmentation is reported at four levels: not fragmented, slightly fragmented, fragmented, and highly fragmented.

Converting existing database files to Quick I/O files may not be the optimal thing to do if these files are fragmented. In this case, creating new files with the qiomkfile command (which are guaranteed not to be fragmented) and converting the data from the old files (using a command such as dd) is recommended.

Creates extra links for all database files and log files in the /dev directory to support the SAP brbackup command.
Changes Quick I/O files back to regular files. Use this option to undo changes made by a previous run of the qio_convertdbfiles command.
Uses absolute pathnames.
-d directory
Create the mkqio.dat file in the specified directory instead of the current directory. By default, the mkqio.dat file is created in the current directory.
Shows command usage.


You must be logged in as the DB2 instance owner to run these commands. The qio_getdbfiles_db2 command must query the database to gather a list of datafiles to be converted, which requires direct access to the database. The qio_convertdbfiles_db2 command expects all files to be owned by the instance owner.

Running the qio_convertdbfiles_db2 command with any option but -f while the database is up and running can cause data loss and database corruption. Make sure the DB2 database instance is shut down before running this command.


dd(1M), qio_convertdbfiles(1M), qio_getdbfiles(1M), vxgrowfs(1M), db2_edition(7)

Veritas Storage Foundation for DB2 Administrator's Guide

Last updated: 4 Nov 2004
Copyright ©2009 Symantec Corporation
All rights reserved.