Use of uncommited read in DB2.

[Sivak J P]

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?

[William Collins]

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.