Db2

 View Only

DB2 monitoring enhancements for BLU Acceleration

By Arun Ramachandran posted Sun December 11, 2022 09:01 AM

  

Overview

BLU Acceleration is a collection of technologies for analytic queries that was introduced in DB2 for Linux, UNIX and Windows (LUW) Version 10.5. BLU Acceleration can provide significant benefits in performance, storage savings, and overall time to value.

Download and try IBM DB2 with BLU Acceleration for Linux, UNIX and Windows.

In this article, learn about the monitoring capabilities that support BLU Acceleration. These capabilities provide insight into the behavior of the database server and assist with tuning and problem determination activities. Example queries walk you through multiple monitoring situations that take advantage of BLU Acceleration. After reading this article, you will be well equipped to perform key monitoring tasks such as:
  • Monitoring buffer pool performance for BLU Acceleration.
  • Monitoring sort memory usage and performance.
  • Monitoring the default workload manager (WLM) configuration that is enabled with BLU Acceleration.
This article assumes prior knowledge of BLU Acceleration and the various technologies that it employs. If you are unfamiliar with BLU Acceleration, start with the best practices paper Optimizing analytic workloads using DB2 10.5 with BLU Acceleration.

Download the full report for more on DB2 monitoring enhancements for BLU Acceleration.
Download the report to get started!

#Db2
0 comments
10 views

Permalink