Locking in the DB2 under z/OS Interface

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 LIBNAME Statement Syntax 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 LOCKS1
Repeatable read keep update locks
RS
Read stability
RS KEEP UPDATE LOCKS1
Read stability keep update locks
1When 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 © SAS Institute Inc. All rights reserved.