Return
-
Title
Are DB2 SELECT statements run with Uncommitted Read (UR)? -
Description
Do the SELECT statements used by the Foglight DB2 cartridge against the monitoring database run with Uncommitted Read (UR)? -
Cause
The SELECT statements used by the DB2 cartridge run using uncommitted read. -
Resolution
Beginning with the 5.7.5.41 and higher releases of the DB2 cartridge the monitoring collections use uncommitted read to avoid locks. This was part of enhancement DB2FOG-46.