Bookshelf Home | Contents | Index | PDF     

Implementing Siebel Business Applications on DB2 UDB 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.

Perform the steps in the following procedure to complete a standard Siebel Database installation.

To perform a standard installation

  1. Start the Siebel Gateway Name Server.
  2. Start the Database Configuration Wizard using one of the following methods:
  3. Enter the values for the Siebel Gateway Name Server Address and Enterprise Server Name as you recorded them in your copy of Deployment Planning Worksheet.
    • Gateway Name Server Address. The alias of the host on which you installed the Siebel Gateway Name Server.
    • Enterprise Server Name. The name you gave to your Enterprise Server, for example, SBA_80.

      To continue, click Next.

  4. 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, D:\sba80\siebsrvr (Windows) or /home/siebel/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.

  5. 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, D:\sba80\dbsrvr (Windows) or /home/siebel/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.

  6. On the database platform screen, select your database platform, in this case, IBM DB2 UDB for
    z/OS, and then click Next.
  7. On the Siebel Database operation screen, select the Install Database option, and click Next.
  8. 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. See Installing Multilingual Seed Data for further instructions.

  9. Identify the appropriate database encoding method:
    • UNICODE Database. If you select this option, click next and proceed to Step 11.
    • Non-UNICODE Database. If you select this option, click next and proceed to Step 10.

      CAUTION:  Choose the correct option for your database to prevent installing the wrong data types. The database will not be able to create Unicode data types on a non-Unicode page setting, so check this setting carefully before choosing the option.

  10. 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.

  11. 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.
  12. 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_80_DSN or Siebel_DSN. Accept 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.

  13. On the Database User Name screen, indicate the following values for your database:
    • Database User Name. 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.
    • Database Password. Type the password for the ID used to log into the Siebel Database.
    • Database Password (confirm). Retype the password to confirm it.

      To continue, click Next.

  14. On the Siebel Schema Qualifier screen, indicate the following values for your Siebel Schema and click Next to continue:
    • Siebel Schema Qualifier. Enter the character ID that identifies the Siebel Schema owner, for example, SIEBTO.

      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.

    • Security Group ID/Grantee. Type the group ID to which schema access is being granted, for example, SSEROLE.

      For more information about the group authorization ID privileges, see Security Concepts for z/OS.

  15. On the Select Installation Type screen, choose one of the following install options:
    • Standard Install. The standard installation option installs the database, using one of the Siebel-recommended default storage layouts.
    • Customized Install. For a customized installation, you provide a custom storage control file, which you have created and validated prior to performing this installation. This option allows you to create the database layout that is best suited to your Siebel deployment. See Process of Performing a Custom Installation for information on the remaining steps in the custom installation process.

      Select the Standard Install option, click Next, and proceed to Step 16.

  16. 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 Understanding Siebel Partitioning.

      For details about layout considerations, see Configuring the Database Layout.

  17. On the Storage Group screen, enter values for the following parameters, then click Next to continue:
    • Storage Group for Table Spaces. Enter the storage group name for table spaces, for example, SYSDEFLT.
    • Storage Group for Indexes. Enter the storage group name for indexes, for example, SYSDEFLT.
  18. Enter values for the following parameters, and click Next to continue:
    • 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.

      NOTE:  The buffer pools must be activated and the DBA must have granted access to them.

      For more information about layout considerations, see Configuring the Database Layout.

  19. Enter values for the following parameters, and click Next to continue:
    • 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.

      NOTE:  The buffer pools must be activated and the DBA must have granted access to them.

  20. Enter values for the following parameters, and click Next to continue:
    • Index Buffer Pool Name. Type the buffer pool name for the indexes, or accept the default, BP2. This buffer pool must be activated and the DBA must have granted access to it.
    • Database Name Prefix. Type the prefix for your database name. The default value is SIDB.

      This prefix consists of up to four of the first characters in the names of your logical Siebel databases. This prefix must start with a letter and cannot contain any special characters. All database names end in numbers.

  21. 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 22.

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

  22. On the DDL Commit Frequency screen, select the number of DDL statements to be run before a COMMIT statement is issued. Click Next.
  23. 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).
  24. 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).

  25. Save the configuration information you have entered and launch the Siebel Upgrade wizard as described in the following topics:
  26. 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 23:
      • 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.

    
Implementing Siebel Business Applications on DB2 UDB for z/OS Copyright © 2008, Oracle. All rights reserved.