extend a DB2 tablespace by a fixed amount

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

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