SAS/ACCESS Interface to DB2 Under z/OS

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 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.

Top of Page