Siebel Database Upgrade Guide > Tuning the Siebel Upgrade Files >

Managing Parallel Threads Using Siebel Upgrade Tuner

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

Platforms: Windows and UNIX only.

Databases: Oracle only.

Upgrade Tuner allows you to create, edit, and delete parallel thread for table and index creation. This improves upgrade performance by reducing the amount of time required to complete table and index creation.

You create, edit, and delete threads in the Parallelize Table Creation page and the Parallelize Index Creation page. These two pages have the same layout.

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.
• Start Upgrade Tuner. See Starting and Stopping Siebel Upgrade Tuner.

Displaying Threads

You can view and sort the contents of threads or view items sorted across threads:

• Default sort. The default sort is all the items in the Serial Thread sorted from highest to lowest cost. The default sort displays when you start Upgrade Tuner, add a thread, or remove a thread. To reverse the sort order, click the Serial Thread column head.
• Contents of a thread. Click the column head for that thread. To reverse the sort-order, click the column head again.
• All items in all threads sorted by cost. Click the Cost per Table column head. To reverse the sort-order, click the column head again.

Creating Parallel Threads

Use this procedure to create a parallel thread for table creation or index creation. Upgrade Tuner automatically names threads Parallel Thread 1, Parallel Thread 2, and so on. You cannot edit thread names.

You start creating parallel threads by creating Parallel Thread 1 and Parallel Thread 2 together. You must assign at least one table or index to each of these threads.

All threads you create must contain at least one table or index.

Creating Parallel Thread 1 and Parallel Thread 2

Use the following procedure to create Parallel Thread 1 and Parallel Thread 2.

To create Parallel Thread 1 and Parallel Thread 2

1. In the Serial Thread, select a table or index, and move it to the right using the arrow key on the keyboard.

   Upgrade Tuner creates Parallel Thread 1 and Parallel Thread 2. It then assigns the table or index to Parallel Thread 1.

2. Move at least one table or index to Parallel Thread 2, to populate both threads.

Creating Additional Parallel Threads

Use the following procedure to create additional parallel threads.

To create additional parallel threads

• Select a table or index and move it to the right using the arrow key on the keyboard.

  When you move the table or index to the highest-numbered thread and click the arrow key again, Upgrade Tuner creates a new thread and places the table or index in the new thread.

TIP:   Another way to create a new thread is to right-click in a row. In the drop-down menu, select the last thread listed.

Moving Items Between Threads

Use the left and right arrow keys to move tables or indexes between threads, including the Serial Thread.

NOTE:  You cannot save and exit if any thread is empty.

Deleting a Thread

Use this procedure to delete an existing thread. You cannot delete the Serial Thread.

You must delete Parallel Thread 1 and Parallel Thread 2 together. You must delete all other threads before deleting Parallel Thread 1 and Parallel Thread 2.

Deleting a Thread Other Than Parallel Thread 1 or Parallel Thread 2

Use the following procedure to delete a thread other than Parallel Thread 1 or Parallel Thread 2.

To delete a thread other than Parallel Thread 1 or Parallel Thread 2

1. Click the column head for the desired thread.

   This action sorts the list so that all items in that thread appear at the top.

2. Right-click in the column head, and choose "Move all items to the serial thread" from the pop-up menu.
3. Right-click in the column head, and choose "Remove thread" from the pop-up menu.

   Upgrade Tuner deletes the thread and renames all higher-numbered threads.

Deleting Parallel Thread 1 and Parallel Thread 2

Use the following procedure to delete Parallel Thread 1 and Parallel Thread 2.

To delete Parallel Thread 1 and Parallel Thread 2

1. Right-click the column head for Parallel Thread 2, and choose "Move all items to the serial thread" from the pop-up menu.
2. Right-click the column head for Parallel Thread 1, and choose "Move all items to the serial thread" from the pop-up menu.
3. Right-click in the column head for Parallel Thread 2, and choose "Remove thread" from the pop-up menu.

   Upgrade Tuner deletes Parallel Thread 1 and Parallel Thread 2.

Evaluating Upgrade Performance Improvement

To evaluate production upgrep performance improvement, use the two fields at the top of the page:

• Total cost of sequential table (or index) creation. Displays the time to create tables or indexes when no parallel threads are used.
• Total cost of parallelized table (or index) creation. Displays the time to complete the upgrade using the parallel threads you have created. The time is computed by adding the Serial Thread time and the longest-running parallel thread time.

The difference between the sequential creation time and the parallelized creation time is an estimate of the reduction in upgrade time from using parallel threads.

You can reduce upgrade time further by performing the following actions:

• Move additional items from the Serial Thread to a parallel thread
• Move items from the longest-running parallel thread to other threads or a new thread

The goal is to reduce both the Serial Thread time and longest-running parallel thread time to a minimum. Because each new parallel thread requires additional memory and CPU cycles, you might need to experiment with the number of parallel threads to optimize upgrade performance.

Related Topics

About Tuning Siebel Production Upgrade Files