Siebel Installation Guide for UNIX > Installing the Siebel Database on the RDBMS >

Installing the Stored Procedures and User-Defined Functions on IBM DB2

On IBM DB2, after installing the Database Configuration Utilities, you must copy stored procedures and user-defined functions (UDFs) from the Database Configuration Utilities installation to the DB2 database server.

Any method that transfers the necessary files to the correct location on the database server is acceptable. To copy the stored procedure code, complete the procedure that follows. Use the steps appropriate to the operating systems for the Database Configuration Utilities and the RDBMS. For information about how to perform basic IBM DB2 tasks, see the Quick Beginnings guide from IBM.

To copy and install the stored procedures and user-defined functions

1. Log on to the Siebel Server computer on which you installed the Database Configuration Utilities.
2. Navigate to the following subdirectory in the Database Configuration Utilities installation directory:

   DBSRVR_ROOT/db2udb/siebproc/DBSRVR_OS

   where:

   • DBSRVR_ROOT is the Database Configuration Utilities component subdirectory of your Siebel Business Applications installation directory ($SIEBEL_ROOT/dbsrvr)
   • DBSRVR_OS is the string corresponding to the operating system your database server (RDBMS) runs on, such as AIX, HPUX, LINUX, or SOLARIS
3. Copy the file siebproc to the function subdirectory within the DB2 instance directory on the RDBMS computer where DB2 is installed.

   For example, on AIX, this location might be $INST_HOME/sqllib/function.

   Permissions for siebproc must be -rw-r---- (read-write for the owner, read for the group, and neither read nor write for all others). The owner of the file must be the instance owner, and the group must be the group to which the instance owner belongs.

   For a 64-bit DB2 database, do one of the following instead:

   • For a 64-bit DB2 database running on Itanium architecture, copy the file siebproc64 to the SQLLIB/FUNCTION directory, and rename it to siebproc.
   • For a 64-bit DB2 database running on X64 architecture, copy the file siebprocEMT64 to the SQLLIB/FUNCTION directory, and rename it to siebproc.
4. Proceed to Installing the Siebel Database.