Know Your Isolation Levels

Posted By: Craig Mullins Technical Content,

Db2 provides a method to change the way a pgm or SQL statement acquires locks? That way is known as the isolation level and it can be set to specify the locking behavior for a transaction or statement. Standard SQL defines 4 isolation levels that can be set using a SET TRANSACTION ISOLATION LEVEL. 

Read More


IDUG Members have access to premium content – better yet, membership is FREE. Click here to create your member profile today. Questions? Contact us!