Bookshelf Home | Contents | Index | PDF     

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 SIEBSRVR_ROOT:

  • db_config_siebel.log
  • db_config_validation.log

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

  1. Run the Siebel Software Configuration Utility as you did in Extracting a Storage Control File from the DB2 Catalog.
  2. 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
  3. Choose Validate Storage Control File and click Next.
  4. 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_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.

  5. 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.

  6. 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.

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

  8. 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.

  9. 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".

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

To validate the storage control file under UNIX

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

    Korn shell

    . siebenv.sh

    C shell

    source siebenv.csh

  3. Navigate to $SIEBEL_ROOT /bin and enter:

    dbsrvr_config.ksh

    This launches the Database Server configuration wizard.

  4. 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.

  5. Specify the path of your Siebel Server root directory or accept the default by pressing ENTER.
  6. Specify the path of your database server root directory or accept the default by pressing ENTER.
  7. Enter the number that corresponds to IBM DB2 UDB for z/OS and OS/390, then press ENTER.
  8. In the Select Database Operation screen, choose Run Database Utilities (5).
  9. In the Database Utility Selection screen, choose Configure Database (3).
  10. In the Database Configuration Options screen, choose Validate Storage Control File (2).
  11. 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.

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

    The configuration parameters are listed.

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

    The storage control file is validated.

  17. Review the log file generated by ddlimp (ddlimp.log) in the log directory under SIEBSRVR_ROOT.
    
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390