Resolving problems with Db2-managed work file data sets

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

Begin general-use programming interface information. To resolve problems with the work file database:

  1. Issue the following SQL statement to remove the problem volume from the Db2 storage group:
    ALTER STOGROUP stogroup-name
     REMOVE VOLUMES (xxxxxx);
  2. 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.
  3. Issue the following SQL statement to drop the table space that has the problem:
    DROP TABLESPACE DSNDB07.tsname:
  4. 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;
  5. Issue the following command to restart the database:
    -START DATABASE (DSNDB07)
    End general-use programming interface information.