|
If you were logged in you would be able to see more operations.
|
|
|
|
File Attachments:
|
|
|
Environment:
|
IBM DB2 UDB v8.2 or later
|
|
| Resolution Date: |
01/Mar/07 02:20 AM
|
|
There is new SELECT "FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS" syntax in DB2 v8.2 and later that can be used to implement pessimistic locks for selects with multiple from tables, subselects, inner/outer joins and so forth. I'll attach simple patch shortly.
|
|
Description
|
There is new SELECT "FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS" syntax in DB2 v8.2 and later that can be used to implement pessimistic locks for selects with multiple from tables, subselects, inner/outer joins and so forth. I'll attach simple patch shortly. |
Show » |
| No work has yet been logged on this issue.
|
|
Improvement
Closed
Major
Better pessimistic lock support for DB2 v8.2+
