Bookshelf Home | Contents | Index | PDF     

Implementing Siebel Business Applications on DB2 UDB for z/OS > Siebel Repository Import and Postinstallation Tasks >

Importing the Siebel Repository

Importing the Siebel Repository 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 Business Applications, Release 7.8 application objects.

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

You can also export the Siebel Repository 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 wizard and follow the steps in Performing a Standard Installation Under Windows until the Siebel Database Operation screen is displayed (Step 6).
  2. Select the Import/Export Repository option, and click Next.
  3. On the Select Repository Operation screen, select one of the following options, as appropriate:
    • Import Repository

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

    • Add Language to an Existing Repository

      If you have 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 imported your base-language repository before you can add a new language.

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

      NOTE:  You can also use the Repository export option to replicate repositories.

      To continue, click Next.

  4. On the Import Selection screen, indicate whether you want to import a standard Siebel 7 repository, or a customized repository, by clicking the appropriate radio button.

    NOTE:  Select Import Custom Repository when you are importing a multilingual repository from a test or development environment. This imports all languages to your target repository.

    To continue, click Next.

  5. On the Language Selection screen, select the language in which you want to run the database.
  6. On 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.

    NOTE:  If you want to work with information on a different database server to the one you currently point to, you can enter the ODBC name of that database server, provided it is registered as an ODBC data source within DB2 Connect.

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

    To continue, click Next.

  7. In the Database User Name screen, enter the database user name and the associated password.

    The Database User Name is the ID used to log into the Siebel Database Server. This user ID should be part of the security group with authorization to set the current SQLID to the schema name.

    To continue, click Next.

  8. On the Siebel Schema Qualifier screen, enter the ID that identifies the Siebel Schema owner, for example, SIEBTO, and click Next.
    • If you are importing your repository for the first time, the Import Repository Name screen appears. Proceed to Step 9.
    • If you are exporting your repository, the Export Repository Name screen appears. Proceed to Step 10.
  9. On the Import Repository Name screen, indicate the following:
    • Import Repository Name

      Enter the designated name for this Siebel Repository.

    • Repository File Name

      Accept the default installation path and file name for this repository or type another valid installation path.

      To continue, click Next. Proceed to Step 11.

  10. On the Export Repository Name screen, type the following values:
    • Export Repository Name

      Accept the default name (Siebel Repository) or type another valid name.

    • Repository File Name

      Accept the default installation path and file name for this repository or type another valid installation path.

      To continue, click Next.

  11. On the Log Output Directory screen, accept the default directory name (imprep) or type another valid name.
  12. When the runnow message box appears, click OK to apply the configuration now, or click Cancel to apply it later.

    To rerun the Siebel Upgrade Wizard later, navigate to the SIEBSRVR_ROOT\bin directory and enter the following from the command line:

    siebupg.exe /m master_imprep.ucf

  13. On the Configuration Parameter Review screen, review the configuration values that you entered on the previous configuration screens, and then click Finish.

    The Upgrade Wizard launches.

  14. Click OK to begin the repository import/export or Cancel to exit.

    A window appears, displaying information about the repository import (export) activities. Afterwards, a message appears when the repository import (export) is completed.

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

TIP:   Locate the file master_imprep.ucf in the SIEBSRVR_ROOT\ bin directory and print it out, so that you have a record of the values you entered.

To import the Siebel Repository under UNIX

  1. Launch the Database Server Configuration wizard and follow the steps in Performing a Standard Installation Under UNIX until the Siebel Database Operation screen is displayed (Step 10).
  2. Select the Import/Export Repository option.
  3. On the Repository Operations screen, choose one of the following options, according to the procedure you want to complete:
    • Import Repository

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

    • Add Language to an Existing Repository

      If you have 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 imported your base-language repository before you can add a new language.

    • Export Repository

      Exports the Siebel Repository into a platform-independent file that can be sent to Siebel Technical Support for analysis, if necessary. Proceed to Step 6.

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

  4. If you select the Import Repository option, the Import Selection screen appears. Specify whether you want to import a standard Siebel 7 repository, or a customized repository, by entering the number associated with the option.

    NOTE:  Select Import Custom Repository when you are importing a multilingual repository from a test or development environment. This imports all languages to your target repository.

    Proceed to Step 5.

  5. Select the language in which you want to run the database. (This is your base language.)
  6. 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 (you must have registered this alias within DB2 Connect).

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

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

  7. Specify the database user name and password.

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

  8. Specify the Siebel Schema Qualifier, for example, SIEBTO.

    This value is the identifier that designates the Siebel Schema and is also an authorization ID. The Schema Qualifier must be in uppercase, must start with a letter, cannot contain special characters, and can be up to eight characters in length.

    • If you are importing your repository for the first time, the Import Repository Name screen appears. Proceed to Step 9.
    • If you are exporting your repository, the Export Repository Name screen appears. Proceed to Step 11.
  9. On the Import Repository Name screen, indicate the designated name for this Siebel Repository.
  10. Enter the default installation path and file name for the repository or type another valid installation path.

    Proceed to Step 12.

  11. In the Export Repository Name screen, enter the following values:
    • Export Repository Name

      Accept the default name (Siebel Repository) or type another valid name.

    • Repository File Name

      Accept the default installation path and file name for this repository or type another valid installation path.

  12. On the Common Parameters screen, accept the default directory name (imprep) or type another valid name to indicate where log output files are to be created.
  13. Review the configuration values that you entered on the previous configuration screens and then enter 1 (Yes) to launch the Siebel Upgrade wizard (srvrupgwiz).

    If a program or system error occurs and you have to rerun the Siebel Upgrade wizard, you can do so, starting at the point at which the wizard failed, by navigating to $SIEBEL_ROOT/bin and entering the following from the command line:

    srvrupgwiz /m master_imprep.ucf

    If the repository import (export) is successful, the Upgrade Wizard displays a message that the repository has been imported (or exported). Otherwise, see the log files.

    
Implementing Siebel Business Applications on DB2 UDB for z/OS