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.

Invoking DB2 online utilities
You can invoke DB2 online utilities by using any of a variety of methods.
Monitoring and controlling online utilities
You can monitor utilities, run utilities concurrently, terminate utilities, and restart utilities.
BACKUP SYSTEM
The online BACKUP SYSTEM utility invokes z/OS DFSMShsm (Version 1 Release 7 or above) to copy the volumes on which the DB2 data and log information resides. These system-level backups can be taken for either a DB2 subsystem or data sharing group. You can later run the RESTORE SYSTEM utility to recover the subsystem or data sharing group.
CATENFM
The CATENFM online utility enables a DB2 subsystem to enter DB2 DB2 10 enabling-new-function mode and DB2 10 new-function mode. It also enables a DB2 subsystem to return to enabling-new-function mode from new-function mode.
CATMAINT
The CATMAINT online utility updates the catalog; run this utility during migration to a new release of DB2 or when IBM Software Support instructs you to do so.
CHECK DATA
The CHECK DATA online utility checks table spaces for violations of referential and table check constraints, and it reports information about violations that it detects. CHECK DATA checks for consistency between a base table space and the corresponding LOB or XML table spaces.
CHECK INDEX
The CHECK INDEX online utility tests whether indexes are consistent with the data that they index, and it issues warning messages when it finds an inconsistency.
CHECK LOB
You can run the CHECK LOB online utility on a LOB table space to identify any structural defects in the LOB table space and any invalid LOB values.
COPY
The COPY online utility creates copies of certain objects.
COPYTOCOPY
The COPYTOCOPY online utility makes image copies from an image copy that was taken by the COPY utility. The COPYTOCOPY utility can also make image copies from inline copies that the REORG or LOAD utilities make.
DIAGNOSE
The DIAGNOSE online utility generates information that is useful in diagnosing problems. Use this utility only under the direction of IBM Software Support.
EXEC SQL
The EXEC SQL online utility control statement declares cursors or executes dynamic SQL statements. You can use this utility as part of the DB2 cross-loader function of the LOAD utility.
LISTDEF
The LISTDEF utility enables you to group database objects into reusable lists. You can then specify these lists in other utility control statements to indicate that the utility is to process all of the items in the list.
LOAD
Use the LOAD online utility to load one or more tables of a table space. The LOAD utility loads records into the tables and builds or extends any indexes that are defined on them.
MERGECOPY
The MERGECOPY online utility merges copies or inline copies that other utilities produce. The COPY and COPYTOCOPY utilities produce image copies, and the LOAD and REORG utilities produce inline copies.
MODIFY RECOVERY
The MODIFY online utility with the RECOVERY option deletes certain records from the DB2 catalog, directory, and DBD. This utility also recycles DB2 version numbers for reuse.
MODIFY STATISTICS
The MODIFY STATISTICS online utility deletes unwanted statistics history records from the corresponding catalog tables. You can remove statistics history records that were written before a specific date, or you can remove records of a specific age. You can delete records for an entire table space, index space, or index.
OPTIONS
The OPTIONS online utility control statement specifies processing options that are applicable across many utility executions in a job step.
QUIESCE
The QUIESCE utility establishes a quiesce point for a table space, partition, table space set, or list of table spaces and table space sets. A quiesce point is a point at which data is consistent across these objects. You can later recover a table space to its quiesce point by using the RECOVER utility.
REBUILD INDEX
The REBUILD INDEX online utility reconstructs indexes or index partitions from the table that they reference.
RECOVER
The RECOVER utility recovers data to the current state or to a previous point in time by restoring a copy and then applying log records. The RECOVER utility can also recover data to a previous point in time by backing out committed work.
REORG INDEX
The REORG INDEX online utility reorganizes an index space to improve access performance and reclaim fragmented space. You can specify the degree of access to your data during reorganization, and you can collect inline statistics by using the STATISTICS keyword.
REORG TABLESPACE
The REORG TABLESPACE online utility reorganizes a table space to improve access performance and to reclaim fragmented space. In addition, the utility can reorganize a single partition or range of partitions of a partitioned table space.
REPAIR
The REPAIR online utility repairs data. The data can be your own data or data that you would not normally access, such as space map pages and index entries.
REPORT
The REPORT utility provides information about table spaces, tables, and indexes. You can use REPORT to find the names of related table spaces, such as referentially related table spaces and LOB table spaces. You can also use REPORT to find information that is necessary for recovery.
RESTORE SYSTEM
The RESTORE SYSTEM online utility invokes z/OS DFSMShsm to recover a DB2 subsystem or a data sharing group to a previous point in time. To perform the recovery, the utility uses data that is copied by the BACKUP SYSTEM utility.
RUNSTATS
The RUNSTATS online utility gathers summary information about the characteristics of data in table spaces, indexes, and partitions. DB2 records these statistics in the DB2 catalog and uses them to select access paths to data during the bind process.
STOSPACE
The STOSPACE online utility updates DB2 catalog columns that indicate how much space is allocated for storage groups and related table spaces and indexes.
TEMPLATE
The TEMPLATE online utility control statement lets you allocate data sets, without using JCL DD statements, during the processing of a LISTDEF list. The TEMPLATE control statement defines the data set naming convention. TEMPLATE control statements can also be written to contain allocation parameters that define data set size, location, and attributes.
UNLOAD
The UNLOAD online utility copies data from one or more source objects to one or more BSAM sequential data sets in external formats. The output records that the UNLOAD utility writes are compatible as input to the LOAD utility. Therefore, you can use this output to reload the original table or different tables.

Parent topic: DB2 utilities