by Craig S. Mullins | Sep 1, 2022 | dirty read, ISOLATION, locking
Did you know that Db2 provides a method to change the way a program 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 four isolation levels...
by Craig S. Mullins | Jun 25, 2020 | DB2 12, Function Level, IDAA, locking, RUNSTATS, statistics, stored procedures
This month, June 2020, IBM introduced a new function level, FL507, for Db2 12 for z/OS. This is the first new function level this year, and the first since October 2019. The Function Level process was designed to release Db2 functionality using Continuous Delivery...
by Craig S. Mullins | Jun 25, 2020 | DB2 12, Function Level, IDAA, locking, RUNSTATS, statistics, stored procedures
This month, June 2020, IBM introduced a new function level, FL507, for Db2 12 for z/OS. This is the first new function level this year, and the first since October 2019. The Function Level process was designed to release Db2 functionality using Continuous Delivery...
Recent Comments