Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Database Server > Siebel Database Server Installation >

Installing the Stored Procedures and User-Defined Functions on DB2

To install the stored procedures and user-defined functions on your Siebel Database Server, you must first transfer them to the Siebel Database Server, and you must have already installed the Siebel Database Server components. For information on installing Siebel Database Server components, see Installing the DB Server Components.

The user-defined functions (UDFs) and stored procedures must be transferred to and installed on the Siebel Database Server to support the Siebel product. Any method that transfers the necessary files to the correct location on the Siebel Database Server is acceptable.

Copying and Installing Stored Procedure Code on DB2

To copy and install the stored procedure code, complete the procedure that follows. Use the steps appropriate to the operating system on which the Siebel Database Server runs.

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

To copy and install the stored procedure

1. Log on to the Siebel Server source installation machine, and navigate to the source installation subdirectory that contains the Siebel Database installation objects.

   The directory that contains the files to install is:

   DBSRVR_ROOT\DB2UDB\SIEBPROC\DBSRVR_OS

   where:

   DBSRVR_ROOT = The Siebel Database Server component subdirectory of your Siebel eBusiness Applications installation directory (SIEBEL_ROOT\dbsrvr)

   DBSRVR_OS = The operating system your database server runs on, for example, WIN32

2. Copy the file siebproc.dll to the FUNCTION subdirectory within the DB2 UDB instance directory on the machine where DB2 UDB is installed.

   For example, on Windows, this location might be C:\SQLLIB\FUNCTION or C:\Program Files\sqllib\FUNCTION.

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

3. Proceed to Configuring the Siebel Database Server.