err I have not used db2 in the past year except for Hibernate testing - and never on AS/400 - but anyway, IIRC, the default is actually what DB2 calls "repeatable read", which is what ANSI calls serializable. You probably want to change it to "cursor stability" (read committed) or "read stability" (repeatable read) if you want high concurrency. If you are using Hibernate, I would go for read committed, especially if you are
(a) using versioning (optimistic locking)
(b) using the second-level cache
This is hilarious, actually:
Code:
ANSI DB2 Oracle
serializable repeatable read N/A
repeatable read read stability serializable
wtf?