Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Installing the Siebel Database Server and Configuring the Siebel Database >

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

On DB2 UDB, after installing the Siebel Database Server, you must copy stored procedures and user-defined functions (UDFs) from the Siebel Database Server installation to the DB2 UDB 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 Siebel Database Server and the RDBMS.

For information on how to perform basic DB2 UDB tasks, see IBM's Quick Beginnings guide.

To copy and install the stored procedures

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

   DBSRVR_ROOT/db2udb/siebproc/DBSRVR_OS

   where:

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

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

   Permissions for siebproc should 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 should be the instance owner, and the group should be the group to which the instance owner belongs.

   NOTE:  If you are deploying with DB2 UDB v8 64-bit, then you need to copy the siebproc64 library file to the sqllib/function directory and rename it to siebproc.

4. Proceed to Configuring the Siebel Database on the RDBMS.