Isolation level = UR but still getting CS claim

jaalfer · #1 (**permalink**) 01-21-11, 10:56

Hi,

I use ISOLATION LEVEL ===> UR in SPUFI defaults, and I just run a simple select query.

I check Claimers in DB2 commands, I'm still getting a (CS,C) CLAIMINFO

Does this sound right? Is this a system default override or something?

ZOS

DB2 OS/390 9.1.5

Marcus_A · #2 (**permalink**) 01-21-11, 11:44

Try putting WITH UR at the end of the query and see what happens.

jaalfer · #3 (**permalink**) 01-28-11, 11:28

Yes, I used WITH UR and I'm still getting the CS claimer

Internet Services

Web Development

Digital Marketing

Consumer Tech