The RUNSTATS utility scans a table space or index to gather information about utilization of space and efficiency of indexes.
The information is recorded in the DB2 system catalog. It is used by the Installation function during the bind process to select access paths to data. The database administrator can use catalog queries to review the RUNSTATS information. The information is used to evaluate database design and determine when table spaces or indexes are reorganized.
To select the table spaces and indexes for which to gather RUNSTATS information, use the DB2 RUNSTATS Utility. CA Gen generates the RUNSTATS JCL based on selections that are made with the RUNSTATS Utility.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|