Bookshelf Home | Contents | Index | Search | PDF |
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
- 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.
- In the Gateway Server Address screen, type the following values as you recorded them in your copy of Deployment Planning Worksheet.
- 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.
CAUTION: If you subsequently add a new language (after you complete your initial installation with your initial set of languages), leave the Gateway Server Address and Enterprise Server Name fields blank.
- In the Siebel Server Directory screen, perform either of the following tasks:
- Accept the default value displayed in the Siebel Server Directory field. (This is the
SIEBSRVR_ROOT
directory, for example,D:\sea7xx\siebsrvr
.)- Use the browse button to select an alternate directory path.
To continue, click Next.
- In the Siebel Database Server Directory screen, perform either of the following tasks:
- Accept the default path displayed in the Siebel Database Server Directory field. (This is the
DBSRVR_ROOT
directory, for example,D:\sea7xx\dbsrvr
.)- Use the Browse button to select an alternate directory.
To continue, click Next.
- In the Database Platform screen, select the database platform you use, in this case, DB2 UDB for OS/390 and z/OS.
To continue, click Next.
- In the Siebel Database Operation screen, select Import/Export Repository, and then click Next.
- In the Select Repository Operation screen, choose 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 8.
- 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.
- 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 9.
NOTE: Repository export can also be used to replicate repositories.
To continue, click Next.
- In the Import Selection screen, indicate the following:
- To import a standard Siebel 7 repository, click the uppermost radio button.
- To import a Siebel 7 repository that you have customized to a new environment, click the bottom radio button.
NOTE: Select Import Custom Siebel 7 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.
- 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.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.
- In the Database User Name screen, indicate the following:
- Database User Name. Type 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.
- Database Password. Type the password for the ID used to log into the Siebel Database Server.
- Database Password (confirm). Retype the password to confirm it.
To continue, click Next.
- 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.
This is also the SQL Authorization ID stored in the CURRENT SQLID special register.
- If you are importing your repository for the first time, the Import Repository Name screen appears. Proceed to Step 12.
- If you are exporting your repository, the Export Repository Name screen appears. Proceed to Step 13.
- In the Import Repository Name screen, indicate the following:
- Import Repository Name. Type the designated name for this Siebel Repository.
- Repository File Name. If you are importing your repository for the first time, this is the second field appearing on the screen. Accept the default installation path and file name for this repository or type another valid installation path.
To continue, click Next. Proceed to Step 14.
- In 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.
- In the Configuration Parameter Review screen, review the configuration values that you entered on the previous configuration screens:
- To go back and make changes, click Previous to back out until you reach the screen with the parameter you need to change.
- 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".
The command line to apply the configuration later is
C:\sea704\siebsrvr\bin\siebupg /m master_imprep.ucfNOTE: 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
- When the DB Server Configuration Utility displays the items to be executed or imported, click OK to begin.
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
- Source environment variables from
$
SIEBEL_ROOT
.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 asLANG
;
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_ROOTLANGUAGE=
New Value
; export LANGUAGE- Go to
$
SIEBEL_ROOT
/bin
and enter:dbsrvr_config.ksh
This launches the Database Server Configuration Wizard.
- Review the values of the following environment variables and confirm whether the settings are correct by entering either
Y
orN:
SIEBEL_ROOT = path of your Siebel installation directory
LANGUAGE
= language in which you are installing
NOTE: If the values for either
SIEBEL_ROOT
orLANGUAGE
are not set or are incorrect, you must correct them before proceeding.- Specify the path of your Siebel Server root directory, or accept the default by pressing ENTER.
- Specify the path of your database server root directory, or accept the default by pressing ENTER.
- Enter the number corresponding to your RDBMS platform, in this case, DB2 for OS/390 and z/OS
(2)
.- From the Siebel Database Operation menu, choose Import/Export Repository (
3
).- Enter the number that corresponds to the procedure you want to complete:
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.
- Specify the applicable import option:
1 - Import Siebel Repository.
To import one additional language to your repository, enter1
. See Importing a New Language to Your Repository.
2 - Import Custom Repository.
To import all languages to your repository, enter2
. Proceed to Step 10.NOTE: Option 2 is used when you are importing a multilingual repository from a test or development environment.
- 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
).- 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 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
.- Specify the Database User Name.
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.
- Enter the database password.
- Specify the Schema Qualifier.
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.
- Specify the group ID or accept the default (SSEROLE) by pressing ENTER.
This is the group to which schema access is being granted.
- Enter the name of your import or export repository, or accept the default,
Siebel Repository
.- Enter the name of your repository file or accept the default,
mstrep.dat.
The utility displays the values entered so far and prompts you as to whether you want to run the Upgrade Wizard.
- If the values are correct, launch the Wizard (
srvrupgwiz
) by enteringY.
- To change the values you previously entered, rerun the Configuration Wizard by entering
dbsrvr_config.ksh
. This allows you to reconfigure with different values.NOTE: If a program or system error occurs and you need to rerun the Wizard, you can do so, starting at the point at which the wizard failed, by navigating to
$
SIEBEL_ROOT
/bin
and entering:srvrupgwiz /m master_imprep.ucf
If the repository import was successful, it displays a message that the repository has been imported. Otherwise, see the log files.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |