Work file database
Db2 work file databases are reserved as temporary space for certain SQL operations and cannot be recovered by using a recover utility.
When Db2 is started, situations might occur that prevent data sets in a work file database from being allocated. When this situation happens, you must allocate the database again. When the problem occurs on a volume in a user-defined work file database data set, you can use BMC AMI Recovery Manager to generate JCL to perform the required reallocation.
For more information about work file database problems, see the IBM Db2 Administration documentation..
Use the procedure described in Generating JCL to reallocate a work file database data set.
Generating JCL to reallocate a work file database
This procedure shows you how to generate JCL for allocating a temporary data set in a work file database.
Before you begin
To perform this procedure, you need these authorizations:
- EXECUTE authority for BMC AMI Recovery Manager
- Authority to use the Print Log Map utility
To generate JCL to reallocate a work file database data set
Start this procedure at the BMC AMI Recovery for Db2 Main Menu.
- Select System resources and press Enter to display the System Resource Recovery and Maintenance panel.
- Select Work File Database, enter the fields as required, and then press Enter.
- When the JCL Specification panel appears, enter a fully qualified output data set name. Be aware of the following information:
- The output data set is used for saving the JCL and must be cataloged. If not enclosed in quotes, the output data set will be prefixed by your TSO prefix.
- The job statement must contain a symbolic variable (&#) for the job number. For more information, see Output-data-sets-job-cards-and-symbolic-variables.
- Submit the JCL to reallocate the data set.