Has anyone using a 'read only' data warehouse bound their Focus 7.2 plan with an isolation level of UR or uncommitted read? If so, did you see any negative impacts to this? We certain that there would be fewer locks being taken if we make the switch.

We are currently using CS.

Hi Mahonex:

Spoke to a product manager and here was the response:
An Isolation Level of UR is the equivalent of a "dirty read". There are no locks taken on the object and this is ideal for read only applications that operate in an environment where the data is not volatile (not changed often), or in applications that can tolerate the possibility of data being changed even while it is being read. Reading data that may not be accurate is the down side.

Hope this helps.

Also:

The access of data should be very fast because no locks or row is acquired. In order to use the UR Isolation level, check the DB2 restrictions.