Upgrade Guide for DB2 UDB for z/OS and OS/390 > Upgrading a Database from the Mainframe >

Resuming the Siebel Upgrade Wizard on the Midtier After the Second Pause


Upgrades: All upgrades.

Environments: Development (mainframe-centric) environment and Production environment.

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

Once you have completed the task, Executing the Upgrade on the zSeries Host (Phase 1 of 2), continue the upgrade from the point at which it paused.

CAUTION:  Do not proceed unless you installed stored procedures and user defined functions as described in Installing Stored Procedures on the zSeries Host.

To resume the Siebel Upgrade Wizard on the midtier after the second pause

  1. Resume the 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\siebsrvr_root\BIN directory:

    siebupg.exe /m master_UPGRADEOPTION_ENVIRONMENT_VERSION_mf.ucf

    For example, to restart a development environment upgrade from Release 7.0.4, enter the following command:

    siebupg.exe /m master_upgrep_dev_704_mf.ucf

    To restart a production environment upgrade from Release 7.0.4, enter the following command:

    siebupg.exe /m master_upgrep_prod_704_mf.ucf

    UNIX:

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

    srvrupgwiz /m master_UPGRADEOPTION_ENVIRONMENT_VERSION_mf.ucf

    For example, to restart a development environment upgrade from Release 7.0.4, enter the following command:

    srvrupgwiz /m master_upgrep_dev_704_mf.ucf

    To restart a production environment upgrade from Release 7.0.4, enter the following command:

    srvrupgwiz /m master_upgrep_prod_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

    Please create Siebel Indexes using scindx.sql located in the DDL Output Directory. Once the Siebel Indexes are created, please select Yes. To stop now and continue upgrade later, please select No. (To resume, please start the Upgrade Wizard from the command line using option /m master_upgrep_<env>_<path>_mf.ucf.)

  3. Do not click either Yes or No when the third pause message appears. Leave this dialog box open until after you have performed the following tasks on the zSeries host.

    Once you complete the tasks on the zSeries host, continue with the upgrade.

NOTE:  When you are performing a Mainframe-centric 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.

Upgrade Guide for DB2 UDB for z/OS and OS/390