Db2® Utilities panel

You use the Db2® Utilities panel to generate Db2® utility jobs to copy, load, rebuild, reorganize and collect statistics on Db2® objects.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                   Db2 Utilities

 Processing Options:
    Db2 Utility:   (valid obj)   Object Type:          Specification:
    1  1. COPY        (2,3)      2  1. Tables          1  1. Object name
       2. LOAD        (1)           2. Table spaces       2. LISTDEF
       3. REBUILD     (4,5)         3. Index spaces
       4. RECOVER     (2,3)         4. Indexes
       5. REORG       (2,4)         5. Indexes for table spaces
       6. RUNSTATS    (2,4)
       7. UNLOAD      (1,2)

 Db2 Object Details:             (* for list in any field)
    Database  . . . . .         
    Table/Index space .         

    Table or Index:
    Owner . . . . . . .                   +
    Name  . . . . . . .                                                     +

 LISTDEF Details:                (* unavailable)
    LISTDEF name  . . .                   
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

The Db2® Utilities panel shows a list of the available utilities on the left side of the Processing Options section, and a list of Db2® object types on the right. Each Db2® utility applies to only certain object types. For example, the LOAD utility only applies to Db2® tables. The valid object types for each utility are shown under the heading Valid Db2® Obj.

The panel shows a Specification section and a LISTDEF name field. A selection of LISTDEF means that a LISTDEF name is to be specified as the object of the utility; otherwise, the object name of the type specified in object type is to be specified.

In the Specification section, you can select:
1. Object name
The object specified in Db2® Object Details is used as the object of the utility. The default is 2 (Table spaces).
2. LISTDEF
The name specified in LISTDEF name is used as the object of the utility. The default is 1 (Object name).
Db2® Utility
Specifies the Db2® utility to be executed. The default is 1 (Copy).
Note: The LOAD syntax does not have a LISTDEF clause. If you select LOAD in the Db2® Utility section and LISTDEF in the Specification section, FM/Db2 issues a warning message.

In the LISTDEF name section, if you have specified 2 (LISTDEF) in the Specification section, specify the name of the LISTDEF you want to use.

You specify the objects to be processed by the Db2® utility at the bottom of the panel.

Database
The name of the database for the object.
Table/Index space
The name of the table space or index space for the object.
Owner
The name of the owner of the table or index for the object.
Name
The name of the table or index for the object.

Parent panels

Child panels

To display this panel… Use/do this
COPY Utility (Table Spaces) panel Db2® utility: COPY; object type: Table space; specification: Object name
COPY Utility (Table Spaces) with LISTDEF panel Db2® utility: COPY; object type: Table space; specification: LISTDEF
COPY Utility (Index Spaces) panel Db2® utility: COPY; object type: Index space; specification: Object name
COPY Utility (Index Spaces) with LISTDEF panel Db2® utility: COPY; object type: Index space; specification: LISTDEF
LOAD Utility panel Db2® utility: LOAD; object type: Tables; specification: Object name
LOAD Utility panel using Db2 templates Db2® utility: LOAD; object type: Tables; specification: LISTDEF
REBUILD Utility (Indexes) panel Db2® utility: REBUILD; object type: Indexes; specification: Object name
REBUILD (Indexes) with LISTDEF panel Db2® utility: REBUILD; object type: Indexes; specification: LISTDEF
REBUILD (Indexes for Table Spaces) panel Db2® utility: REBUILD; object type: Indexes for Table space; specification: Object name
RECOVER Utility (Table Spaces) panel Db2® utility: RECOVER; object type: Table space; specification: Object name
RECOVER Utility (Table Spaces) with LISTDEF panel Db2® utility: RECOVER; object type: Table space; specification: LISTDEF
RECOVER Utility (Index Spaces) panel Db2® utility: RECOVER: object type: Index spaces; specification: Object name
REORG Utility (Table Spaces) panel Db2® utility: REORG; object type: Table space; specification: Object name
REORG Utility (Indexes) panel Db2® utility: REORG; object type: Indexes; specification: Object name
REORG Utility (Indexes) with LISTDEF panel Db2® utility: REORG; object type: Indexes; specification: LISTDEF
RUNSTATS Utility (Table Spaces) panel Db2® utility: RUNSTATS; object type: Table space; specification: Object name
RUNSTATS Utility (Table Spaces) with LISTDEF panel Db2® utility: RUNSTATS; object type: Table space; specification: LISTDEF
RUNSTATS Utility (Indexes) panel Db2® utility: RUNSTATS; object type: Indexes; specification: Object name
RUNSTATS Utility (Indexes) with LISTDEF panel Db2® utility: RUNSTATS; object type: Indexes; specification: LISTDEF
UNLOAD Utility (Tables) "From" panel Db2® utility: UNLOAD; object type: Tables; specification: Object name
UNLOAD Utility (Table Spaces) panel Db2® utility: UNLOAD; object type: Table spaces; specification: Object name
UNLOAD Utility (Table Spaces) with LISTDEF panel Db2® utility: UNLOAD; object type: Table spaces; specification: LISTDEF

Related tasks