Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Customizing a Development Environment >

Cloning an OS/390 or z/OS Database

---

Your DBA can clone your existing Siebel database to the target database. The DB2 system cloning process involves the following tasks:

Extracting a storage control file from the existing Siebel schema.
Using the newly extracted storage control file to generate a DDL file that your DBA will apply to create a clone of the Siebel schema.

To do this, you must run the database server configuration utility twice.

Extracting a Storage Control File from the Development Database

The first run of the database server configuration utility "reverse engineers" the existing Siebel schema by creating a storage control file (.ctl) file from the database.

For instructions on how to use this utility, see Extracting a Storage Control File from the DB2 Catalog.

Generating a DDL File from a Storage Control File

The second run of the database server configuration utility uses the newly created storage control file to generate a DDL file. This DDL file will be applied to the database by your DBA to create the Siebel schema clone.

To generate the DDL file under Windows

Launch the Database Server Configuration Utility in either of two ways:

Choose Start > Siebel Enterprise Server 7.x.x > Configure DB Server.

or

Open a command prompt.
Go to the SIEBSRVR_ROOT\BIN directory.
Run 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 IBM DB2 UDB for OS/390 and zSeries.

To continue, click Next.

In the Siebel Database Operation screen, select Install Database, and then click Next.
In the Select Installation Operation screen, select Install Siebel Database, 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, type your database username and password, confirm the password by typing it again, and then click Next.
In the Schema Qualifier screen, type the schema qualifier in uppercase and security group ID for your new database, and then click Next.
In the Select Installation Type screen, select the Customized Install, and then click Next.
In the Select Installation Mechanism screen, select the Generate DDL Into Files, and then click Next.
In the DDL Output Directory screen, type the following, and then click Next.
DDL output directory, for example: DBSRVR_ROOT\DB2390\dboutput\install
new storage control file, for example: DBSRVR_ROOT\DB2390\my_storage_file.ctl

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 operation when the following message appears.

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

NOTE:  If you want to clone the Siebel schema into more than one database, copy the generated DDL file, replace the schema qualifier in the DDL file, and then save the file under a new name.

To generate the DDL file 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 as LANG; 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_ROOT

LANGUAGE=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 or N.

NOTE:  If either the SIEBEL_ROOT or LANGUAGE 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.
In the Select Database Operation menu, choose Install Database (1).
In the Installation Operation screen, select Install Siebel Database (1).
Enter the number that corresponds to the language you are using, typically 1 for English.
Enter your source ODBC connection name.
Enter your database username and password, and then confirm the password by typing it again.
Enter the schema qualifier for your new database in uppercase.
Enter the group ID for your new database, or accept the default (SSEROLE) by pressing ENTER.
In the Installation Type screen, select Customized Install (2).
In the Installation Mechanism screen, select Generate DDL Into Files (1).
Specify the DDL output directory, for example
DBSRVR_ROOT/DB2390/dboutput/install.
Specify the new 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.

Enter Y to perform the operation when the following message appears.

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

NOTE:  If you want to clone the Siebel schema into more than one database, copy the generated DDL file, replace the schema qualifier in the DDL file, and then save the file under a new name.

Bookshelf Home | Contents | Index | Search | PDF