Hot off the press: DB2 12 for z Optimizer redbook
ChristineGaulGaensslen 110000AC9T Visits (7750)
HOT OFF THE PRESS and available for download now: Db2
DB2 12 for z/OS has targeted performance to increase the success of new application deployments and integration of analytics.
This paper describes the enhancements delivered specifically by the query processing engine of DB2. This engine is generally called the optimizer or the Relational Data Services (RDS) components, which encompasses the query transformation, access path selection, run time, and parallelism.
DB2 12 for z/OS also delivers improvements targeted at OLTP applications, which are the realm of the Data Manager, Index Manager, and Buffer Manager components (to name a few), and are not identified here.
The IBM® Redpaper™ contains the following sections: