Saturday, 17 August 2013

DB2 Utilities

CHECK - The CHECK INDEX utility tests whether indexes are consistent with the data they index, and issues warning messages when an inconsistency is found.
The CHECK DATA utility checks table spaces for violations of referential constraints, and reports information about each violation it detects.
COPY - Creates up to four image copies of a table space or a data set within a table space.
There are two types of image copies. A full image copy is a copy of all pages in a table space or data set an incremental image copy is a copy only of pages that have been modified since the last use of the COPY utility.
DIAGNOSE - Generates information useful in diagnosing problems. DIAGNOSE is indented for use under the direction of your IBM support center.
LOAD - The LOAD utility loads data into one or more tables in a table space, replaces the contents of a single partition, or replaces the contents of an entire table space. The LOAD DATA statement describes the data to be loaded and provides information needed for allocating resources. The loaded data is processed by any edit or validation routine associated with the table, and any field procedure associated with any column of the table.
MERGECOPY - Merges image copies produced by the COPY utility. The utility can merge several incremental copies of a table space to make one incremental copy, or it can merge incremental copies with a full image copy to make a new full image copy.
MODIFY - The MODIFY RECOVERY utility deletes records of unwanted copies from the SYSIBM.SYSCOPY catalog table and related records from the SYSIBM.SYSLGRNG directory table. You can remove 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 or data set.
The MODIFY STATISTICS utility removes non-uniform distribution statistics from the SYSIBM.SYSFIELDS catalog table.
QUIESCE - Establishes a quiesce point (the current log RBA) for a table space, or list of table space, and records in the SYSIBM.SYSCOPY catalog table.
RECOVER - Recovers data to the current state. You can also RECOVER to a prior copy or a specified log RBA. The largest unit of data recovery is the table space ; the smallest is the page. You can recover one table space, a list of table spaces, a data set, pages within an error range, or a single page. Data is recovered from image copies of a table space and database log change records.
If the most recent full image copy data set is unusable, and there are previous image copy data set existing in the system, RECOVER uses the previous image copy data sets.
If the RECOVER utility cannot use the latest primary copied data set as a starting point for recovery, it attempts to use the backup copied data set, if one is available. If neither image copy is usable, it attempts to fall back to a previous recoverable point. RECOVER also recovers multiple indexes over tables that reside in a common table space.
Indexes are recovered in their entirety with a single invocation of RECOVER. Indexes can be recovered concurrently on the same table space.
REORG - Reorganized a table space to improve access performance and reclaim fragmented space. In addition, the utility can reorganize a single partition of either a partitioned index or a partitioned table space. If you specify REORG UNLOAD ONLY or REORG UNLOAD PAUSE, the REORG utility unloads data in a format acceptable to the LOAD utility of the same DB2 table space.
REPAIR - Repairs data. The data can be your own data, or data you should not normally access, such as space map pages and index entries. Be extremely careful in using REPAIR. Improper use can damage the data even further.
REPORT - Reports the following information necessary for recovering a table space.
Recovery history from the SYSIBM.SYSCOPY catalog table Log ranges from SYSIBM.
SYSLGRNG - Volume serial numbers where archive log data sets from the BSDS reside Volume serial numbers where the image copy data sets from SYSCOPY reside Names of all table space and tables in a table space set.
RUNSTATS - Gathers summary information about the characteristics of the data in table spaces and indexes. This information is recorded in the DB2 catalog, and is used by DB2 to select access paths to data during the bind process. It is available to the database administrator for evaluating database design, and determining when table spaces or indexes should be reorganized.
STOSPACE - Updates DB2 catalog columns that indicate how much space is allocated for storage groups and related table spaces and indexes.

Created with Artisteer

No comments:

Post a Comment