Upgrade Guide for DB2 UDB for z/OS > Upgrading a Development Environment Database from the Midtier >

Resuming the Siebel Upgrade Wizard After the Second Pause

Upgrades: All upgrades.

Environments: Development (midtier-centric) environment.

This topic is part of an upgrade process. See How to Perform the Upgrade.

After you perform the task, Executing SQL Output Files After the Second Pause - Stage 2 of 2, continue the upgrade from the point at which it paused.

To continue the upgrade of the Siebel Database schema

1. Resume the development environment upgrade using the appropriate method for your operating system.

   Windows:

   • If the dialog box is still open from Step 2, click Yes in the dialog box for pause #2.
   • If you closed the Siebel Upgrade Wizard screen or it is no longer open, restart the upgrade by typing the following command at the Windows DOS command prompt from the SIEBEL_ROOT\BIN directory:

   siebupg.exe /m master_UPGRADEOPTION_ENVIRONMENT_VERSION_mf.ucf

   To restart a development upgrade from Release 7.0.4, type the following command:

   siebupg.exe /m master_upgrep_dev_704_mf.ucf

   UNIX:

   • Navigate to $SIEBEL_ROOT/bin and type the following command:

   srvrupgwiz /m master_UPGRADEOPTION_ENVIRONMENT_VERSION_mf.ucf

   To restart a development environment upgrade from Release 7.0.4, type the following command:

   srvrupgwiz /m master_upgrep_dev_704_mf.ucf

2. In the Siebel Upgrade Wizard screen, click OK to resume the upgrade.

   A check mark appears beside each item as it is completed.

   CAUTION:  The upgrade process executes in a DOS command window. Do not click inside this window while the upgrade is running. If you accidentally click inside the DOS command window, the process pauses and the word Select precedes the title of the command window. To continue, press the space bar or escape.

   The Siebel Upgrade Wizard stops again and the following message appears:

   Pause #3.

   Your database administrator must create Siebel Indexes using scindx.sql located in the Upgrade Output Directory. Once the Siebel Indexes are created, please continue by selecting Yes. To stop now and resubmit the Upgrade Wizard later, please select No. (To resume, please start the Upgrade Wizard from the command line using option /m master_upgrep_dev_<path>_mf.ucf.)

3. Do not click either Yes or No when the third pause message appears. Leave this dialog box open until after your DBA has executed the following SQL files on the z/OS host:
   • indexes.sql
   • gen_primary1.sql
   • gen_primary2.sql
   • gen_primary3.sql
   • gen_primary4.sql