Siebel Database Upgrade Guide for DB2 for z/OS > How the Siebel Database Upgrade Works >

About the Siebel Upgrade Wizard and Driver Files

Upgrades: All upgrades.

Environments: All environments.

The Upgrade Wizard generates the files required to perform the upgrade of the Siebel database on the z/OS host and also makes changes to the Siebel database directly. After the Siebel Upgrade Wizard starts, it executes this process:

• Reads the upgrade configuration file (UCF) generated by the Database Configuration Wizard
• Calls a driver
• Passes the information in the UCF to the driver, which then passes UCF file information to, for instance:
  • the ddlimp utility, which executes ddl-type SQL commands
  • the dataimp utility, which executes data-related SQL commands

If ddlimp or dataimp (or any of the database utilities) encounter errors, they stop. When the errors have been corrected, you can launch the Siebel Upgrade Wizard, and the upgrade resumes from where it stopped.

The Siebel Upgrade Wizard pauses on four occasions during the upgrade file generation process. At each pause, you must transfer the files that the Upgrade Wizard has generated to the z/OS host and execute them before you resume the upgrade. Message text at each pause informs you of the tasks you must perform.

The files generated by the Upgrade Wizard are output by default to the DBSRVR_ROOT\DB2390\dboutput\upgrade directory (Windows) or DBSRVR_ROOT/DB2390/dboutput/upgrade directory (UNIX) or to the DDL Output Directory you specified when you ran the Database Configuration Wizard.

Driver Files

The Siebel Upgrade Wizard performs the upgrade by executing the commands and SQL scripts contained in driver files. Driver files are in ASCII text format and are organized into steps. The Upgrade Wizard reads the steps in the driver files and performs the commands contained in each step.

In a driver file, steps are separated by a blank line, and each step begins with a File Execute Entry number. The key part of each step is the command or script to be executed. When an SQL script is specified, you can review the script and see what changes it will make to the Siebel database before running the Siebel Upgrade Wizard.

Driver files are provided for each of the major upgrade operations. Examples of development environment upgrade driver files are as follows:

• driver_upgrep_dev_753_mf_m.ucf
• driver_upgrep_dev_753_mf.ucf
• driver_upgphys_dev_753_mf.ucf

Here is an excerpt from a driver file that controls a development environment upgrep from Siebel CRM version 7.5.3 to version 8.1 (driver_upgrep_dev_753_mf.ucf). The excerpt contains two steps:

[File Execute Entry 9]
Type = FileExecute
File Name = $SiebelRoot\bin\odbcsql
Check Return Code = 1
Return Code Compliance = 0
16 Bit App = 0
Command Line = /s "$ODBCDataSource" /u $UserName /p $Password /separator / /a /c rem /q $DatabaseOwner /l $SiebelLogDir/upd_upgcomp.log $DbsrvrRoot/$DatabasePlatform/upd_upgcomp.sql /v
Number of 10 Second Wait Loops = 2000
Return Code = 0
Title = Update version component info
Title Message Num = 0
Estimated Disk Space = 0
Backup Db = 0
Parallelizable Item = 0
Prompt User For Status = 0

[File Execute Entry 10]
Type = FileExecute
File Name = $SiebelRoot\bin\repimexp
Check Return Code = 1
Return Code Compliance = 0
16 Bit App = 0
Command Line = /a I /g $RepeatForLanguage /u $UserName /p $Password /c "$ODBCDataSource" /D $DatabaseOwner /M y /R "$AncestorRepName" /F $AncestorRepFile /l $SiebelLogDir/repx.log
Number of 10 Second Wait Loops = 2000
Return Code = 0
Title = Import Common Ancestor Repository
Title Message Num = 0
Estimated Disk Space = 0
Backup Db = 0
Parallelizable Item = 0
Prompt User For Status = 0

How to Locate Upgrade Driver Files and SQL Scripts

Driver files are stored in the following location:

Windows: DBSRVR_ROOT\DB2390\UPGRADE\VERSION

UNIX: DBSRVR_ROOT/DB2390/UPGRADE/VERSION

where VERSION is the version from which you are upgrading, for example v7.7

For example, if you are upgrading from Siebel CRM 7.7, the driver files for the development environment upgrep are as follows:

driver_upgrep_dev_77_mf_m.ucf

driver_upgrep_dev_77_mf.ucf

Related Topic