Use this utility frequently when the Host Encyclopedia is new or growing, once a week or at least once a month is recommended. When the encyclopedia reaches a size where the Runstat information does not change the path used by the optimizer, you do not have to use this utility. Do not run this utility on an empty table.
The job CEJOB06 (or the alternative job CAJOB06) runs the Runstats utility for Host Encyclopedia table spaces and indexes. For more information about running the Runstats utility, refer to DB2 documentation.
|
Copyright © 2013 CA.
All rights reserved.
|
|