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:
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.