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

To convert the Sybase files to Quick I/O files

Shut down the Sybase dataserver.

Caution: Running the qio_convertdbfiles command while the database is

up and running can cause severe problems with your database, including loss

of data, and corruption.

Supply the sa password when prompted, or create a file named

sa_password_dataserver_name in the /opt/VRTSsybed/.private directory

which contains the sa password.

Run the qio_convertdbfiles command from the directory containing the

mkqio.dat file:

$ cd /extract_directory

$ /opt/VRTSsybed/bin/qio_convertdbfiles

The list of files in the mkqio.dat file is displayed, for example:

/sybdev/L001/SYS/master.dat

104857600

/sybdev/L001/USER/qiofile1

209715200

/sybdev/L001/USER/qiofile2

209715200

/sybdev/L001/USER/qiofile3

209715200

/sybdev/L001/USER/qiofile4

209715200

/sybdev/L001/SYS/sysporcs.dat

83886080

The qio_convertdbfiles command (with no options specified) renames the

file <filename> to .<filename> and creates a symbolic link to .<filename>

with the Quick I/O extension. By default, the symbolic link uses a relative

path name.

The qio_convertdbfiles command and prints an error message if any of

the dataserver files are not on a VxFS file system. If this error occurs, you

must remove any non-VxFS files from the mkqio.dat file before running the

qio_convertdbfiles command again.

Start the database.

You can now access these dataserver files using the Quick I/O interface.

Improving Sybase performance with Veritas Quick I/O

Converting Sybase files to Quick I/O files