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!

[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