Re: how to find out current isolation level?

Paul Hatcher (phatcher@cix.compulink.co.uk) wrote: : I've got around this by writing a function that I call for all isolation : level changes; the file has a static that is set by this function and can : be retreived by another function. : Paul Hatcher Graduate Associates Ltd +44 81 840 3110 - Phone : phatcher@cix.compulink.co.uk +44 81 567 1894 - Fax From memory ... here's my comments I use tbstat -k (I think), there is a column heading 'isolation' which identifies the current isolation mode. Read the Admin guide for more under tbstat (I think). This is probably not what you want, I use the aforementioned solution and control the isolation mode via encapsulation. I set the default state depending on the values from the warnings when I connect to the database (again in the DBA guide). George Long georgel@mindlink.bc.ca