Upgrade Guide for DB2 UDB for z/OS > Tuning the Production Upgrade Scripts >
Adding the Statistics Clause to Load Cards
Upgrades: All upgrades. Environments: Production test environment only. Does not apply to production environment. If your database schema structure follows the 1:1:1 model, and if LOAD REPLACE is specified on a load card (so tables are loaded from scratch), you can improve upgrade performance by collecting statistics while running the load job rather than having to run a separate RUNSTATS job. You can do this by adding the STATISTICS clause to the load cards, for example: STATISTICS TABLE(ALL) INDEX(ALL)
UPDATE ACCESSPATH
NOTE: If LOAD RESUME is specified on a load card, you cannot collect statistics while running the load job.
|