1. Database Upgrade Guide for DB2 for z/OS
  2. Driver Files

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_811_mf_m.ucf

  • driver_upgrep_dev_811_mf.ucf

  • driver_upgphys_dev_811_mf.ucf

Here is an excerpt from a driver file that controls a development environment upgrep from Siebel CRM version 8.1.1 to Siebel CRM 16.0 or later (driver_upgrep_dev_811_mf.ucf). The excerpt contains two steps: 

[File Execute Entry 10]
Type = FileExecute
File Name = $SiebelRoot\bin\odbcsql
Check Return Code = 1
Return Code Compliance = 0
16 Bit App = 0
Is Script = 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\odbcsql
Check Return Code = 1
Return Code Compliance = 0
16 Bit App = 0
Is Script = 0
Command Line = /a I /g $RepeatForLanguage /u $UserName /p $Password /c 
"$ODBCDataSource" /D $DatabaseOwner /M y /R "$AncestorRepName" /F $AncestorRepFile 
/l $SiebelLogDir/imprep_ps.log /z 1000
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 = 0Parallelizable Item = 0
Prompt User For Status = 0