DB2 utilities

Use IBM® DB2® utilities to help maintain data in your DB2 for z/OS® databases.

Syntax diagrams for utilities

For information about the conventions for syntax diagrams in IBM documentation, see How to read syntax diagrams.

Types of DB2 utilities
IBM offers two types of DB2 utilities: online utilities and stand-alone utilities.
DB2 utilities packaging
Several utilities are included with DB2 at no extra charge. Other utilities are available as a separate product.
Privileges and authorization IDs for DB2 utilities
A utility job can be issued by an individual user, by a program that runs in batch mode, or by an IMS™ or CICS® transaction. The term process describes any of these initiators.
Utilities that can be run on declared temporary objects
The REPAIR utility with the DBD option and the STOSPACE utility can be run on declared temporary objects.
Effect of utilities on objects that have the DEFINE NO attribute
You can run certain online utilities on table spaces or index spaces that were defined with the DEFINE NO attribute. When you specify this attribute, the table space or index space is defined; however, DB2 does not allocate the associated data sets until a row is inserted or loaded into a table in that table space.
Effect of utilities on data that is encrypted through built-in functions
You can copy and recover encrypted data. You can also move encrypted data between systems. Data remains encrypted throughout these processes.
DB2 online utilities
DB2 online utilities run as standard batch jobs or stored procedures, and they require DB2 to be running. They do not run under control of the terminal monitor program (TMP); they have their own attachment mechanism and they invoke DB2 control facility services directly.
DB2 stand-alone utilities
The stand-alone utilities run as batch jobs that are independent of DB2. The only way to run these utilities is to use JCL.
Additional information for utilities
Additional information about the use of DB2 utilities can help you use the utilities effectively. For example, knowing about various advisory or restrictive states can be very helpful in working with DB2 utilities.

Related concepts:

DB2 utilities