SAS/ACCESS Interface to DB2 Under z/OS |
The
following LIBNAME and data set options let you control how the DB2 under z/OS interface
handles locking. For general information about an option, see The LIBNAME Statement for Relational Databases. For additional
information, see your DB2 documentation.
-
READ_LOCK_TYPE=TABLE
-
-
UPDATE_LOCK_TYPE=TABLE
-
-
READ_ISOLATION_LEVEL= CS | UR | RR | "RR KEEP UPDATE
LOCKS" | RS | "RS KEEP UPDATE LOCKS"
-
Here are the valid values for this option.
DB2 determines the default isolation level.
Isolation Levels for DB2 Under z/OS
Value |
Isolation Level |
CS |
Cursor stability |
UR |
Uncommitted read |
RR |
Repeatable read |
RR KEEP UPDATE LOCKS* |
Repeatable read keep update locks |
RS |
Read stability |
RS KEEP UPDATE LOCKS* |
Read stability keep update
locks |
*
When specifying a value that consists of multiple words,
enclose the entire string in quotation marks. |
-
UPDATE_ISOLATION_LEVEL= CS | UR | RR | "RR KEEP UPDATE
LOCKS" | RS | "RS KEEP UPDATE LOCKS"
-
The valid values for this option are described
in the preceding table. The default isolation level is determined by DB2.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.