Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Database Server for DB2 UDB > Database Server Software Installation for DB2 >

Installing the Stored Procedures and User-Defined Functions on DB2

---

DBAs who want to install the stored procedures and user-defined functions on the Siebel Database Server must first transfer them there, and have installed the database server components. (For information on installing Siebel Database Server components, see Installing Database Server Components on DB2.)

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 Database Server is acceptable.

Copying and Installing Stored Procedure Code on DB2

To copy and install the stored procedure code, follow the procedure below appropriate to your database server platform.

For information on how to perform basic DB2 tasks, see IBM's Quick Beginnings guide, particularly, Appendix-B: Basic Task Knowledge, on the online Browse V7 Bookshelf.

To copy and install the stored procedure code under Windows

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

NOTE:  If you are deploying with DB2 v8 64bit which is supported for AIX, Solaris, and HP in 7.5.3, then you need to copy the siebproc64 library file to the sqllib/function directory and rename it from siebproc64 to siebproc.

The directory that contains the files to install is:

DBSRVR_ROOT \DB2UDB\SIEBPROC\DBSRVR_OS

where:

DBSRVR_ROOT = the database component subdirectory of your Siebel eBusiness Applications, release 7, installation directory (SIEBEL_ROOT\dbsrvr).

DBSRVR_OS = the operating system your database server runs on, for example, WINNT or WIN32.

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.

Proceed to Configuring the Database Server on DB2.

Bookshelf Home | Contents | Index | Search | PDF