IBM Db2 11.1 Certification Guide

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 assign to a specific table to analyze, to determine whether it must be re-organized

You can invoke the REORGCHK command to verify the level of data fragmentation and to decide whether reorganization is necessary, as shown here:

   REORGCHK CURRENT ...