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

Improving DB2

performance with Veritas

Quick I/O

This chapter includes the following topics:

■ How to set up Quick I/O

■ Creating database containers as Quick I/O files using qiomkfile for DB2

■ Preallocating space for Quick I/O files using the setext command

■ Accessing regular VxFS files as Quick I/O files

■ Converting DB2 containers to Quick I/O files

■ About sparse files

■ Displaying Quick I/O status and file attributes

■ Extending a Quick I/O file in a DB2 environment

■ Monitoring tablespace free space with DB2 and extending tablespace containers

■ Recreating Quick I/O files after restoring a database

■ Disabling Quick I/O

How to set up Quick I/O

Quick I/O is included in the VxFS package shipped with Veritas Storage Foundation

Standard and Enterprise products. By default, Quick I/O is enabled when you

mount a VxFS file system.

Chapter