1. Database Upgrade Guide
  2. Upgrade Tuner Modes

Upgrade Tuner Modes

When you start Upgrade Tuner it displays four tabs:

  • Process Information

  • Parallelize Table Creation

  • Parallelize Index Creation

  • Deactivate 0-Row SQLs

Process Information Tab

This page displays the information sources that Upgrade Tuner is using. These sources include the Logparse summary.xml file, the primary .ucf file, and the driver .ucf file.

You cannot edit the information on this page. Upgrade Tuner obtains the information by reading the summary.xml file.

Parallelize Table Creation and Parallelize Index Creation Tabs

The Parallelize Table Creation page and the Parallelize Index Creation page both have the same layout. These pages allow you to do the following:

  • Parallelize Table Creation tab. This page displays the time required to create tables and allows you to assign table creation to parallel threads. Adding a table to a parallel thread does not add index creation for that table to the thread. Table and index creation are handled as separate steps during the upgrade.

  • Parallelize Index Creation tab. This page displays the time required to create table indexes and allows you to assign index creation to parallel threads.

Creating parallel threads improves upgrade performance by reducing the total time to create tables and indexes. You can create up to nine parallel threads. Tables or indexes not assigned to a parallel thread remain in the serial thread.

When you run the Upgrade Tuner, the Number of Threads parameter is automatically set, based on a log analysis, to the value effectively required to run the upgrade. In most cases this value is set at 4. This value, which can be changed in the master_upgrep* file, drives the maximum number of threads for each single Siebel upgrep task, such as ddlimp executions concurrently running for this process. When setting this value you must consider the system resources of the computer from which the upgrep phase was initiated. These changes must be tested on a copy of the Siebel production database environment, prior to rolling these out for the actual Siebel production upgrade downtime window.

Deactivate 0-Row SQLs

This page allows you to activate or deactivate the SQL statements that do not affect any table rows and therefore any data. This capability improves the upgrade performance by eliminating SQL statements that might not apply to your data. This page lists only the SQL files that are executed natively by the RDBMS. It does not list SQL files that are executed using odbcsql.