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

■ Create a file named sa_password_dataserver_name (where dataserver_name

is server defined in the $DSQUERY environment variable) in the

/opt/VRTSsybed/.private directory which contains the sa password. The

.private directory must be owned by the Sybase database administrator user

(typically sybase) and carry a file permission mode of 700. The

sa_password_dataserver_name file must also be owned by the Sybase database

administrator user, and carry a file permission mode of 600. Once the

sa_password_dataserver_name file is correctly set up, users will not be

prompted for the sa password, and the convert commands will run in

non-interactive mode.

For the qio_getdbfiles command:

■ You can use the qio_getdbfiles command to generate lists of files from one

or more databases.

For the qio_convertdbfiles command:

■ To use the qio_convertdbfiles command with the -f option (the option that

lets you report fragmentation), you must be superuser (root).

■ Converting existing database files to Quick I/O files may not be the optimal

thing to do if these files are fragmented. Use the -f option to determine the

fragmentation levels and either:

■ Exclude files which are highly fragmented and do not have sufficient

contiguous extents for Quick I/O use.

■ Create new files with the qiomkfile command, rather than converting the

files using the qio_convertdbfiles command. The new files are contiguous.

When the new files are created, you can move data from the old files to the

new files using the dd(1M) command or a database import facility and the

new files defined to the database.

To set the Sybase environment variables and NLSPATH

◆

Set the required Sybase environment and message catalog variables, as

follows:

$ SYBASE=/home_directory; export SYBASE

$ DSQUERY=servername; export DSQUERY

$ PATH=$SYBASE/ASE-12_5/bin:$SYBASE/OCS-12_5/bin:$PATH; \

export PATH

$ LD_LIBRARY_PATH=$SYBASE/OCS-12_5/lib; export LD_LIBRARY_PATH

$ NLSPATH=/usr/lib/locale/%L/%N:$NLSPATH; export NLSPATH

Improving Sybase performance with Veritas Quick I/O

Converting Sybase files to Quick I/O files