db2pd -activestatements

Private Pyle

I have a question about db2pd. When using the -activestatements the
column -EffISO is the effective isolation level. The value in this
column is an integer, not something easy like UR, CS, RS, or RR. The
documentation update doesn't tell me what the translation is, can some
please shed some light on this?

Thanks!

Apr 26 '06 #1

Jan M. Nelken

Private Pyle wrote:

I have a question about db2pd. When using the -activestatements the
column -EffISO is the effective isolation level. The value in this
column is an integer, not something easy like UR, CS, RS, or RR. The
documentation update doesn't tell me what the translation is, can some
please shed some light on this?

Thanks!

0 - Repeatable Read
1 - Cursor stability
2 - Uncommited Read
3 - Read stability

Jan M. Nelken

Apr 26 '06 #2