Current Isolation level

gylbharat · Posted: Fri Jan 13, 2012 6:59 pm

Hi,

I have a question... Suppose I am running a query in QMF for windows and not specifying the Isolation level in the query. What would be the default isolation level that would be used for the query?

Is there any environment variable which stores this setting?

Pandora-Box · Posted: Fri Jan 13, 2012 8:21 pm

This link doesnt give to the point asnwer but helps
ISOLATION

enrico-sorichetti · Posted: Sat Jan 14, 2012 12:32 am

for QMF DB2 on zOS the default isolation level is CS as per
www-304.ibm.com/support/docview.wss?uid=swg21006428

for Windoze QMF the isolation level is chosen at installation/customization time as per
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.qmf.doc.imww%2Fdsqxmst85.htm

both links were reached by googling with
QMF isolation level
qmf windows isolation level