Siebel Database Upgrade Guide > Tuning the Siebel Upgrade Files >

Starting and Stopping Siebel Upgrade Tuner

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

Platforms: Windows and UNIX only.

Databases: All databases.

This topic describes how to start the Upgrade Tuner (upgtuner) from the Siebel Server installation directory on a Windows host. It also describe how to save or discard your changes when exiting Upgrade Tuner.

Use the Upgrade Tuner to improve the performance of table creation, index creation, and SQL execution during the production upgrep step in the production test environment.

Requirements

• In the production test environment, you must have completed the production upgrep step.
• You must have run the logparse utility on the production upgrep log files. See Summarizing Siebel Log Files Using the Logparse Utility.
• For UNIX platforms, you must have transferred files to a Windows host on which a Siebel Server is installed. See Transferring UNIX Files for Use by Siebel Upgrade Tuner.

Starting Upgrade Tuner

Use this procedure to start Upgrade Tuner.

To start Upgrade Tuner

• Enter the following command:

  SIEBEL_ROOT\bin\upgtuner /c LOGPARSE_SUMMARY_LOCATION

  where:

  LOGPARSE_SUMMARY_LOCATION is the location of the summary.xml file generated by the log parse utility for the production upgrep.

  For example:

  upgtuner /c SIEBEL_ROOT\log\upgrep_prod_77\summary.xml

  The Upgrade Tuner Process Information page appears.

  Alternative: Start Upgrade Tuner without the /c option. Click OK at the error pop-up. When Upgrade Tuner displays, click Browse and navigate to the summary.xml file.

Saving Your Changes and Exiting Upgrade Tuner

Use this procedure to save your changes and exit Upgrade Tuner.

To save your changes and exit Upgrade Tuner

1. Evaluate the changes you have made and revise them as needed.

   Upgrade Tuner does not revise the upgrade files until you exit.

2. Click Save and then Exit.
3. Click Yes in the pop-up window that asks you to confirm if you want to save and exit.

   Upgrade Tuner applies your changes to the upgrade files and exits.

Discarding Your Session Changes and Exiting Upgrade Tuner

Use this procedure to discard the changes you have made in the current session and exit Upgrade Tuner. No changes are made to upgrade files.

Parallelize Table or Index Creation Pages

Changes are discarded and do not display the next time you start Upgrade Tuner, if:

• You moved tables or indexes between threads, these changes are discarded.
• You created new threads, the threads are discarded.

Deactivate 0-Row SQLs

Changes are discarded and do not display the next time you start Upgrade Tuner, if:

• You deactivated a command, this change is discarded. The next time you start Upgrade Tuner, no check mark displays in the Inactive column. The command remains active in the SQL file.
• You activated a command, this change is discarded. The next time you start Upgrade Tuner, a check mark displays in the Inactive column, and the command remains inactive in the SQL file.

To discard your changes and exit Upgrade Tuner

1. Click Cancel.
2. Click Yes in the pop-up window that asks if you to confirm you want to discard your changes and exit.

Related Topics

About Tuning Siebel Production Upgrade Files