Re: Comparison of DB2 and Oracle?

From: Philip Sherman <psherman_at_ameritech.net>
Date: Fri, 22 Oct 2004 13:56:35 GMT
Message-ID: <nk8ed.22543$Qv5.1112@newssvr33.news.prodigy.com>

Jim's comment about zOS behavior is what I also remember from my mainframe days. My recollection is that this was (is?) a characteristic of mainframe QMF because QMF interacts directly with the user and the SQL statements don't complete until the user closes the session. We even had a case where a user ran a query then went to lunch without terminating it and held locks for over an hour!

The solution I implemented was to switch to using DSNTEP2 (a freebie supplied with DB2) as a replacement for QMF for simple queries. Heavy duty reporting was moved to "canned" QMF procedures where knowledgeable programmers could optimize performance and concurrency.

Phil Sherman

Serge Rielau wrote:
> Jim,
>
> I can't comment on DB2 for zOS. Would be interested to know whether this
> behaviour is still in existence and whether it was condidered working as
> designed or a bug (e.g. a bad lock).
> The behaviour you describe seems to indicate that users also wouldn't be
> able to bind static apps concurrently.....
>
> Cheers
> Serge
Received on Fri Oct 22 2004 - 08:56:35 CDT