Invoking an online utility by using the DB2® Utilities panel in DB2I

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:

  1. Create the utility control statement for the online utility that you want to invoke, and save it in a sequential or partitioned data set.
  2. 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.)
  3. On the DB2I Primary Option Menu, select the UTILITIES option.
  4. 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.
    For more information about the fields on this panel, see DB2 Utilities panel
  5. 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.
    For more information about the fields on this panel, see Data Set Names panel
  6. 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
  7. 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).