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.

Related topics

Managing-DB2-Subsystem-Toolbox

Db2-system-resource-maintenance-and-recovery


Important

If Db2 is not available, BMC AMI Recovery Manager redefines the work file with a CISIZE of 4K.

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.

Warning

The generated job does not perform alter operations for STOGROUP-managed spaces.

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.

  1. In the BMC AMI Recovery for Db2 Main Menu, select 3. DB2 Subsystem Toolbox.
  2. In the Db2 Subsystem Toolbox panel, select 5. Work File Database, enter the fields as required, and then press Enter.
  3. 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.
  4. Submit the JCL to reallocate the data set.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*