What is meant by isolation level?
A248) This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a ‘repeatable read’ holds all locks untile the transaction completes or a syncpoint is issued. For transactions using ‘cursor stability’ the page lock releases are issued as the cursor ‘moves’, i.e. as the transaction releases addressability to the records.
