Bookshelf Home | Contents | Index | Search | PDF

Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Siebel Schema Installation on the DB2 Host > Preparing the Database Layout >

Validating the Storage Control File

---

You must validate the storage control file after you extract it or after you modify it. The validation will produce two output files in the log directory under SIEBSRVR_ROOT:

db_config_siebel.log
db_config_validation.log

To validate the storage control file under Windows

Run the Siebel Software Configuration Utility as you did in Extracting a Storage Control File from the DB2 Catalog.
From the Database Utility Selection screen, choose Configure Database and click Next.

The Configure Database screen appears with the following options:

Extract Storage Control File
Validate Storage Control File
Choose Validate Storage Control File and click Next.
On the ODBC Data Source screen, accept the default name of the ODBC data source after verifying that it is correct (make sure that this has the same name as the subsystem qualifier), or enter a different data source name.

NOTE:  The Siebel Server installation process automatically creates the data source, using the format SiebSrvr_EnterpriseName. To find the name of your ODBC data source, navigate to Start > Settings > Control Panel > ODBC data source. Click the System DSN tab and you will find the name of your ODBC data source.

To continue, click Next.

On the Database User Name screen, indicate the source user name and password for your database:

Database User Name. Type the ID allowed to log in to the Siebel Database. This user ID should have authorization to set CURRENT SQLID.

Database Password. Type the password for the ID used to log in to the Siebel database.

Database Password (confirm). Retype the password to confirm it.

To continue, click Next.

The configuration utility will validate your username and password before it will proceed to the next screen. If you entered a valid username and password, the Schema Qualifier screen appears.

On the Siebel Schema Qualifier screen, type the up to eight-character identifier that designates Siebel Schema for your database. This is also an authorization ID. The schema qualifier must start with a letter and cannot contain special characters.

To continue, click Next.

On the Security Group ID screen, type the user ID of the group to whom schema access is granted, for example, SSEROLE.

To continue, click Next.

On the Schema File screen, type the directory paths for your schema file (for example, schema.ddl) and storage control file (for example, storage.ctl).

If schema file verification succeeds, the Configuration Parameter Review screen appears.

On the Configuration Parameter Review screen, review the configuration values you entered on the previous Configuration Utility screens.

NOTE:  Passwords are encrypted and will not appear in plain text either in the user interface or in the upgrade configuration files (UCF files). After a password is entered, it will always appear in encrypted form. If you need to use another password, you must rerun the configuration utility.

If you need to go back to make changes, click Previous to back out until you reach the screen with the parameter you need to change. Enter the valid parameter, and then click Next until you reach the Configuration Parameter Review screen again.
To accept the values you input with no changes, click Finish.

A message box appears with the prompt:

To apply the configuration now, press "OK".

To apply the configuration later, press "Cancel".

To validate that storage.ctl works, connect to catalog, run ddlimp in validation mode.
Review the log file (ddlimp.log) that is generated in the log subdirectory under SIEBELSRVR_ROOT.

To validate the storage control file under UNIX

Verify that all servers are stopped:
Stop the Gateway Name Server by typing: stop_ns
Stop the Siebel Servers by typing: stop_server ALL
Depending on your shell, source environment variables from $SIEBEL_ROOT by typing:

Korn shell

. siebenv.sh

C shell

source siebenv.csh

Navigate 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 or not the settings are correct by entering either Y or N.
SIEBEL_ROOT
LANGUAGE

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 IBM DB2 UDB for OS/390 and z/OS, then press Enter.
In the Select Database Operation screen, choose Run Database Utilities (5).
In the Database Utility Selection screen, choose Configure Database (3).
In the Database Configuration Options screen, choose Validate Storage Control File (2).
Enter your source ODBC connection name.

NOTE:  This needs to be the same as the actual name of your subsystem. That is, your database alias within DB2 Connect must be the same as the actual name of your DB2 subsystem.

Enter your source database username and password.
Enter the schema qualifier for your existing database (enter this value in all uppercase characters).
Enter the security group ID for your existing database, or accept the default (SSEROLE) by pressing Enter.
Specify the storage control file that you would like to validate.

The configuration parameters are listed.

When the program asks if you would like to run srvrupgwiz, enter Y for Yes.

The storage control file is validated.

Review the log files generated by ddlimp (ddlimp.log) that is generated in the log directory under SIEBELSRVR_ROOT.

Bookshelf Home | Contents | Index | Search | PDF