Implementing Siebel Business Applications on DB2 UDB for z/OS > Installing the Siebel Schema on the DB2 Host > Performing a Standard Installation >

Deploying User-Defined Functions

Two user defined functions (UDFs) are provided in the Siebel application: nextseq and exrate. The nextseq() UDF generates sequential values for Enterprise Integration manager (EIM) export and the exrate() UDF is used for currency aggregation functions. After the schema is validated, you must install the UDFs using the following instructions. These instructions are applicable to both Windows and UNIX operating systems.

NOTE:  You must have Workload Manager (WLM) installed and configured to run the nextseq and exrate user-defined functions.

To deploy user defined functions

1. Navigate to the output directory (DBSRVR_ROOT\db2390\dboutput\install on Windows or $DBSRVR_ROOT/db2390/dboutput/install on UNIX) and modify the udfftp.txt FTP file as follows:
   1. Change the &IP address to the IP address or domain name of your mainframe.
   2. Change the &username to a valid TSO user ID.
   3. Change the SIEBELQ1 high level DSN qualifier to your DSN qualifier.
   4. Save the changes to the file.
2. Double-click DBSRVR_ROOT\db2390\dboutput\install\udfftp.bat (Windows) to execute the batch FTP script to send files to the mainframe, or issue the following command from UNIX:

   ftp -vn < udfftp.txt

   The script sends the following files to the mainframe from the DBSRVR_ROOT\db2390\storproc\zos directory on Windows or the $DBSRVR_ROOT/db2390/storproc/zos directory on UNIX:

   • SIEBEL.UDF.RECEIVE.JCL
   • SIEBEL.UDF.LOAD.XMIT
   • SIEBEL.UDF.CNTL.XMIT
   • SIEBEL.UDF.DDL.XMIT
   • SIEBEL.UDF.DBRM.XMIT
3. Modify the USER_ID.SIEBEL.UDF.RECEIVE.JCL data set according to the instructions included in the JCL member, and submit it to receive the files in a readable format.
4. Before running the BIND, CREATE and WLMRFSH jobs, edit the UDF.DDL file and set the following values:
   • Set the Collid value in the exrate function to your table owner name
   • Set the WLM environment variable in the exrate and nextseq functions to the name of your application environment.
5. Edit the WLMRFSH file by entering an asterisk to the left of the TYPRUN parameter to comment-out this command.
6. Run the jobs in the UDF.CNTL PDS in the following order:
   • IEBCOPY
   • BIND
   • CREATUDF
   • WLMRFSH

     The WLMRFSH (refresh) job must be the last job run.

     Make sure that the return code equals 0.

7. Return to the midtier to continue the Siebel Schema installation by populating the schema with seed data.