Home > Veritas Storage Foundation™ for DB2 Manual Pages
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 ]
[ -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
which are available in the
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
To use these commands the
environment variable must be set.
For general usage information for the
see the corresponding man pages.
The following options are supported by the
Reports on current fragmentation levels for files listed in the
Fragmentation is reported at four levels:
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
(which are guaranteed not to be fragmented)
and converting the data from the old files
(using a command such as
Creates extra links for all database files and log files in the
directory to support the SAP
Changes Quick I/O files back to regular files.
Use this option to undo changes
made by a previous run of the
Uses absolute pathnames.
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.
command must query the database to gather
a list of datafiles to be converted,
which requires direct access to the database.
command expects all files to be owned by the instance owner.
command with any option but
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.
Veritas Storage Foundation for DB2 Administrator's Guide
Last updated: 4 Nov 2004
Copyright ©2009 Symantec Corporation
All rights reserved.