SAP ABAP Data Element DB2WP4RRU (UPDATE lock for repeatable read or read stability)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Data Element	DB2WP4RRU
Short Description	UPDATE lock for repeatable read or read stability

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2CHAR03L
Data Type	CHAR	Character String
Length	3
Decimal Places	0
Output Length	3
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	0
Medium	15	RR UPDATE Lock
Long	21	UPDATE lock for RR/RS
Heading	0

Documentation

Definition

Indicates whether to use the UPDATE (U) lock when using repeatable read (RR) or read stability (RS) isolation level to access a table.

Yes The U lock was used for repeatable read or read stability.

No The S lock was used for repeatable read or read stability.

Installation parameter: USE U LOCK FOR RR on panel DSNTIPI

ZPARM name: RRULOCK in DSN6SPRM

History

Last changed by/on	SAP	20070813
SAP Release Created in