I'm not a DB2 person typically, but I was wondering if someone could tell me if creating a view using "WITH UR"? We have a view that is dependent on a long running batch process that is locked several times during the day. The view based on this data does not have to be completely accurate. The batch process we have no control over, so we are looking to alter the isolation level of the view itself.

Any help would be appreciated,
Kyle

If you look at the V 9.5 (you did not mention you DB2 version or OS) for LUW documentation, a view is defined as a full-select. The full-select cannot have the isolation clause, only a select-statement.

Andy

They are on 8.something. I'm assuming the same applies?

That would be correct.

Andy

Great, thanks!