Setting options for Db2® utilities

You can set Db2® utility options to:
  • Insert JCL DD statements for specified LISTDEF or TEMPLATE libraries
  • Modify the Db2® utility functions to include DD name clauses with specified template names
  • Insert LISTDEF, TEMPLATE, and OPTIONS Db2® utility statements

To change the option settings for Db2® utilities, first select 0 (Settings) from the Primary Option menu to display the Set Processing Options panel. The new settings apply for the current subsystem only. When you reconnect to the same subsystem, your option settings are retrieved.

To reset the option settings back to the installation defaults (for the current Db2® subsystem), use the RESET primary command or the Reset function key (F6).

The Set Processing Options panel shows menu items for:
Unload utility options
The FM/Db2 Unload Utility options apply when the UNLOAD utility is used to transfer data.
Options utility options
The FM/Db2 Options utility options assist in generating Db2® OPTIONS utility control statements.
Listdef utility options
The FM/Db2 Listdef utility options assist in generating Db2® LISTDEF utility control statements and in generating JCL for utility batch jobs to access a LISTDEF library.
Template utility options
The FM/Db2 Template utility options assist in generating Db2® TEMPLATE utility control statements and in generating JCL for utility batch jobs to access a template library. Also, options are provided that allow you to specify template names for DD names clauses of various Db2® utility control statements.

For a full description of Db2® utilities, see the Db2® Utility Guide and Reference.

Before you generate batch JCL to execute a Db2® Utility, check that these options are set to the values you want.

FM/Db2 uses the above options to generate JCL that refers to the appropriate LISTDEF and TEMPLATE libraries and also, where applicable, to generate an OPTIONS, LISTDEF, or TEMPLATE utility statement in the utility batch job. If specified, FM/Db2 places the OPTIONS, LISTDEF, and TEMPLATE statements in the SYSIN deck before the utility statement that corresponds to the utility selected from the Db2® Utilities panel.

To change the option settings for a Db2® utility:

  1. From either the Set Processing Options panel or the Options pull-down menu, select the menu item for the options you want to change:
    11
    Unload
    12
    Options
    13
    Listdef
    14
    Template

    FM/Db2 displays the selected options panel.

  2. Change the option settings as necessary

Related tasks

Related references