Resolving problems with a user-defined work file data set

You can resolve problems on a volume of a user-defined data set for the work file database.

Procedure

To resolve problems:

  1. Issue the following Db2 command: 
    -STOP DATABASE (DSNDB07)
    Note: If you are adding or deleting work files, you do not need to stop database DSNDB07.
  2. Use the DELETE and DEFINE functions of access method services to redefine a user work file on a different volume, and reconnect it to Db2.
  3. Issue the following Db2 command: 
    -START DATABASE (DSNDB07)