You can resolve problems on a volume in a Db2 storage
group for the work file database, such as a system I/O problem.
Procedure
To
resolve problems with the work file database:
- Issue the following SQL statement to remove the problem
volume from the Db2 storage
group:
ALTER STOGROUP stogroup-name
REMOVE VOLUMES (xxxxxx);
- Issue the following Db2 command
to stop the database:
-STOP DATABASE (DSNDB07)
Note: If you are adding or deleting
work files, you do not need to stop database DSNDB07.
- Issue the following SQL statement to drop the table space
that has the problem:
DROP TABLESPACE DSNDB07.tsname:
- Re-create the table space. You can use the same storage
group, because the problem volume has been removed, or you can use
an alternate volume.
CREATE TABLESPACE tsname
IN DSNDB07
USING STOGROUP stogroup-name;
- Issue the following command to restart the database:
-START DATABASE (DSNDB07)
