Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008
Depending on whether you are creating a new database or are converting an
existing database to use Quick I/O, you have the following options:
If you are creating a new database:
■ You can use the qiomkfile command to preallocate space for database files
and make them accessible to the Quick I/O interface.
See “Creating database files as Quick I/O files using qiomkfile” on page 79.
■ You can use the setext command to preallocate space for database files and
create the Quick I/O files.
See “Preallocating space for Quick I/O files using the setext command”
on page 81.
If you are converting an existing database:
■ You can create symbolic links for existing VxFS files, and use these symbolic
links to access the files as Quick I/O files.
See “Accessing regular VxFS files as Quick I/O files” on page 83.
■ You can convert your existing Oracle database files to use the Quick I/O
interface using the qio_getdbfiles and qio_convertdbfiles commands.
See “Converting Oracle files to Quick I/O files” on page 84.
Creating database files as Quick I/O files using
qiomkfile
The best way to preallocate space for tablespace containers and to make them
accessible using the Quick I/O interface is to use the qiomkfile. You can use the
qiomkfile to create the Quick I/O files for either temprory or permanent
tablespaces.
■ You can create Quick I/O files only on VxFS file systems.
■ If you are creating database files on an existing file system, run
fsadm (or similar utility) to report and eliminate fragmentation.
■ You must have read/write permissions on the directory in which
you intend to create Oracle Quick I/O files.
Prerequisites
■ The qiomkfile command creates two files: a regular file with
preallocated, contiguous space, and a file that is a symbolic link
pointing to the Quick I/O name extension.
■ See the qiomkfile(1M) manual page for more information.
Usage notes
79Using Veritas Quick I/O
Creating database files as Quick I/O files using qiomkfile