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

Resuming the Siebel Upgrade Wizard After the Third Pause

Upgrades: All upgrades.

Environments: Development (midtier-centric) environment.

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

After your DBA has performed the task, Executing SQL Output Files After the Third Pause and updated statistics, you may 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 #3.
   • 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. It automatically performs the following tasks:
   1. Deletes old license keys
   2. Imports seed data
   3. Imports the repositories needed to run the repository merge (one of the current schema, two of the new schema)
   4. Upgrades the application version data to the new Siebel version
   5. Updates the repository tables in preparation for the repository merge.

      A check mark appears beside each item on the Upgrade Wizard screen as it is completed.

      NOTE:  When you are performing a development environment upgrade, the Siebel Upgrade Wizard may stop responding during the Repository Data Upgrade step. If this happens, cancel the Siebel Upgrade Wizard and from the command prompt, navigate to $Siebsrvr\Bin and execute the RUNSTATS commands on tables S_COLUMN and S_UK_ATTJOIN using the following syntax:
      
      RSTAT390 /u <database_username> /p <database_password> /c <ODBC datasource> /d <Tableowner> /a Y /l <logfile> /T S_COLUMN

RSTAT390 /u <database_username> /p <database_password> /c <ODBC datasource> /d <Tableowner> /a Y /l <logfile> /T S_UK_ATTJOIN

      After executing the these commands, restart the Siebel Upgrade Wizard from the command prompt by entering siebupg.exe /m master_upgrep_dev_<version>_mf.ucf.

3. Select Ok. You have now finished the upgrep step in the development environment upgrade.