Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > 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
NOTE: When validating the extracted storage control file, the validation job calls for the schema.ddl file, as an example. You should make a copy of ddl.ctl and name it schema.ddl, keeping the copy in the same location as ddl.ctl.
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
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
EnterpriseServerName. 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:
- 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,
To continue, click Next.
- On the Schema File screen, type the directory paths for the following files:
- The schema file
If your Siebel Schema has been modified, use schema.ddl. For the Siebel out-of-the-box Schema, use ddl.ctl.
- The storage control file that you want to validate (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.
To apply the configuration now, press "OK".
To apply the configuration later, press "Cancel".
- To validate that storage.ctl works, connect to the catalog and run ddlimp in validation mode.
- Review the log file (
ddlimp.log) that is generated in the log subdirectory under
To validate the storage control file under UNIX
- Verify that all servers are stopped:
- Stop the Siebel Gateway Name Server by typing:
- Stop the Siebel Servers by typing:
- Depending on your shell, source environment variables from
$SIEBEL_ROOT by typing:
- Navigate to
bin and enter:
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
- 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 z/OS and OS/390, then press ENTER.
- In the Select Database Operation screen, choose Run Database Utilities (
- In the Database Utility Selection screen, choose Configure Database (
- In the Database Configuration Options screen, choose Validate Storage Control File (
- 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 file generated by ddlimp (
ddlimp.log) in the log directory under