The Db2 Portal Blog

News, views, and items of interest on IBM's Db2 database management system and mainframes.

Thursday, May 30, 2013

DB2 Locking, Part 8: LOBs and Locking

›
When a row is read or modified in a table containing LOB columns, the application will obtain a normal transaction lock on the base table. T...
Wednesday, May 22, 2013

DB2 Locking Part 7: Lock Avoidance, Related Issues, and Stuff

›
In today's blog entry, part 7 in our on-going series on DB2 locking, we will take a look at lock avoidance... as well as some other re...
2 comments:
Friday, May 10, 2013

DB2 Locking, Part 6: Claims, Drains, and Partition Independence

›
DB2 augments resource serialization using claims and drains in addition to transaction locking. The claim and drain process enables DB2 to...
2 comments:
Monday, May 06, 2013

DB2 Locking, Part 5: Lock Suspensions, Timeouts, and Deadlocks

›
The longer a lock is held, the greater the potential impact to other applications. When an application requests a lock that is already held...
Friday, April 26, 2013

IDUG NA 2013 in Orlando, Florida

›
Just a short blog post to let everybody know that I will be in Orlando next week for the IDUG DB2 Tech Conference. I'll be delivering an...
1 comment:
‹
›
Home
View web version

About Me

My photo
Craig S. Mullins
Sugar Land, Texas, United States
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He has been named as one of the Top 200 Thought Leaders in Big Data and Analytics by AnalyticsWeek magazine.

Craig has over three decades of experience in all facets of database systems development and has worked with Db2 since V1. You may know Craig from his popular books: Db2 Developer's Guide (covering IBM's mainframe RDBMS)... A Guide to Db2 Performance for Application Developers (how to write efficient Db2 programs) and... Database Administration: The Complete Guide to DBA Practices and Procedures (a guide to heterogenous DBA).
View my complete profile
Powered by Blogger.