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

Extending a Quick I/O file in a DB2 environment ................................ 51
Monitoring tablespace free space with DB2 and extending tablespace
containers ............................................................................ 52
Recreating Quick I/O files after restoring a database ........................... 55
Disabling Quick I/O ...................................................................... 56
Chapter 4 Improving Sybase performance with Veritas Quick
I/O ..................................................................................... 57
How to set up Quick I/O ................................................................. 57
Preallocating space for Quick I/O files using the setext
command ............................................................................. 58
Creating database files as Quick I/O files with qiomkfile ..................... 59
Accessing regular VxFS files as Quick I/O files ................................... 62
Converting Sybase files to Quick I/O files .......................................... 64
Displaying Quick I/O status and file attributes ................................... 71
Extending a Quick I/O file in a Sybase environment ............................ 72
Recreating Quick I/O files after restoring a database ........................... 74
Disabling Quick I/O ...................................................................... 75
Chapter 5 Improving DB2 database performance with Veritas
Cached Quick I/O ........................................................... 77
Tasks for setting up Cached Quick I/O .............................................. 77
Enabling Cached Quick I/O on a file system ....................................... 78
Enabling and disabling the qio_cache_enable flag ........................ 78
Making Cached Quick I/O settings persistent across reboots and
mounts .......................................................................... 79
Using vxtunefs to obtain tuning information ............................... 80
Determining candidates for Cached Quick I/O ................................... 81
Collecting I/O statistics ........................................................... 82
About I/O statistics ................................................................ 83
Effects of read-aheads on I/O statistics ....................................... 84
Other tools for analysis ........................................................... 84
Enabling and disabling Cached Quick I/O for individual files ................ 85
Setting cache advisories for individual files ................................ 85
Making individual file settings for Cached Quick I/O
persistent ....................................................................... 86
Determining individual file settings for Cached Quick I/O using
qioadmin ........................................................................ 86
Contents8