Extending a Quick I/O file in a DB2 environment
| Article:HOWTO59730 | | | Created: 2011-10-13 | | | Updated: 2011-10-13 | | | Article URL http://www.symantec.com/docs/HOWTO59730 |
Although Quick I/O files must be preallocated, they are not limited to the preallocated sizes. You can grow or "extend" a Quick I/O file by a specific amount or to a specific size, using options to the qiomkfile command. Extending Quick I/O files is a fast, online operation and offers a significant advantage over using raw devices.
Before extending a Quick I/O file, make sure the following conditions have been met:
The following options are available with the qiomkfile command:
-e | Extends the file by a specified amount to allow DB2 container resizing. |
-r | Increases the file to a specified size to allow DB2 container resizing. |
To extend a Quick I/O file
If required, ensure the underlying storage device is large enough to contain a larger VxFS file system (see the vxassist(1M) manual page for more information), and resize the VxFS file system using fsadm command:
Extend the Quick I/O file using the qiomkfile command:
$ /opt/VRTS/bin/qiomkfile -e extend_amount /mount_point/filename
$ /opt/VRTS/bin/qiomkfile -r newsize /mount_point/filename
An example to show how to grow VxFS file system:
/db01 to 500MB and extend the tbs1_cont001 Quick I/O file by 20MB:
$ /opt/VRTS/bin/qiomkfile -e 20M /db01/tbs1_cont001
# /opt/VRTS/bin/fsadm -b 500M /db01
An example to show how to grow VxFS file system:
/db01 to 500MB and resize the tbs1_cont001 Quick I/O file to 300MB:
$ /opt/VRTS/bin/qiomkfile -r 300M /db01/tbs1_cont001
# /opt/VRTS/bin/fsadm -b 500M /db01
|
|
Legacy ID
uxrt-51sp1_v44778284_v63475581
Article URL http://www.symantec.com/docs/HOWTO59730
Terms of use for this information are found in Legal Notices
Thank you.