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:
- Use the command STOP DATABASE(DSNDB07) to ensure that no users are accessing the database.
- Use SQL to alter the storage group, adding volumes as necessary.
- Use the command START DATABASE(DSNDB07) to allow access to the database.