Isolation Levels
The previous examples have shown some of the possible concurrency problems. DB2 UDB provides different levels of protection to isolate the data from each of the database applications while it is being accessed. These levels of protection are known as isolation levels or locking strategies. The isolation levels supported by DB2 include:
Uncommitted Read (UR)
Cursor Stability (CS)
Read Stability (RS)
Repeatable Read (RR)
The isolation level is defined for embedded SQL statements during the binding of a package to a database using the ISOLATION option of the PREP or the BIND command. If no isolation level is specified, the default level of cursor stability is used. If you are using the command-line processor, you can change the isolation ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
