Bookshelf Home | Contents | Index | Search | PDF

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

Installing 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 installed the Siebel Database Server components. (For information on installing Siebel Database Server components, see Installing the Database Server Software for 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 Siebel 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 Siebel Database Server's operating system.

For information on how to perform basic DB2 tasks, see IBM's Quick Beginnings Guide on IBM's online Browse V7 Bookshelf.

To copy the stored procedure file

Log on to the Siebel Server 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.1 64bit on AIX, Solaris, or HP-UX, then you need to copy the siebproc64 library file to the sqllib/function directory and rename it from siebproc64 to siebproc.

$DBSRVR_ROOT /db2udb/siebproc/DBSRVR_OS.

where:

DBSRVR_OS is the operating system your Siebel Database Server runs on; for example, AIX.

NOTE:  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.

Put the file siebproc into the function subdirectory within the DB2 UDB instance directory (where DB2 UDB is installed) on the Siebel Database Server.

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

Bookshelf Home | Contents | Index | Search | PDF