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

■ Monitor the free space available in the Quick I/O file, and grow the
file as necessary with the qiomkfile command.
■ A Database Administrator can grow underlying VxFS file systems
online (provided the underlying disk or volume can be extended)
using the fsadm command. See the fsadm (1M) manual page for
more information.
■ It is strongly recommended that if a DB2 tablespace is running out
of space, that all containers are grown by the same amount. It is
possible to add extra containers to the tablespace, but this results
in DB2 performing a relayout of the data to balance usage across
all available containers in the tablespace.
Also refer to the DB2 Administration Guide section on Managing
Storage and the DB2 SQL Reference Guide for information on the
ALTER TABLESPACE command.
Usage notes
To monitor the free space available in a DB2 tablespace
◆
Use the following DB2 commands:
$ db2 connect to database
$ db2 list tablespaces show detail
$ db2 terminate
To extend a Quick I/O file using qiomkfile
◆
Use the qiomkfile command to extend the Quick I/O file (if the container is
running low on free blocks):
$ /opt/VRTS/bin/qiomkfile -e extend_amount filename
53Improving DB2 performance with Veritas Quick I/O
Monitoring tablespace free space with DB2 and extending tablespace containers