Fix (APAR):  IY99239

Status: Fix

Release: WebSphere Business Integration Server Foundation 5.1.1.6

Operating System: All

Supersedes Fixes:

CMVC defect:  IY99239

Byte size of APAR: 891,223

Date: 06/11/2007

Abstract: Use Oracle HEXTORAW() function in WHERE clauses for the business process database.

Description/symptom of problem:

This fix applies to WBISF using Oracle(TM) for the business process database.
In WHERE clauses of DML statements, values of RAW columns, such as IDs, are
now passed to the database using the HEXTORAW() function. Without the HEXTORAW()
function being used, Oracle(TM) does not use indexes on RAW columns to retrieve data.

There is no need to change anything in the Oracle(TM) database system after applying the fix.

NOTE:  YOU MUST FIRST DOWNLOAD THE UPDATE INSTALLER TOOL IN ORDER TO INSTALL A FIX.
       The Update Installer can be downloaded from the following link:
       http://www-3.ibm.com/software/webservers/appserv/support/index.html


Directions to apply Fix:

1) Create temporary "Fix" directory to store the jar file:
             UNIX: /tmp/WebSphere/Fix
          Windows: c:\temp\WebSphere\Fix

2) Copy jar file to the directory

3) Stop WebSphere Application Server

4) Follow the Fix installation instructions that are packaged with the Update Installer on how to install the Fix.

5) Start WebSphere Application Server

6) The temp directory may be removed.


Directions to remove a Fix:

NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS
       ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be
          removed, fix3 must be removed first, fix2 removed, and fix3 re-applied.


1) Stop WebSphere Application Server

2) Follow the instructions that are packaged with the Update Installer on how to uninstall the Fix.

3) Start WebSphere Application Server