Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows >

Creating Siebel Stored Procedures for DB2-UDB

The DAC uses siebstat and siebtrun stored procedures when running ETL processes. Typically, these stored procedures will be available in your Siebel transactional database; they may not be available on the data warehouse database.

To verify the existence of these procedures, follow the steps below.

• From a DB2 command prompt or control center, issue the following SQL scripts:

  db2 => create table test_siebproc(id int);
  DB20000I The SQL command completed successfully.

  db2 => insert into test_siebproc(id) values (1);
  DB20000I The SQL command completed successfully.

  db2 => call siebtrun('TEST_SIEBPROC');
  SQL0805N Package "NULLID.SYSSH200" was not found. SQLSTATE=51002

  NOTE:  If you get an error message, you do not have the Siebel procedures.

Creating stored procedures must be performed by the database administrator.

To create DB2 stored procedures

1. Refer to folder SiebelAnalytics\dwdb\siebproc. It contains compiled Siebel stored procedures for all platforms.
2. Copy the stored procedures into the appropriate directory on the DB2 server side, for example, d:\Program Files\SQLLIB\function directory for Windows.

   If your DB2 environment is 32-bit, copy siebproc. If it is 64-bit, copy siebproc64 and rename it to siebproc.

   This directory also contains the files siebproc.sql and sqlproc.ksh file, which are used to create the function.

   Once these procedures are created, you can verify that they exist. After the test is complete, you can drop the table TEST_SIEBPROC.