Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Siebel Schema Installation on the DB2 Host > Performing a Standard Installation >

Performing a Standard Installation Under UNIX


Perform the following steps for a standard installation under UNIX.

To perform a standard installation under UNIX

  1. Source environment variables from $SIEBEL_ROOT.
  2. 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 as LANG; 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_ROOT

    LANGUAGE=New Value; export LANGUAGE

  3. Go to $SIEBEL_ROOT /bin and enter:
  4. dbsrvr_config.ksh

    This launches the Database Server Configuration Wizard.

  5. Review the values of the following environment variables and confirm whether the settings are correct by entering either Y or N.
  6. SIEBEL_ROOT = path of your Siebel installation directory

    LANGUAGE = language in which you are installing

    NOTE:  If either the SIEBEL_ROOT or LANGUAGE value is not set or is incorrect, you must correct them before proceeding.

  7. Verify and accept the default for the path of your Siebel Server root directory and press ENTER.
  8. Verify and accept the default for the path of your database server root directory and press ENTER.
  9. Enter the number corresponding to your RDBMS platform, in this case, DB2 for OS/390 and z/OS (2).
  10. From the Siebel Database Operations prompt, choose Install Database (1).
  11. From the Installation Operations prompt, choose Install Database (1).
  12. 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).
  13. In the ODBC Data Source Name screen, accept the default name of the ODBC data source, 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, either by using the DB2 Client Configuration assistant or by natively registering to the DB2 Connect catalog, the Database, Node, and DCS entries.
  14. NOTE:  If you want to work with information on a different database server than the one currently pointed to, you can type in the ODBC name of that database server, as long as you previously registered it as an ODBC datasource within DB2 Connect.

    The Siebel Server installation process automatically creates the data source, using the format SiebSrvr_enterprise_server_name.

  15. Specify the Database User Name.
  16. 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.

  17. Enter the database password for the Database User Name from Step 11.
  18. Specify the Schema Qualifier, for example, SIEBTO.
  19. This is the up to eight-character (all uppercase) identifier that designates the Siebel Schema. This is also an authorization ID. The Schema Qualifier must be in uppercase, must start with a letter, and cannot contain special characters.

  20. Specify the group user ID or accept the default (SSEROLE) by pressing ENTER.
  21. This is the group to whom schema access is being granted.

  22. Specify the type of installation you want to perform (in this case, 1):
  23. 1 - Standard Install. The standard installation option installs the database using one of the Siebel-recommended default storage layouts.

    2 - Custom Install. The custom installation option allows you to install the database using your customized storage layout. See Performing a Custom Installation for a description of the custom installation process.

  24. Enter the number corresponding to the mechanism you want to use for installation:
  25. 1 - Generate DDL Into Files. Generates DDL required to create the Siebel Schema. Proceed to Step 17.

    You must later use FTP or a similar file transfer program to transport the DDL (schema.sql and ddlview.sql) to the DB2 host, where the DBA executes it, using customary methods, for example, SPUFI or DSNTEP2.

    2 - Run DDL automatically. Select this to apply the DDL and DML required to create the Siebel Schema directly against the database. The Siebel application uses ODBC to apply the required DDL to the DB2 host. Proceed to Step 19.

  26. Enter the path to the output directory for the DDL files that you will transfer to your zSeries machine, or accept the default directory:
  27. dbsrvr/db2390/dboutput/install

    NOTE:  If you plan to use a different output directory to hold the DDL than the Siebel default, you must create it before selecting this option.

  28. Enter the number that corresponds to the code page encoding scheme for your Siebel Database:
  29. 1- ASCII

    2- EBCDIC

    For more information on choosing the database code page, see Choosing the Database CCSID.

  30. Enter the number corresponding to the Siebel Schema Layout you prefer:
  31. 1 - Multiple Tables per Table Space

    2 - One Table per Table Space

    3 - Multiple Tables per Table Space with Partitioning

    4 - One Table per Table Space with Partitioning

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

  32. Enter the name for the storage group for table spaces, or accept the default name, SYSDEFLT.
  33. The name used should be discussed with the DBA before you start the installation.

  34. Enter the name for the storage group for indexes, or accept the default name, SYSDEFLT.
  35. Enter the name for your 4-KB buffer pool, or accept the default BP1.
  36. Enter the name for your 16-KB buffer pool, or accept the default, BP16K1.
  37. Enter the name for your 32-KB buffer pool, or accept the default, BP32K1.
  38. Enter the name for your index buffer pool, or accept the default, BP2.
  39. NOTE:  These buffer pools should be activated and granted by the DBA prior to the installation.

  40. Enter the Database Name Prefix. The default is SIEBDB.
  41. This prefix consists of up to six of the first characters in the names of your 18-22 logical Siebel Databases. This prefix must start with a letter and cannot contain any special characters.

  42. Indicate the directory where you want the log files to be generated.
  43. Review the values for accuracy.
  44. Indicate the following:
  45. Transfer schema.sql and ddlview.sql to OS/390 and have your DBA apply them to create the Siebel Schema.
  46. For information on how the DBA applies the DDL on the DB2 host, see Applying DDL on the DB2 Host.

  47. If you performed a manual install, validate that all tables and indexes are present in the logical schema. For information, refer to the information in Validating Siebel Schema Creation.
  48. Indicate which action you want to take:
  49. srvrupgwiz /m master_install_mf.ucf

When you have successfully completed the step of populating the seed data, you are ready to import the Siebel Repository.

TIP:  To preserve a record of the values you entered, locate and print the file named master_install_mf.ucf in the binary subdirectory of your Siebel Server installation directory.

The following files are generated by the installation into the default output directory (dbsrvr/db2390/dboutput/install) or into the output directory that you designated in Step 17.


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003