Home > IT Answers > Business Intelligence > When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
Rofnh
20 pts.
 When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
DB2
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

Software/Hardware used:
ASKED: July 27, 2009  5:23 PM
UPDATED: July 27, 2009  9:51 PM
RELATED QUESTIONS
Answer Wiki:
Any SELECT statement should only acquire SHARE locks (non-exclusive). Another application should be able to read right thru them. Ensure that you are not forcing RR (repeatable read) isolation.
Last Wiki Answer Submitted:  July 27, 2009  8:07 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

thanks for the answer.

Rofnh
 20 pts.