Hi,
When I learn to use QMF I was always told to use WITH UR; in the query but it's use in COBOL Db2 program is not that much advised. What is the purpose of using uncommitted read in a DB2 query? Are there some practical scenarios where we actually need it apart from QMF? Or it has got no practical usage as such?
Use of uncommited read in DB2.
-
- Global Moderator
- Posts: 490
- Joined: Sun Aug 25, 2013 7:24 pm
Re: Use of uncommited read in DB2.
If it doesn't matter that the data you have just accessed disappears a very tiny fraction of a second after you have used it (because that is when it happened to get "rolled back" rather than "committted"), then you're fine using WITH UR.
However, if that scenario would be problematic, then it would be outright bad to use WITH UR.
However, if that scenario would be problematic, then it would be outright bad to use WITH UR.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute