How to check applications Isolation Level

dollar489 · #1 (**permalink**) 01-19-04, 13:18

Is there anyway to find the isolation level of an application using snapshot or any other utility?

DB2 UDB V8 on Windows

dollar

n_i · #2 (**permalink**) 01-19-04, 15:20

Quote:

Originally posted by dollar489
Is there anyway to find the isolation level of an application using snapshot or any other utility?

DB2 UDB V8 on Windows

dollar

I think explain snapshot shows the effective isolation level of the statement in question.

dollar489 · #3 (**permalink**) 01-19-04, 15:27

Actually, I am interested more in applications's isolation level. After issuing the command:

db2 list applications

I want to take an application from the list returned above and find out it's isolation level.

dollar

Quote:

Originally posted by n_i
I think explain snapshot shows the effective isolation level of the statement in question.