Identifying VxFS files to convert to Quick I/O using qio_getdbfiles
Prev About the command line interface Next

Identifying VxFS files to convert to Quick I/O using qio_getdbfiles

You can use the qio_getdbfiles command to identify VxFS files before converting them to Quick I/O files. Only VxFS files may be converted to Quick I/O.

Note:

This command is not available in Veritas Storage Foundation for DB2 on Linux.

The qio_getdbfiles command queries the database and gathers a list of datafiles to be converted to Quick I/O. The command requires direct access to the database.

Before using the qio_getdbfiles command, 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.

Usage notes

  • The -T option 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.

  • The -a option specifies that all datafiles should be included. By default, potential sparse files are excluded.

  • See the qio_getdbfiles(1M) manual page for more information.

  • See the qio_getdbfiles(1M) manual page for more information.

To identify the VxFS files to convert to Quick I/O

  1. Use the qio_getdbfiles command as follows:

    S /opt/VRTSdb2ed/bin/qio_getdbfiles [-T ora|syb|db2]
    $ /opt/VRTSsybed/bin/qio_getdbfiles [-T syb] \
[-d <database_name>] [-m <master_device_pathname>]

    where -T syb forces behavior for Sybase, <database_name> specifies the database device files, and <master_device_pathname> specifies the full path name of the master device for the Sybase ASE server.

    The qio_getdbfiles command stores the filenames and file sizes in bytes in a file called mkqio.dat.

  2. View the mkqio.dat file:

    $ cat mkqio.dat

    The mkqio.dat file contains the database filenames that can be converted to Quick I/O files. The format of the file is a list of paired file paths and file sizes. For example:

    /database/dbfiles.001 1024000
    /database/dbfiles.002 2048000
Prev Up Next
Relocating tablespaces for Database Dynamic Storage Tiering using dbdst_tbs_move Home Converting VxFS files to Quick I/O using qio_convertdbfiles