Meg Bernal, Chris Crone, IBM SVL Lab
DB2 12 trae una serie de nuevas mejoras relacionadas con SQL y SQL PL. Dos de las mejoras relacionadas con SQL fueron solicitadas por muchos clientes, y son las siguientes::
“DELETE por partes” y
la capacidad de “MERGE de dos tablas”.
En esta primera entrega
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.
This article discusses the new enhanced MERGE in DB2 12 from the user perspective.