Some of the data maintenance utilities available within DB2 are these:
REORGCHK
REORG
RUNSTATS
REBIND
FLUSH PACKAGE CACHE
ADMIN_CMD
Database maintenance utilities
The REORGCHK utility
This utility command can use be used to suggest tables and indexes that would benefit from reorganization. The basic command syntax for REORGCHK is this:
REORGCHK
<UPDATE STATISTICS | CURRENT STATISTICS>
<ON TABLE USER |
ON SCHEMA [SchemaName] |
ON TABLE [USER | SYSTEM | ALL | [TableName]>
Consider the following:
- SchemaName: Identifies the name to assign to a schema whose objects are to be analyzed to determine whether they must be re-organized
- TableName: Identifies the name to...