Enlarging a fully extended data set for the work file database

If you have an out-of-disk-space or extent limit problem with the work file database (DSNDB07), you need to add space to the data set.

Procedure

To enlarge a fully extended data set for the work file database:

Add space to the Db2 storage group, choosing one of the following approaches:
  • Use SQL to create more table spaces in database DSNDB07.
  • Execute these steps:
    1. Use the command STOP DATABASE(DSNDB07) to ensure that no users are accessing the database.
    2. Use SQL to alter the storage group, adding volumes as necessary.
    3. Use the command START DATABASE(DSNDB07) to allow access to the database.