Siebel Database Upgrade Guide for DB2 UDB for z/OS > Tuning the Siebel Production Upgrade Scripts >

About Tuning the Upgrade Scripts

Upgrades: All upgrades.

Environments: Production test environment only. Does not apply to production environment.

In Release 8.0, you can tune the SQL upgrade scripts in a production test environment to improve their performance and then re-use these tested scripts in the live production environment. For example, the scripts used to upgrade your Siebel database are generic. They update your Siebel database to support all Siebel applications' functionality. You can reduce downtime by tuning these scripts to optimize performance by eliminating unneeded SQL statements. You can then re-use these revised scripts in your production upgrade.

You can tune your production upgrade scripts at any time after upgrading the Siebel database schema in your production test environment.

Contacting Oracle's Application Expert Services

CAUTION:  You are required to contact your Oracle sales representative for Oracle Advanced Customer Services to request approval from Oracle's Application Expert Services for any upgrade script tuning that you perform. If you do not, you may invalidate your support agreement.

It is recommended (but not required) that you contact Oracle's Application Expert Services for help with the following tasks:

• Running load and unload jobs in parallel
• Changing the job submission order of load and unload jobs.

  If you want to change the submission order of jobs other than the load and unload jobs, you must first obtain approval from Oracle's Application Expert Services because many jobs have dependencies on other jobs and must be submitted in a specified sequence.