Re: Oracle DB2 gateway locks

From: John P. Higgins <jh33378_at_deere.com>
Date: Sat, 13 Mar 1999 09:57:13 -0600
Message-ID: <36EA8AD9.8CDB293D@deere.com>

That is just part of the 'Joy Of DB2'. DB2 locks on reads! So your Oracle users need to commit after their selects trrough the gataway!

I found out about this when our DB2 people implemented a 20 minute max idle time while holding a lock. This, in turn, gave 'strange errors to the gateway users.

HTH obolman_at_my-dejanews.com wrote:

> We're trying to use the Oracle-to-DB2 gateway (from Oracle 8.0.5). I perform
> simple queries (no DML) against some DB2 tables. It works but these queries
> cause DB2 to place locks on the tables. These locks prevent other DB2 users
> from updating them which makes it a huge problem. Is something missing in the
> gateway setup? Should I just do a rollback or commit after my queries? Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Mar 13 1999 - 09:57:13 CST