Database maintenance utilities

Some of the data maintenance utilities available within DB2 are these:

    REORGCHK
    REORG
    RUNSTATS
    REBIND
    FLUSH PACKAGE CACHE
    ADMIN_CMD

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...