Db2 utilities

You can run Db2 utilities from Db2 Admin Tool by using the UTIL primary command or the UT, UTL, or UTIL line commands on a system catalog panel.

LISTDEF
You can use the Db2 LISTDEF utility to define reusable lists of objects for other utilities to process.
TEMPLATE
You can use the Db2 TEMPLATE utility to define templates for data sets that are allocated by other utilities and Db2 Admin Tool. Using templates eliminates the need for certain JCL DD statements during utility processing. Templates can also help standardize data set names.
Running Db2 utilities on table spaces
Many Db2 utilities run against table spaces. You can use Db2 Admin Tool to specify the utility options and generate the JCL to run these utilities.
Running Db2 utilities on tables
You can use Db2 Admin Tool to run the LOAD, UNLOAD, and REORG UNLOAD EXTERNAL utilities on tables. Based on the options that you choose, Db2 Admin Tool generates utility statements for you. You can choose to either save these utility statements in a work statement list (WSL) or generate a batch utility job stream.
Running Db2 utilities on indexes
Some Db2 utilities can be run against indexes. You can use Db2 Admin Tool to specify the utility options and generate the JCL to run these utilities.
Batch job parameters for utility jobs
When you run utilities, you can change some of the batch job parameters, such as the JOB card, the EXEC statement parameters, the ADBTEP2 parameters, and the space parameters.
Running utilities on LISTDEF lists
Instead of running utilities against explicitly specified table spaces or indexes, you can run utilities against a predefined list of objects. These lists are defined by the LISTDEF utility.
Utility options for XML and LOBs
Some Db2 utility options support XML and LOBs.
Running Db2 stand-alone utilities
You can run the following Db2 stand-alone utilities in Db2 Admin Tool: DSN1COMP, DSN1COPY, and DSN1PRNT. Db2 stand-alone utilities run independently of Db2; they work directly on the data sets. In Db2 Admin Tool, these utilities are also known as offline utilities.
Unloading objects by using Db2 High Performance Unload
You can use Db2 High Performance Unload with the MIG function to unload Db2 objects more efficiently.

Parent topic: Db2 management