Siebel Database Upgrade Guide for DB2 UDB for z/OS > Tuning the Siebel 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.