Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Siebel Repository Import, Export, and Postinstallation Tasks >

Importing and Exporting the Siebel Repository

Repository import is the final step in the Siebel Schema installation process.

When you import the Siebel Repository, you populate all the repository tables in the Siebel Database Server with Siebel eBusiness Applications, Release 7.0 application objects.

Regardless of how many Siebel eBusiness Applications you are using (for example, Siebel Sales, Siebel Service, Siebel Marketing), you load data into the repository tables only once per installation.

The Siebel Repository can also be exported into a platform-independent file that can be sent to Siebel Technical Support for analysis in case of problems that cannot be diagnosed by telephone or email.

To import the Siebel Repository under Windows

  1. Launch the Database Server Configuration Utility, using any method described in Chapter 2: "Preparing for the Installation" of the Siebel Server Installation Guide for Microsoft Windows.
  2. In the Gateway Server Address screen, type the following values as you recorded them in your copy of Deployment Planning Worksheet.
  3. In the Siebel Server Directory screen, perform either of the following tasks:
  4. In the Siebel Database Server Directory screen, perform either of the following tasks:
  5. In the Database Platform screen, select the database platform you use, in this case, DB2 UDB for OS/390 and z/OS.

    6. To continue, click Next.

  6. In the Siebel Database Operation screen, select Import/Export Repository, and then click Next.
  7. In the Select Repository Operation screen, choose one of the following options, as appropriate:
  8. In the Import Selection screen, indicate the following:
  9. In the ODBC Data Source Name screen, enter the name of the ODBC data source, for example, SiebSrvr_Siebel, or enter the database alias you prefer to use for the data source. This alias should have been previously registered within DB2 Connect.

    10. NOTE:  If you want to work with information on a different database server than the one you currently point to, you can enter the ODBC name of that database server, as long as you have previously registered this as an ODBC datasource within DB2 Connect.

    The Siebel Server installation process automatically creates the data source, using the syntax: SiebSrvr_enterprise_server_name.

    To continue, click Next.

  10. In the Database User Name screen, indicate the following:
  11. In the Siebel Schema Qualifier screen, type the up to eight-character ID that identifies the Siebel Schema owner. This ID must be in uppercase, must start with a letter, and cannot include any special characters.

    12. This is also the SQL Authorization ID stored in the CURRENT SQLID special register.

  12. In the Import Repository Name screen, indicate the following:
  13. In the Export Repository Name screen, type the following values:
  14. In the Configuration Parameter Review screen, review the configuration values that you entered on the previous configuration screens:

    15. To apply the configuration now, press "OK".
    To apply the configuration later, press "Cancel".
    The command line to apply the configuration later is
    C:\sea704\siebsrvr\bin\siebupg /m master_imprep.ucf

    NOTE:  The last line in the prompt is generated dynamically based on the location of your Siebel Server installation.

    If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed, by navigating to \siebsrvr\bin and entering:

    siebupg /m master_imprep.ucf

  15. When the DB Server Configuration Utility displays the items to be executed or imported, click OK to begin.

    16. A window appears, displaying information about repository import activities. Afterwards, a message appears when repository import is complete.

    To verify that the import was successful, review the log files. See Reviewing the Log Files for Repository Import.

TIP:  Locate the file master_imprep.ucf in the binary subdirectory of your Siebel Server installation directory and print it out, so that you have a record of the values you entered.

If you need to change the values you previously entered, relaunch the Configuration Utility by double-clicking the Configure DB Server icon within Start > Programs > Siebel Enterprise Servers 7.x.x. This allows you to reconfigure with different values.

To import the Siebel Repository 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: dbsrvr_config.ksh

    3. 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. SIEBEL_ROOT = path of your Siebel installation directory

    LANGUAGE = language in which you are installing

    NOTE:  If the values for either SIEBEL_ROOT or LANGUAGE are not set or are incorrect, you must correct them 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 corresponding to your RDBMS platform, in this case, DB2 for OS/390 and z/OS (2).
  7. From the Siebel Database Operation menu, choose Import/Export Repository (3).
  8. Enter the number that corresponds to the procedure you want to complete:

    9. 1 - Import Repository. To import the Siebel Repository for the first time with a base language, select this option. Proceed to Step 9.

    2 - Add Language to an Existing Repository. If you already imported your Siebel Repository and its base language, select this option to add another language to the repository. See Importing a New Language to Your Repository.

    NOTE:  You must have already imported your base-language repository before you can add a new language.

    3 - Export Repository. Exports the Siebel Repository into a platform-independent file that can be sent to Siebel Technical Support for analysis if needed. Proceed to Step 10.

    NOTE:  Repository export can also be used to replicate repositories.

    If you selected Import Repository, the Import Selection screen appears.

  9. Specify the applicable import option:

    10. 1 - Import Siebel Repository. To import one additional language to your repository, enter 1. See Importing a New Language to Your Repository.

    2 - Import Custom Repository. To import all languages to your repository, enter 2. Proceed to Step 10.

    NOTE:  Option 2 is used when you are importing a multilingual repository from a test or development environment.

  10. Enter the number corresponding with the language in which you want to run your database. (This is known as your base language.) If you are installing your first language, this is (1).
  11. Enter the name of the ODBC data source, for example, SiebSrvr_Siebel, or enter the database alias you prefer to use for the data source. This alias should have been previously registered within DB2 Connect.

    12. NOTE:  If you want to work with information on a different database server than the one you currently point to, you can enter the ODBC name of that database server, as long as you have previously registered this as an ODBC datasource within DB2 Connect.

    The Siebel Server installation process automatically creates the data source, using the syntax: SiebSrvr_enterprise_server_name.

  12. Specify the Database User Name.

    13. This is the ID allowed to log into the Siebel Database. This user ID should have authorization to set the CURRENT SQLID, for example, SADMIN.

  13. Enter the database password.
  14. Specify the Schema Qualifier.

    15. This is the up to eight-character identifier that designates the Siebel Schema. This is also an authorization ID. The Schema Qualifier must start with a letter and cannot contain special characters. It must also be in upper case.

  15. Specify the group ID or accept the default (SSEROLE) by pressing ENTER.

    16. This is the group to which schema access is being granted.

  16. Enter the name of your import or export repository, or accept the default, Siebel Repository.
  17. Enter the name of your repository file or accept the default, mstrep.dat.

    18. The utility displays the values entered so far and prompts you as to whether you want to run the Upgrade Wizard.


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