1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Deploying User-Defined Functions

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> udfftp.log

    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. On the mainframe, navigate to the USER_ID.UDF.RECEIVE.JCL data set and edit the data set by typing e beside it, then press Enter.

  4. Press Enter again.

  5. Modify the job card parameters according to the instructions included in the JCL member.

  6. To submit the job, type submit on the command line, and press Enter. The files you sent to the mainframe in Step 2 are received in a readable format.

  7. Edit the HLQ.SIEBEL.UDF.DDL file by typing e before the data set name, and pressing Enter.

    1. Edit EXRATE by entering e before the function name and pressing Enter. Set the Collid value in the EXRATE function to your table owner name and set the WLM environment variable to the name of your application environment.

    2. Edit NEXTSEQ by entering e before the function name and pressing Enter. Set the WLM environment variable to the name of your application environment.

  8. Press F3 twice.

  9. Edit the HLQ.SIEBEL.UDF.CNTL data set by typing e before the data set name and pressing Enter.

  10. In the HLQ.SIEBEL.UDF.CNTL data set, edit and run the following JCL members in the order shown:

    • IEBCOPY

    • CREATUDF

    • BIND

    • WLMRFSH

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

    Edit and submit each JCL member in turn as follows:

    1. Edit the member by entering e before the member name and pressing Enter.

    2. Edit the job card parameters according to the instructions in the member.

    3. Submit the job by entering submit on the command line, and pressing Enter.

    Make sure that the return code for each job equals 0.

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