Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

Converting Sybase files to Quick I/O files

Special commands are provided to assist you in identifying and converting an

existing database to use Quick I/O. Use the qio_getdbfiles and

qio_convertdbfiles commands to first extract and then convert Sybase

dataserver files to Quick I/O files.

■ Log in as the Database Administrator (typically, the user ID

sybase) to run the qio_getdbfiles and qio_convertdbfiles

commands.

■ Files you want to convert must be regular VxFS files created by

Sybase ASE 12.0 or later and have the Sybase dsync flag on.

Regular VxFS files created without the dsync flag on may be

sparse. Sparse files should not be converted to Quick I/O files.

■ Sybase ASE Server must be installed and running.

■ The conversion commands were developed to support localization,

so you need to set the NLSPATH to obtain the proper message

catalog.

■ For Sybase ASE 12.0, the $SYBASEenvironment variable must be

set to the Sybase home directory

For Sybase ASE 12.0, the $DSQUERY environment variable must

be set to the server on which you intend to run the

qio_getdbfiles command

For Sybase ASE 12.0, the $PATH environment variable must include

$SYBASE/ASE-12_0/bin and $SYBASE/OCS-12_0/bin

For Sybase ASE 12.0, the$LD_LIBRARY_PATH environment variable

must include $SYBASE/OCS-12_0/lib

For Sybase ASE 12.5, you must set the following Sybase

environment variables:

$SYBASE must be set to the Sybase home directory

$DSQUERY must be set to the server on which you intend to run

the qio_getdbfiles command

$PATH must include $SYBASE/ASE-12_5/bin and

$SYBASE/OCS-12_5/bin

$LD_LIBRARY_PATH must include $SYBASE/OCS-12_5/lib

Only English is supported in the current release.

Prerequisites

For the qio_getdbfiles command:

Enables you to specify a specific database name from which to extract

a list of dataserver files. If you do not specify the -d option, the list

of files comes from all databases of the Sybase server. You cannot use

this option with the -m option.

-d

Improving Sybase performance with Veritas Quick I/O

Converting Sybase files to Quick I/O files