Using ISOLATION TO DIRTY READ with WebSphere Message Broker and IBM Informix

Technote (FAQ)


When using complex deployments that include multiple database interactions, your WebSphere Message Broker (WMB) message flow might receive a NULL result set in response to an Informix query, because a database row was locked at the time of the request.

To avoid this problem, can you access the database in a READ ONLY mode by setting the isolation level of the database to Dirty Read?


You can specify "SET ISOLATION TO DIRTY READ" as part of a WMB PASSTHRU statement, but you cannot include any other SQL statements.

By setting the isolation level in a separate statement, Dirty Read should remain in effect for the life of the connection, and allow you to read data in subsequent statements without encountering locked database rows.

Product Alias/Synonym

WMB MB WebSphere Message Broker MQ Integrator WBIMB WBI-MB MQSI WMQI

Rate this page:

(0 users)Average rating

Document information

More support for:

WebSphere Message Broker

Software version:

6.1, 7.0, 8.0

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation