Siebel Installation Guide for UNIX > Configuring the Siebel Database >
Installing the Stored Procedures and User-Defined Functions on DB2 UDB
On DB2 UDB, 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 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 Database Configuration Utilities 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
- Log on to the Siebel Server machine on which you installed the Database Configuration Utilities.
- Navigate to the following subdirectory in the Database Configuration Utilities installation directory:
DBSRVR_ROOT /db2udb/siebproc/DBSRVR_OS
where:
- DBSRVR_ROOT = The Database Configuration Utilities 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, LINUX, or SOLARIS
- 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 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.
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.
- Proceed to Configuring the Siebel Database on the RDBMS.
|