Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Customizing a Development Environment > Applying Schema Extensions to the Target Database >
Migrating Customizations from Development to the Target Database
CAUTION: Before you migrate your customizations from your development database to your target database, you must validate your storage control file. See Validating the Storage Control File.
When migrating customizations from your development source to your target database on the DB2 host, you can use one of two modes of execution:
- Run DDL Automatically. Select this to apply the DDL and DML required to create the Siebel Schema directly against the database, using an ODBC connection.
- Generate DDL Into Files. Select this to generate the DDL required to create the Siebel Schema.
You must later use FTP or a similar file transfer program to transport the DDL (schema.sql and bumpver.sql) to the zSeries machine, where the DBA executes it using customary methods, for example SPUFI.
This section describes the DDL-generation mode of execution that is generally used under a change-management system.
NOTE: If your development environment is on DB2 UDB for OS/390 and z/OS, your DBA can also clone it to the target database. For more information, see Cloning an OS/390 or z/OS Database.
NOTE: Siebel 7 does not support customized database triggers. If you have created customized triggers on your Siebel base tables, you must disable them before migrating the database schema. You must re-create the triggers after the migration is finished.
To migrate the schema under Windows
- Launch the Database Server Configuration Utility:
Choose Start > Programs > Siebel Enterprise Server 7.x.x > Configure DB Server.
or
- Open a command prompt.
- Go to the
SIEBSRVR_ROOT
\BIN
directory.- Enter the following command:
ssincfgw -l ENU -v Y
- In the screen that appears, select
dbsrvr.scm
.- In the Gateway Server Address screen, type the following values as you recorded them in your copy of Deployment Planning Worksheet.
- Gateway Server Address. The alias of the host on which you installed the Siebel Gateway.
- Enterprise Server Name. The name you gave to your Enterprise Server, for example,
siebel
.To continue, click Next.
- In the Siebel Server Directory screen, perform either of the following tasks:
- Accept the default value displayed in the Siebel Server Directory field. (This is the
SIEBSRVR_ROOT
directory, for example,D:\sea7xx\siebsrvr
.)- Use the browse button to select an alternate directory path.
To continue, click Next.
- In the Siebel Database Server Directory screen, perform either of the following tasks:
- Accept the default path displayed in the Siebel Database Server Directory field. (This is the
DBSRVR_ROOT
directory, for example,D:\sea7xx\dbsrvr
.)- Use the Browse button to select an alternate directory.
To continue, click Next.
- In the RDBMS Platform screen, select the database platform you use, for example, IBM DB2 UDB for OS/390 and z/OS.
To continue, click Next.
- In the Siebel Database Operation screen, select Migrate Repository, and then click Next.
- In the OBDC Data Source Name screen, type your source ODBC connection name, and then click Next.
- In the Database User Name screen, your source database username and password, confirm the password by typing it again, and then click Next.
- In the Schema Qualifier screen, enter the schema qualifier in uppercase and security group ID from your copy of Deployment Planning Worksheet and then click Next.
- In the Source Database Repository Name screen, type the source and target database repository names—typically Siebel Repository for both, and then click Next.
- In the Target RDBMS Platform screen, select IBM DB2 UDB for OS/390 and z/OS, and then click Next.
- In the Target Database ODBC Datasource screen, type your target ODBC connection name, and then click Next.
- In the Target Database User Name screen, enter your target database username and password, confirm the password by typing it again, and then click Next.
- In the Target Schema Qualifier screen, type the target schema qualifier in uppercase and the target group authorization ID, then click Next.
- In the Migrate Repository Mechanism screen, select the Generate DDL Into Files, and then click Next.
- In the DDL Output Directory screen, type the DDL output directory and storage control file, and then click Next.
For example, use
DBSRVR_ROOT
\db2390\dboutput\
dev2prod
andDBSRVR_ROOT
\db2390\
my_storage_file.ctl
, respectively.The Configuration Parameter Review screen appears.
- Review the parameters, and then click Finish.
The runnow screen appears, giving you the choice of applying the configuration now or applying it later (and specifying the command line to apply it later).
- Click OK to apply the configuration now.
The Siebel Upgrade Wizard launches.
- Click OK to perform the migration.
The Siebel Upgrade Wizard runs, creating the following files:
- schema.sql
- bumpver.sql
To migrate the schema under UNIX
- Source environment variables from
$
SIEBEL_ROOT
.
SIEBEL_ROOT
should be the path of your Siebel installation directory.
LANGUAGE
should be set to the language in which the Configuration Wizard prompts appear, for example,
enu
for U.S. English.NOTE:
LANGUAGE
is not the same asLANG
;
the former is the language in which the Configuration Wizard runs, while the latter is the code for the Language Pack you installed.If either of these values is incorrect or empty, reset them using one of the following commands, as appropriate to the shell you use:
csh
setenv SIEBEL_ROOT
New Value
setenv LANGUAGE
New Value
ksh
SIEBEL_ROOT=
New Value
; export SIEBEL_ROOTLANGUAGE=
New Value
; export LANGUAGE- Go to
$
SIEBEL_ROOT
/bin
and enter:dbsrvr_config.ksh
This launches the Database Server Configuration Wizard.
- Review the values of the following environment variables and confirm whether the settings are correct by entering either
Y
orN.
NOTE: If either the
SIEBEL_ROOT
orLANGUAGE
value is not set or is incorrect, you must correct it before proceeding.- Specify the path of your Siebel Server root directory, or accept the default by pressing ENTER.
- Specify the path of your database server root directory, or accept the default by pressing ENTER.
- Enter the number that corresponds to your database platform.
- From the Select Database Operation menu, choose Migrate Repository (
4
).- Enter the number that corresponds to the language you are using, typically
1
for English.- Enter your source ODBC connection name.
- Enter your source database username and password.
- Enter the schema qualifier in uppercase from your copy of Deployment Planning Worksheet.
- Specify the source database repository name, or accept the default by pressing ENTER.
- Specify the target database repository name, or accept the default by pressing ENTER.
- Select the target database platform by entering the number that corresponds to IBM DB2 UDB for OS/390 and z/OS.
- Enter your target ODBC connection name.
- Enter your target database username and password.
- Enter the target schema qualifier in uppercase.
- Enter the target group authorization ID, or accept the default ID, SSEROLE by simply pressing ENTER.
- In the Select Installation Mechanism screen, select Generate DDL Into Files (
1
).- Specify the DDL output directory, for example
DBSRVR_ROOT
/db2390/dboutput/
dev2prod
.
- Specify the storage control file, for example
DBSRVR_ROOT
/db2390/
my_storage_file.ctl.
The configuration parameters are listed and you are asked if you want to run
srvrupgwiz
.- Enter Y for yes.
The Siebel Upgrade Wizard launches.
- When the following message appears, enter Y to perform the migration.
Files schema.sql and bumpver.sql with the Siebel Schema modifications have been generated in the DDL Output Directory. Please select Yes to exit now and apply the files.
The following files are created:
- schema.sql
- bumpver.sql
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |