Sunday, December 31, 2017

Db2 for z/OS: Opportunities for CPU Efficiency When Data Clustering is not a Priority

›
Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clust...
1 comment:
Tuesday, November 21, 2017

Db2 12 SQL Enhancement: Temporal Logical Transactions

›
Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent rele...
Friday, October 27, 2017

Db2 12 for z/OS: Enhanced Lock Avoidance in Data Sharing Environments

›
In the last entry posted to this blog , I described the mechanisms (including PUNC bits and commit log sequence numbers, aka CLSNs) used by ...
Friday, September 29, 2017

Db2 for z/OS: Lock Avoidance

›
Not long ago, I served as part of the teach team for a Db2 12 for z/OS Technology Workshop that IBM offered in a city in the USA. During tha...
15 comments:
Wednesday, August 30, 2017

Db2 12 for z/OS SQL Enhancements: Advanced Triggers

›
In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabili...
2 comments:
Thursday, August 17, 2017

Db2 12 for z/OS SQL Enhancements: a Better MERGE

›
Greetings, and welcome to the third in a series of entries covering my favorite Db2 12 for z/OS SQL enhancements. The first two posts in the...
4 comments:
Friday, July 21, 2017

Db2 12 for z/OS SQL Enhancements: Result Set Pagination

›
In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus ...