DB2 Utilities panel

Use the DB2 Utilities panel to invoke utilities without writing JCL.

Fields that you must specify on this panel are highlighted in the following figure:

Figure 1. Db2 Utilities panel
DSNEUP01                         DB2 UTILITIES
 ===>
 
 Select from the following:
 
  1 FUNCTION ===> EDITJCL   (SUBMIT job, EDITJCL, DISPLAY, TERMINATE)
  2 JOB ID   ===> TEMP      (A unique job identifier string)
  3 UTILITY  ===> COPY      (CHECK DATA, CHECK INDEX, CHECK LOB,

                             COPY, DIAGNOSE, LOAD, MERGE, MODIFY,
                             QUIESCE, REBUILD, RECOVER, REORG INDEX,
                             REORG LOB, REORG TABLESPACE, REPORT,
                             REPAIR, RUNSTATS, STOSPACE, UNLOAD.)
 
  4 STATEMENT DATA SET  ===>   UTIL
 
 Specify restart or preview option, otherwise specify NO.
 
  5 RESTART  ===> NO         (NO, CURRENT, PHASE or PREVIEW)
 
  6 LISTDEF? (YES|NO) ===> NO       TEMPLATE? (YES|NO) ===> NO
 
  7 LIB ==>                  (BLANK or DB2 LIB NAME) 

*  The data set names panel will be displayed when required by a utility.
 
 
 PRESS:  ENTER to process     END to exit    HELP for more information
 
1 FUNCTION
Specify one of the following options:
SUBMIT
The generated JCL is submitted for processing after you complete this panel and any subsequent panels. You cannot edit the JCL.
EDITJCL
You can edit the generated JCL before you submit the utility job. For example, you might want to add or edit parameters on the JOB statement or add a ROUTE statement.

The other two options for this field, DISPLAY and TERMINATE, are not part of invoking a utility. DISPLAY performs the same function as the DISPLAY UTILITY command; it shows the status of a utility job. TERMINATE performs the same function as the TERM UTILITY command; it terminates a utility.

2 JOB ID
Specify a unique identifier for your utility job. The default value is TEMP.
3 UTILITY
Specify the utility that you want to run.
4 STATEMENT DATA SET
Specify the data set that contains the utility control statement. TSO adds your user ID as a prefix unless you enclose the data set name between apostrophes. The default data set is UTIL.
5 RESTART
If you want to restart a stopped utility, specify CURRENT or PHASE. If you want to run a utility in PREVIEW mode, specify PREVIEW. Otherwise, leave the default value of NO.
6 LISTDEF? TEMPLATE?
Specify whether you are using LISTDEF statements or TEMPLATE statements for this utility job.
7 LIB
If you want the generated JCL to use a Db2 subsystem library other than the default, specify the data set name of the Db2 subsystem library.