isolation level

przytula_guy · #1 (**permalink**) 07-26-11, 09:53

now it is my turn, to ask a question
db2 luw 9.5 fp8 on Plinux
dynamic sql coming in from hibernate
we can see the package being used = SYSSH200 and default isolation is CS for this package
Is it possible to see, what is the current isolation level of this agent/applid.
as it might be possible that some connection string does specify isolation level
as we can see many lock escalation in diag file
I did execute a snapshot - used db2pd, but could not see this info
any hint would be welcome - thanks for all update

stiruvee · #2 (**permalink**) 07-26-11, 12:11

WLM_GET_ACTIVITY_DETAILS table function can be used to identify isolation level used by application. See the following link for additional details.

WLM_GET_ACTIVITY_DETAILS table function - Return detailed information about a specific activity

Note: DB2 Performance optimization (optional) feature is required to use workload manager.

Satya...

JAYANTA_DATTA · #3 (**permalink**) 07-26-11, 13:40

did you try the CURRENT ISOLATION special register in V9.X ?

sathyaram_s · #4 (**permalink**) 07-26-11, 14:14

db2pd -activestatements

does provide this info.

---

przytula_guy · #5 (**permalink**) 07-27-11, 02:09

thanks for the update
any idea how to translate : EffISO=1 to isolation level ?
(current isolation is for within an active user, it can not be executed for another user..)
thanks for all update