Siebel Database Upgrade Guide > Preparing an IBM DB2 Database for a Siebel Upgrade >

Installing IBM DB2 Stored Procedures and Functions for a Siebel Upgrade

Upgrades from: Siebel 6.x.

Environments: Development, production test, production.

Databases: IBM DB2 only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

The upgrade creates and binds the stored procedures.

User-defined functions (UDFs) for Siebel have changed at Siebel 7.x. Before upgrading the database, you must copy the new UDFs to the DB2 server. The upgrade process binds the UDF package to the DB2 installation.

Copying the new UDF package is a two-step process:

• Deleting the existing stored procedures and UDFs.
• Copying the stored procedure package to the DB2 server.

Deleting the Existing Stored Procedures and UDFs

To delete the existing stored procedures and UDFs

1. On the DB2 server, navigate to the following directory in the DB2 installation:

   Windows: sqllib\function

   UNIX: sqllib/function

2. If the server is installed on a Windows platform, delete the following files:

   nextseq.dll

   nextseqd.exe

   siebstat.dll

   siebsdmy.dll

   siebtrun.dll

   siebfcst.dll

   mapping.dll

   updt2col.dll

   updt_addr_org_sp.dll

   updt_addrorg_intsp.dll

   updt_addr_per_sp.dll

3. If the server is installed on a UNIX platform, delete the following files:

   nextseq

   nextseqd

   siebstat

   siebupg1

   siebsdmy

   mapping

   updt2col

   siebtrun

   siebfcst

   updt_addr_org_sp

   updt_addr_per_sp

   updt_addrorg_intsp

Copying the Stored Procedure Package to the DB2 Server

To copy the stored procedure package to the DB2 server

1. On the host where you installed the Siebel Database Server, navigate to the following directory:

   Windows: DBSRVR_ROOT\db2udb\siebproc\server_os

   UNIX: DBSRVR_ROOT/db2udb/sibproc/server_os

   where:

   server_os is the operating system on which the DB2 server is installed.

2. Copy the file siebproc (siebproc64 for 64 bit systems) to the sqllib\function (UNIX: sqllib/function) directory in the DB2 installation.