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

Extracting a Storage Control File from the DB2 Catalog

DBAs can create a storage control file for use during installation by using another Siebel utility to extract it from the DB2 catalog. Access the extract utility through the Database Server Configuration Utility.

This utility allows you to extract the storage layout of your source database from the DB2 catalog. The utility creates a new storage control file that can be used during the custom installation process. You can use the extract utility at any time.

NOTE:  You must validate the storage control file after you extract it and after you modify it. You must also perform a validation before you apply the schema.sql on the DB2 host. See Validating the Storage Control File.

Accessing the Utility Under Windows

Follow the procedure below to access the utility under Microsoft Windows.

To extract the storage control file under Windows

  1. Launch the Database Server Configuration Utility:

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

    or

    1. Open a command prompt.
    2. Go to the SIEBSRVR_ROOT\bin directory.
    3. Run the following command:

      4. ssincfgw -l ENU -v Y

    4. In the screen that appears, select dbsrvr.scm.
  2. In the Gateway Server Address screen, type the following values as you recorded them in your copy of Deployment Planning Worksheet.

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

  3. In the Siebel Server Directory screen, use either of the following methods to select your directory:
  4. In the Siebel Database Server Directory screen, perform either of the following tasks:
  5. In the RDBMS Platform screen, choose IBM DB2 UDB for OS/390 and z/OS, and then click Next.
  6. In the Siebel Database Operation screen, select Run Database Utilities, and then click Next.
  7. In the Database Utility Selection screen, select Configure Database, and then click Next.

    8. The Configure Database screen appears with the following options:

  8. In the Database Configuration Options screen, select Extract Storage File, and then click Next.
  9. In the OBDC Data Source Name screen, accept the default name of the ODBC data source after verifying that it is correct (make sure that this data source has the same name as the subsystem qualifier), or enter a different data source name.

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

  10. In the Database User Name screen, type your source database username and password, confirm the password by typing it again, and then click Next.

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

  11. In the Siebel Schema Qualifier screen, type the schema qualifier and group ID for your existing database, and then click Next.

    12. The schema qualifier is also an authorization ID. The schema qualifier must start with a letter and cannot contain special characters.

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

    13. To continue, click Next.

  13. In the Extract Options screen, select Extract from Catalog, and then click Next.

    14. This option extracts the storage layout of your source database from the DB2 catalog as-is. The output will be a new storage layout.

  14. In the Storage File screen, type the name of the new storage control file, for example DBSRVR_ROOT\DB2390\my_storage_file.ctl, and then click Next.
  15. In the The Configuration Parameter Review screen, review the parameters that you entered, then click Finish to confirm them.

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

  16. When the runnow screen appears, click OK to apply the configuration now.
  17. When the Siebel Upgrade Wizard launches, click OK to perform the migration.

    18. The Siebel Upgrade Wizard creates the storage control file.

Accessing the Utility Under UNIX

Follow the procedure below to access the utility under UNIX.

To create the storage control file under UNIX

  1. Source environment variables from $SIEBEL_ROOT.

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

  2. Go to $SIEBEL_ROOT /bin and enter:

    3. dbsrvr_config.ksh

    This launches the Database Server Configuration Wizard.

  3. Review the values of the following environment variables and confirm whether the settings are correct by entering either Y or N.

    4. NOTE:  If either the SIEBEL_ROOT or LANGUAGE value is not set or is incorrect, you must correct it before proceeding.

  4. Specify the path of your Siebel Server root directory, or accept the default by pressing ENTER.
  5. Specify the path of your database server root directory, or accept the default by pressing ENTER.
  6. Enter the number that corresponds to your database platform.
  7. In the Select Database Operation screen, choose Run Database Utilities (5).
  8. In the Database Utility Selection screen, choose Configure Database (3).
  9. In the Database Configuration Options screen, choose Extract Storage Control File (1).
  10. Enter the number that corresponds to the language you are using, typically 1 for English.
  11. Enter your source ODBC connection name.
  12. Enter your source database username and password, and then confirm the password by typing it again.
  13. Enter the schema qualifier in uppercase letters for your existing database.
  14. Enter the group ID for your existing database, or accept the default (SSEROLE) by pressing ENTER.
  15. In the Extract Options screen, select Extract from Catalog (1).
  16. Enter the name of the new storage control file, for example
    DBSRVR_ROOT/DB2390/my_storage_file.ctl
  17. When the configuration parameters are listed for your review and you are asked if you want to run srvrupgwiz, enter Y for yes.
  18. When the Siebel Upgrade Wizard launches, enter Y to perform the operation.

    19. The Siebel Upgrade Wizard creates the storage control file.


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003