One way to invoke Db2 online
utilities is to use the DB2 Utilities
panel. Consider using this method if you do not have much JCL knowledge.
To use this method, you must have TSO and access to the Db2 Utilities Panel in Db2 Interactive (DB2I).
Restriction: You cannot use the
DB2 Utilities panel in
DB2I to submit jobs for the following utilities:
- BACKUP SYSTEM
- COPYTOCOPY
- RESTORE SYSTEM
- COPY for a list of objects if templates are not used for the output data sets
Procedure
To invoke an online utility by using the DB2 Utilities panel in DB2I:
-
Create the utility control statement for the online utility that you want to invoke, and save
it in a sequential or partitioned data set.
-
From the ISPF Primary Option Menu, select DB2 until
the DB2I Primary Option Menu is displayed. (Depending
on how your menus are set up, you might need to select DB2 from several menus
until the DB2I Primary Option Menu is
displayed.)
-
On the DB2I Primary Option Menu, select the
UTILITIES option.
-
On the DB2 Utilities panel,
complete the following fields and press Enter::
- 1 FUNCTION
- EDITJCL
- 3 UTILITY
- The name of the utility that you want to run
- 4 STATEMENT DATA SET
- The name of the data set that contains the utility control statement.
-
If the Data Set Names panel is displayed, complete the relevant fields
with the data set names and press Enter. This panel is displayed if you
specified COPY, LOAD, MERGECOPY, REORG TABLESPACE, or UNLOAD.
-
If the Control Statement Data Set Names panel is displayed, complete the
fields on that panel and press Enter.
This panel is displayed if you specified that you want to use templates or lists on the
DB2 Utilities panel. For more
information about the fields on this panel, see
Control Statement Data Set Names panel
-
Edit the generated JCL as needed and type SUBMIT or
SUB on the editor command line.
Results
You can view the output of the job as you normally view the output of any batch job on your
system. One common way is by using System Display and Search Facility (SDSF).