Confusion over Isolation level in a plan

mailsaurabh.tripathi · New User Joined: 22 May 2008 Posts: 56 Location: hyderabad

Hi

I have a scenario, in which an application program uses SQL's with 'UR' clause. The application is bound into a pachage(having some different isolation level), which is bound into a plan(having a different is level from package and query in program).

Now when the program is run, which isolation level will be in effect?
This scenario is not hypothetical, we have some situation, for which i need the above understanding.

Regards
Saurabh

dbzTHEdinosauer · Posted: Thu Aug 05, 2010 4:47 pm

gee, golly, I can understand how such a question would be so hard to answer.

But, it just happens, the the DB2 Application and SQL guide has a complete topic on the subject of (can you guess?): 4.2.5.2 Isolation overriding with SQL statements

and about plan/package conflicts, 4.2.5.1.6 When plan and package options differ

mailsaurabh.tripathi · New User Joined: 22 May 2008 Posts: 56 Location: hyderabad

thanx a lot Dick... for this wonderful link.

Regards
Saurabh Tripathi