Bookshelf Home | Contents | Index | PDF     

Implementing Siebel Business Applications on DB2 UDB for z/OS > Installing the Siebel Schema on the DB2 Host > Preparing for a Custom Installation >

Extracting a Storage Control File from the DB2 Catalog

You can create a storage control file to use during a custom installation using the Siebel extract utility. This utility extracts the storage layout of your source database from the DB2 catalog and creates a new storage control file that you can use 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. See Validating the Extracted Storage Control File.

Follow the instructions below to extract a storage control file under Windows and under UNIX respectively.

To extract the storage control file under Windows

  1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under Windows until the Siebel Database Operation screen is displayed (Step 6).
  2. From the Siebel Database Operation screen, select Run Database Utilities, and then click Next.
  3. From the Database Utility Selection screen, select Configure Database, and then click Next.
  4. The following options are available on the Database Configuration Options screen:
    • Extract Storage File.

      Select this option to extract a storage control file based on the existing Siebel Schema layout.

    • Validate Storage File.

      Select this option to validate that a specified template and a specified schema will work on the DB2 host.

      Select Extract Storage File, and then click Next.

  5. On the ODBC Data Source Name screen, you can either select 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 specify a different data source name.

    NOTE:  The Siebel Server installation process automatically creates the data source, using the format SiebSrvr_EnterpriseServerName. To determine the name of your ODBC data source, navigate to Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC). Click the System DSN tab to view your ODBC data source name.

  6. On the Database User Name screen, type your source database username and password, confirm the password by typing it again, and then click Next.
  7. On the Siebel Schema Qualifier screen, type the schema qualifier for your existing database, and then click Next.

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

  8. On the Extract Options screen, select Extract from Catalog, and then click Next.

    This option extracts the storage layout of your source database from the DB2 catalog. The output is a new storage layout.

  9. On the Default Database Name screen, enter the Default Database Name and the Default Table Space Name, and click Next.
  10. On the Default Storage Group for Table Spaces screen, enter values to indicate the Default Storage Group for Table Spaces and the Default Storage Group for Indexes, and click Next.
  11. On the Default Buffer Pool Name screen, specify the Default Buffer Pool Name for your table spaces and the Default Index Buffer Pool Name. Your DBA should have previously activated the buffer pools and granted access to them.
  12. On the Database Encoding screen, indicate whether your DB2 subsystem is ASCII or EBCDIC.
  13. In the Storage Control File screen, type the name you want to assign to the new storage control file, for example DBSRVR_ROOT\db2390\my_storage_file.ctl, and then click Next.
  14. On the Log Output Directory screen, indicate the directory where you want the log files to be generated.
  15. Apply the configuration, or indicate that you want to apply it later:
    • To apply the configuration now, in the runnow message box, click OK.
    • To apply the configuration later, click Cancel. You can re-start the configuration later by navigating to the SIEBSRVR_ROOT\bin directory and entering the following from the command line:

    siebupg.exe /m master_dbconfig_extract_catalog_mf.ucf

  16. In the Configuration Parameter Review screen, review the parameters that you entered, make any corrections necessary, and then click Finish.
  17. When the Siebel Upgrade Wizard launches, click OK.

    The Siebel Upgrade Wizard creates the storage control file.

To extract the storage control file under UNIX

  1. Launch the Database Server Configuration utility and follow the steps in Performing a Standard Installation Under UNIX until the Siebel Database Operation screen is displayed (Step 9).
  2. From the Siebel Database Operation screen, choose the 5 - Run Database Utilities option.
  3. From the Database Utility Selection screen, choose the 3 - Configure Database option.
  4. From the Database Configuration Options screen, choose the 1 - Extract Storage Control File option.
  5. Enter the number that corresponds to the language in which you are running your database.
  6. Enter your source ODBC connection name.
  7. Enter your source database username and password.
  8. In the Siebel Schema Qualifier screen, enter the schema qualifier in uppercase letters for your existing database or press ENTER to accept the default.

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

  9. In the Extract Options screen, select the Extract from Catalog option.
  10. Enter the default Database Name or press ENTER to accept the default.
  11. Enter the Default Table Space Name or press ENTER to accept the default.
  12. On the Table Storage Group screen, enter values to indicate the default storage group for table spaces or press ENTER to accept the default.
  13. On the Index Storage Group screen, specify the default storage group for indexes or press ENTER to accept the default.
  14. On the Default Buffer Pool Name screen, specify the Default Buffer Pool Name for your table spaces.
  15. On the Index Buffer Pool Name screen, specify the Index Buffer Pool Name. The buffer pools should already be activated and the DBA should have granted access to them.
  16. On the Database Encoding screen, indicate whether your DB2 subsystem is ASCII or EBCDIC.
  17. On the Storage File screen, type the directory path and name of the new storage control file, for example DBSRVR_ROOT/db2390/my_storage_file.ctl.
  18. On the Common Parameters screen, indicate where you want to generate the log files. The default is dbconfig_extract_catalog_mf.
  19. The configuration parameters you entered are listed for you to review. When you have verified them, enter 1 (Yes) to run the Upgrade Wizard (srvrupgwiz).

    The Siebel Upgrade Wizard creates the storage control file.

    
Implementing Siebel Business Applications on DB2 UDB for z/OS