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
- On the DB2 server, navigate to the following directory in the DB2 installation:
Windows: sqllib\function
UNIX: sqllib/function
- 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
- 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
- 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.
- Copy the file siebproc (siebproc64 for 64 bit systems) to the sqllib\function (UNIX: sqllib/function) directory in the DB2 installation.
|