Home > Veritas Storage Foundation™ for DB2 Manual Pages
QIO_GETDBFILES_DB2 (1) |
|
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:
-
-f
-
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.
-
-i
-
Creates extra links for all database files and log files in the
/dev
directory to support the SAP
brbackup
command.
-
-u
-
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.
-
-a
-
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.
-
-h
-
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.