Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide for DB2 for z/OS > Tuning the Siebel Production Upgrade Scripts > Adding the Statistics Clause to Load CardsEnvironments: 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) NOTE: If LOAD RESUME is specified on a load card, you cannot collect statistics while running the load job. |
Siebel Database Upgrade Guide for DB2 for z/OS | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |