Siebel Installation Guide for Microsoft Windows > 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 WIN32
3. Copy the file siebproc.dll to the FUNCTION subdirectory within the DB2 instance directory on the RDBMS computer where DB2 is installed.

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

   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.dll to the SQLLIB\FUNCTION directory, and rename it to siebproc.dll.
   • For a 64-bit DB2 database running on X64 architecture, copy the file siebprocEMT64.dll to the SQLLIB\FUNCTION directory, and rename it to siebproc.dll.
4. Proceed to Installing the Siebel Database.