Recovery of the work file database

The work file database (called DSNDB07, except in a data sharing environment) is used for temporary space for certain SQL operations, such as join and ORDER BY.

If DSNDB01.DBD01 or DSNDB01.SYSDBDXA is stopped or otherwise inaccessible when Db2 is started, the descriptor for the work file database is not loaded into main storage. Thus, the work file database is not allocated. To recover from this condition after DSNDB01.DBD01 and DSNDB01.SYSDBDXA are available, stop and then start the work file database again.

You cannot use RECOVER with the work file database.