Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.
The db2 logging process is an old strong process. You must take care of it because if all your active log data sets are not reusable because they are full, your db2 stops until it can offload them in archive logs. The performance of your recovery process is also strongly linked to your active log
DB2 12 introduces a number of new SQL and SQL PL related enhancements. In the first of this two-part article, we will discuss the new DELETE syntax that enables customers to delete large numbers of rows from a table without severely impacting the system.
A significant step forward in this regard is the introduction in DB2 12 for z/OS of a major new feature called “PBR RPN” which transforms the management of range-partitioned table spaces. But what really is PBR RPN and why should it matter to me?
DB2 12 is classified as an in-memory data base by Gartner. It is not just a simple in-memory data base but a very smart one. In this paper, we explain one of the most innovative in memory optimizations in DB2 12.