IBM has introduced the concept of shadow tables in DB2 10.5 Fixpack 4 (also known as the “Cancun Release”) to avoid separate OLTP and OLAP databases and to improve analytic query performance in a single OLTP database without using much tu
According to a recent Gartner report, data growth is the biggest data center hardware infrastructure challenge for large enterprises. As such, reducing storage-related costs remains a top priority for these organizations.
Over the past releases
The BLU Acceleration Technology introduced in DB2 10.5 brings with it a host of new monitoring considerations and metrics. This session will introduce you to the new monitoring capabilities that support BLU Acceleration and through practical examples will show you how you can leverage these in your
This article is a derivative work of the presentation “Sage Advice: 20 Invaluable DB2® LUW Performance Insights from Around the Globe” (IDUG North America 2014), plus enhancements and embellishments, of course!
Optimizing columnar access