A database lock is a mechanism utilized by Db2 to govern the access to a database object amongst different transactions. This article describes the locking mechanism for Db2 (for LUW).
Steve Thomas of CA Technologies presents a great introduction into the world of locks, latches, claims and drains. A must see for all developers working wit Db2 for z/OS as well as all DBAs wanting to refresh their knowledge.
There are a number of fairly important tuning tips that do not get much attention. In this article I will describe one of my favorites – Hash Joins.
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.