Implementing Siebel Business Applications on DB2 for z/OS > Installing the Siebel Database on the DB2 Host >
Performing a Standard Installation
This task is a step in Roadmap for Installing the Siebel Database. This topic describes how to perform a standard Siebel database installation using the Database Configuration Wizard. When you select the Install Database option on the Database Configuration Wizard, you can choose the installation mechanism to use: either Run DDL Automatically or Generate DDL Into Files. If you select the Run DDL Automatically option, performing the steps in the following procedure completes a standard Siebel database installation. If you select the Generate DDL Into Files option, after performing the procedure in this topic, you must also complete the tasks described in Completing the Siebel Schema Installation Using Generated DDL to complete your standard Siebel database installation. To perform a standard installation
- Start the Siebel Gateway.
- Start the Database Configuration Wizard using one of the following methods:
- On the Siebel Server Directory screen, enter the directory path of the Siebel Server that the Siebel database will connect to. Do one of the following:
- Accept the default value displayed in the Siebel Server Directory field. (This value is the
SIEBSRVR_ROOT directory, for example, C:\siebel\8.1.1.0.0\ses\siebsrvr (Windows) or siebel/8.1.1.0.0/ses/siebsrvr (UNIX).
- Use the Browse button to select the directory path where the Siebel Server is installed if it was not installed in the default directory.
To continue, click Next.
- On the Siebel Database Server Directory screen, enter the directory path to the Database Configuration Utilities software. Do one of the following:
- Accept the default path displayed in the Siebel Database Server Directory field. (This path is the
DBSRVR_ROOT directory, for example, C:\siebel\8.1.1.0.0\ses\dbsrvr (Windows) or siebel/8.1.1.0.0/ses/dbsrvr (UNIX).
- Select Browse to select the directory path where the Database Configuration Utilities were installed if they were not installed in the default directory.
To continue, click Next.
- On the database platform screen, select your database platform, in this case, IBM DB2 UDB for
z/OS, and then click Next.
- On the Siebel Database operation screen, select the Install Database option, and click Next.
- On the Select Installation Operation screen, select the Install Siebel Database option to install the Siebel Database Schema and populate it with seed data.
NOTE: If you have already installed your Siebel Database Schema in its base or primary language, and want to install a new language, select the option, Add a language to an existing Siebel Database. For further instructions, see Installing Multilingual Seed Data.
- Confirm that you want to install a new Siebel database, and click Next.
- Identify the appropriate database encoding method:
- If you previously indicated that your database is non-Unicode, the Database Encoding screen is displayed allowing you to indicate whether your DB2 subsystem is ASCII or EBCDIC. For more information about choosing the code page for your subsystem, see About Setting Up the DB2 Subsystem.
Select the appropriate option, and click Next.
- If you have installed more than one language pack onto the Siebel Server, the Base Language screen is displayed. Specify which language is the primary (base) language for the Siebel database, and click Next.
- Enter the following values for your Siebel database:
- ODBC Data Source Name. The Siebel Server installation process automatically creates the data source, using the format EnterpriseName_DSN, for example, SBA_82_DSN or Siebel_DSN. Use the default name of the ODBC data source or enter the database alias you prefer to use for the data source.
NOTE: Database aliases must be registered within DB2 Connect. If you define database aliases, you must add the TXNISOLATION parameter to the database alias entry in the db2cli.ini file and set it to have a value of 1. For information on setting values in the db2cli.ini file, refer to the relevant IBM documentation.
- Source Database DB2 Subsystem Name. Enter the name of the DB2 database instance into which you will install the Siebel Schema, for example, Q20K.
To continue, click Next.
- On the Siebel Database User Name screen, enter a value for the Database User Name field.
Type the ID (for example, SADMIN) used to log into the Siebel database. This user ID must be part of the security group (secondary authorization group) with authorization to set the current SQLID to the schema name.
- On the Siebel Database Password screen, type the password for the ID used to log into the Siebel database. Retype the password to confirm it, then click Next.
- On the Siebel Schema Qualifier screen, enter the character ID that identifies the Siebel Schema owner, for example, SIEBTO. Click Next to continue.
NOTE: This ID can be up to eight characters in length, must be in uppercase, must start with a letter, and cannot include any special characters. This value is the SQL Authorization ID stored in the CURRENT SQLID special register.
- On the Security Group ID/Grantee screen, type the group ID for which schema access is being granted, for example, SSEROLE.
For more information about the group authorization ID privileges, see Security Concepts for a DB2 for z/OS Environment.
- On the Select Installation Type screen, choose one of the following install options:
- In the Siebel Schema Layout screen, select one of the following layout options, then click Next:
- Siebel Schema without Partitioning. Choose this option if you want all tables in segmented table spaces.
- Siebel Schema with Partitioning. This layout includes a set of tables that are recommended for partitioning. The remaining nonpartitioned tables are in segmented table spaces. For more information on this option, see About Siebel Table Partitioning. For details about layout considerations, see Configuring the Siebel Database Layout.
- On the Storage Group for Table Spaces screen, enter the storage group name for table spaces, for example, SYSDEFLT, then click Next.
- Enter the storage group name for indexes, for example, SYSDEFLT, then click Next.
- The next four screens allow you to enter default names for the buffer pools assigned to table spaces. After entering a value on a screen, click Next to continue.
NOTE: Make sure that the buffer pools have previously been activated and that the DBA has granted access to them. For information about layout considerations, see Configuring the Siebel Database Layout.
- 4KB Buffer Pool Name. Type the 4-KB buffer pool name for your table spaces, or accept the default, BP1.
- 8KB Buffer Pool Name. Type the 8-KB buffer pool name for your table spaces, or accept the default, BP8K1.
- 16KB Buffer Pool Name. Type the 16-KB buffer pool name for your table spaces, or accept the default, BP16K1.
- 32KB Buffer Pool Name. Enter the 32-KB buffer pool name for your table spaces, or accept the default, BP32K1.
- Enter the name of a 4 KB buffer pool assigned to indexes, or accept the default name, BP2. This buffer pool must be activated and the DBA must have granted access to it. Click Next.
- Database Name Prefix. Type the prefix to assign to Siebel database names. The default value is SIDB. The prefix can consist of up to four characters, it must start with a letter, and it cannot contain any special characters.
NOTE: The database name prefix must be the same for all database objects in the Siebel schema because the prefix identifies an object as belonging to the Siebel schema. Siebel utilities can recognize and use Siebel objects only if they follow Siebel naming conventions.
- On the Select Installation Mechanism screen, indicate which of the following installation mechanisms you want to use:
- Generate DDL Into Files. Select this option to generate the DDL required to create the Siebel Schema into files. You must then transfer these files to the z/OS host where they can be applied by your DBA using customary methods, for example, SPUFI or DSNTEP2.
If you select this option, click Next and proceed to Step 25.
- Run DDL Automatically. Select this option to apply the DDL and DML required to create the Siebel Schema directly against the database, using ODBC to connect.
If you select this option, click Next and then proceed to Step 27.
- On the DDL Commit Frequency screen, select the number of DDL statements to be run before a COMMIT statement is issued. Click Next.
- On the Output Directory screen, specify the name of the directory where you want to save the Siebel Schema DDL files generated. Use lowercase characters for directory and path names unless directed otherwise. The default directory is DBSRVR_ROOT
\db2390\dboutput\install (Windows) or DBSRVR_ROOT/db2390/dboutput/install (UNIX).
- On the Log Output Directory screen, accept the default log directory or enter a new directory name, and click Next.
By default, the files are created in SIEBSRVR_ROOT\log\install_mf (Windows) or SIEBSRVR_ROOT/log/install_mf (UNIX).
- Save the configuration information you have entered and launch the Siebel Upgrade wizard as described in the following relevant topic:
- Depending on whether you chose to Run DDL automatically or Generate DDL into files, do one of the following:
- If you selected the installation option Run DDL Automatically, the Siebel Upgrade Wizard applies the DDL commands to create the Siebel Schema directly against the database on the z/OS host. When you receive a message stating that the configuration was applied successfully, click OK. This step completes the Run DDL Automatically installation option
.
- If you selected the installation option Generate DDL Into Files, the Siebel Upgrade Wizard is launched. Click OK and the Wizard generates the following files into the output directory that you designated in Step 26:
- schema.sql and ddlview.sql files. These contain the DDL to create the Siebel tables and indexes.
- instftp.bat. Use this batch file to run the Siebel-provided scripts, your own FTP, or a similar file transfer program to transport the DDL (schema.sql and ddlview.sql) to the DB2 host.
- instftp.txt. Use this file to transfer files to the mainframe.
- jobinstl.txt. Contains JCL and REXX execs to execute the DDL.
- To complete the installation process, you must now perform the steps in Completing the Siebel Schema Installation Using Generated DDL to apply the schema.sql and ddlview.sql files on the DB2 host.
|