1. Database Upgrade Guide for DB2 for z/OS
  2. Database Configuration in Siebel Enterprise Server Installer

Database Configuration in Siebel Enterprise Server Installer

In the Siebel Enterprise Server installer for your monthly update release, users (including administrator users) must review and modify the database details when prompted by the installer. The following database configuration in Siebel Enterprise Server installer is required:

  1. Select the Edit Configuration check box on the DB Config Utility Screen of the installer to modify the database parameters.

    • The following table describes the parameters that apply for all databases:

      Field

      Description

      Example

      RDBMS

      Database Platform Name

      Oracle Database Enterprise Edition

      Microsoft SQL Server

      IBM DB2 UDB for Linux UNIX Windows

      IBM DB2 for z/OS

      Database Table Owner

      Table Owner

      SIEBEL

      Database Table Owner User

      Table Owner User

      SIEBEL

      Database Table Owner Password

      Table Owner Password

      ********

      Database Username

      Database Username

      SADMIN

      Database Password

      Database Password

      ********

      ODBC DataSource Name

      ODBC DataSource Name

      Siebel_DSN

      Repository Name

      Siebel Repository Name

      Siebel Repository

      Security Group Id/Grantee

      Security Group Id/Grantee

      SSE_ROLE

      UNICODEDB

      Y for Unicode DB, N for non-Unicode DB

      Y

      PRIMARY_LANG_CD

      Primary language

      English

      OTHER_LANG_CD

      Other languages. If you have more languages in your database, highlight them here.

      German

      Japanese

      Hebrew

    • The following table describes the parameters that apply for Oracle and DB2 UDB databases:

      Field

      Description

      Example

      Index Tablespace Name

      The default Indexspace

      INDSPC, SEBL_IDX

      Tablespace Name

      The default Tablespace

      TBLSPC, SEBL_TBL

    • The following table describes the parameters that apply for IBM DB2 UDB for Linux, UNIX, and Windows:

      Field

      Description

      Example

      Tablespace 16K

      16K Page Tablespace

      TBLSPC16K

      Tablespace 32K

      32K Page Tablespace

      TBLSPC32K

    • The following table describes the parameters that apply for DB2390 databases:

      Field

      Description

      Example

      4KBUFFERPOOL

      4K Buffer Pool (Required).

      BP1

      8KBUFFERPOOL

      8K Buffer Pool (Required).

      BP8K1

      16K BUFFERPOOL

      16K Buffer Pool (Required).

      BP16K1

      32KBUFFERPOOL

      32K Buffer Pool (Required).

      BP32K1

      DBNAMEPREFIX

      Database Name Prefix (Required).

      D + Last 3 Characters of your schema qualifier

      DBCODE

      Database Code Page (Required).

      ASCII/EBCDIC/UNICODE

      INDEXBUFFERPOOL

      Index Buffer Pool (Required).

      BP2

      STOGROUPINDEXES

      Storage Group for Indexes (Required).

      		 SYSDEFLT

      STOGROUPTABLES

      Storage Group for Tables (Required).

      		 SYSDEFLT

  2. When prompted by the installer, enter the database password which is not stored in any configured files.

  3. When installation of the update release completes, the installer calls the PostInstallDBSetup utility and updates the status returned. That is, the installer displays whether the PostInstallDBSetup utility ran successfully or failed.

    The PostInstallDBSetup utility executes the required seed, schema, and manifest changes to the Siebel database. If there are failures with Post Installation Database Update, then re-execute the PostInstallDBSetup utility in standalone mode, after fixing any errors. For more information, see Rerunning Post Installation Database Update.

    After the PostInstallDBSetup utility has completed running, a Post Installation Database Update Report is automatically generated.