Home > Veritas Storage Foundation™ for DB2 Manual Pages

QIO_GETDBFILES_DB2_ALL (1M)

Maintenance Commands

NAME
SYNOPSIS
AVAILABILITY
DESCRIPTION
OPTIONS
EXAMPLES
USAGE
SEE ALSO

NAME

qio_getdbfiles_db2_all - retrieves the database files to be converted to Quick I/O files for a partitioned DB2 database

SYNOPSIS

qio_getdbfiles_db2_all [ -d directory ]

AVAILABILITY

This command is part of Veritas Storage Foundation for Databases.

To determine whether Veritas Storage Foundation for DB2 is installed on a Solaris system, enter:

pkginfo -l VRTSdb2ed

DESCRIPTION

This command is DB2-specific and is available in the /opt/VRTSdb2ed/bin directory. It is used to identify DB2 container files that are eligible to be converted to Quick I/O files for a partitioned DB2 database in an SMP environment. The eligible DB2 container files will be written to the mkqio.dat file, one mkqio.dat file will be created for each partition.

If no option is specified, a NODEpartition_number directory will be created for each partition underneath the current directory and a mkqio.dat will be created in each of the NODEpartition_number directory.

To use these commands the DB2DATABASE environment variable must be set.

While the database instance is up and running, run the qio_getdbfiles_db2_all command to get a list of files used by the database. This command stores the file names and sizes in bytes in the file mkqio.dat, one mkqio.dat file is created for each partition.

After running the qio_getdbfiles_db2_all command, shut down the database and run the qio_convertdbfiles command to convert the list of file names in the mkqio.dat files to Quick I/O files. For more information, see the qio_convertdbfiles(1M) man page. To convert the database files to Quick I/O files for all partitions, you can use either one of these methods: 1. change to each NODEpartition_number directory and run the qio_convertdbfiles command for each partition. 2. consolidate all the mkqio.dat files for all partitions into one mkqio.dat file and execute qio_convertdbfiles only once with the consolidated file.

OPTIONS

The following options are supported by qio_getdbfiles_db2_all:

-d directory: Specify the directory in which the NODEpartition_number/mkqio.dat files will reside.

EXAMPLES

To get a list of d2 container files that will be converted to Quick I/O files, use the qio_getdbfiles_db2_all as follow:

$/opt/VRTSdb2ed/bin/qio_getdbfiles_db2_all

mkqio.dat files are created under ./NODE<num> directory.

$/opt/VRTSdb2ed/bin/qio_getdbfiles_db2_all -d /tmp/proddb

mkqio.dat files are created under /tmp/proddb/NODE<num> directory.

USAGE

You must be logged in as the database instance owner to run qio_getdbfiles_db2_all. The qio_getdbfiles_db2_all command queries the database to gather a list of datafiles to be converted, which requires direct access to the database.

QIO_GETDBFILES_DB2_ALL (1M)

Table of contents