Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Confusion over Isolation level in a plan

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Thu Aug 05, 2010 3:59 pm    Post subject: Confusion over Isolation level in a plan
Reply with quote

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
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Aug 05, 2010 4:47 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
mailsaurabh.tripathi

New User


Joined: 22 May 2008
Posts: 56
Location: hyderabad

PostPosted: Thu Aug 05, 2010 5:05 pm    Post subject:
Reply with quote

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


Regards
Saurabh Tripathi
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Syncsort TPF Level Majid Hussain SYNCSORT 2 Wed Apr 13, 2016 2:22 am
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Confusion while passing data to a cal... amitc23 COBOL Programming 5 Mon Mar 07, 2016 12:36 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us