Preallocating Space for Quick I/O Files Using the setext Command

As an alternative to using the qiomkfile command, you can also use the VxFS setext command to preallocate space for database files.

Prerequisites

• The setext command requires superuser (root) privileges.

Usage Notes

• You need to use the chown and chgrp commands to change the owner and group permissions on the file after you create it.
• See the setext(1M) manual page for more information.

  To create a Quick I/O database file using setext

1. Access the VxFS mount point and create a file:
      # cd /mount_point
      # touch .filename
2. Use the setext command to preallocate space for the file:
   # /opt/VRTS/bin/setext -r size -f noreserve -f chgsize \
   .filename
3. Create a symbolic link to allow databases or applications access to the file using its Quick I/O interface:
      # ln -s .filename::cdev:vxfs: filename
4. Change the owner and group permissions on the file:
      # chown oracle .filename
      # chgrp dba .filename
      # chmod 660 .filename

Example

To access the mount point /db01, create a datafile, preallocate the space, and change the permissions: