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

To extend a DB2 tablespace by a fixed amount

◆

Use the following DB2 commands:

$ db2 connect to database

$ db2 alter tablespace tablespace-name extend (ALL amount)

$ db2 terminate

This example shows how to monitor the free space on the tablespaces in

database PROD:

$ db2 connect to PROD

$ db2 list tablespaces show detail

$ db2 terminate

This example shows how to extend the three DB2 containers owned by

tablespace EMP by 500MB using the qiomkfile command:

$ /opt/VRTS/bin/qiomkfile -e 500M tbsEMP_cont001

$ /opt/VRTS/bin/qiomkfile -e 500M tbsEMP_cont002

$ /opt/VRTS/bin/qiomkfile -e 500M tbsEMP_cont003

This example shows how to notify DB2 that all containers in tablespace EMP

have grown by 500MB:

$ db2 connect to PROD

$ db2 alter tablespace EMP extend (ALL 500M)

$ db2 terminate

This example shows how to verify the newly allocated space on the tablespace

EMP in database PROD:

$ db2 connect to PROD

$ db2 list tablespaces show detail

$ db2 terminate

Improving DB2 performance with Veritas Quick I/O

Monitoring tablespace free space with DB2 and extending tablespace containers