As an alternative to using the qiomkfile command, you can also use the VxFS setext command to preallocate space for database files.
Before preallocating space with setext, make sure the following conditions have been met:
To create a Quick I/O database file using setext
Access the VxFS mount point and create a file:
# cd /mount_point
# touch .filename
Use the setext command to preallocate space for the file:
# /opt/VRTS/bin/setext -r size -f noreserve -f chgsize \ .filename
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
Change the owner and group permissions on the file:
# chown db2inst1:db2iadm1 .filename
# chmod 660 .filename
An example to show how to access the mount point /db01, create a container, preallocate the space, and change the permissions:
# cd /db01 # touch .dbfile # /opt/VRTS/bin/setext -r 100M -f noreserve -f chgsize .dbfile # ln -s .dbfile::cdev:vxfs: dbfile
# chown db2inst1:db2iadm1 .dbfile
# chmod 660 .dbfile