Cloud Analytics for DB2 Performance Stats

IBM Db2, commonly referred to as just Db2, is a family of data management products from IBM that provide a set of relational database management system (RDBMS) solutions. Db2 is designed to efficiently manage and store large volumes of data, and it has been a prominent player in the database industry for many years.

IBM Db2 provides robust internal statistics collection capabilities that play a crucial role in optimizing database performance and facilitating efficient query execution. The database engine maintains a comprehensive set of internal statistics that capture information about table and index usage, query execution patterns, and resource utilization. Db2's automatic statistics collection feature regularly gathers and updates these metrics, ensuring that the database engine remains current with the evolving characteristics of the data and usage patterns.

To take advantage of IBM Db2 internal statistics, administrators need to create, populate, and maintain a repository. This is a significant undertaking and often times it's overlooked. Furthermore, making sense, and interpreting the stats require an in-depth understanding of DB2 which may be lacking in the organization.

At DB2PRO.COM, we aim to fill this need by working closely with the Db2 administrators, and setup a system that is most suitable and effective for the client.

DB2PRO Appliance

The db2pro Appliance is our free solution offering. This appliance runs on a small VM in VirtualBox and is intended for Db2 Administrators to "kick the tires". However, this is not an enterprise grade solution.

Each appliance is equipped with 4 components:

Collectors

The Collectors are configurable bash scripts that collect performance data from the database servers of your choice.  The Collectors run at different intervals (hourly, daily, weekly) which can be configured based on your requirements.

Transporter

The Transporter is a configurable bash scripts that facilitates the shipment of data packages to the db2pro Appliance.

ETL Engine

The ETL Engine unpacks the data packages and loads them into the db2pro Appliance Repository.

Replicators

The Replicators copy the data with additional transformation or summarization to a secondary repository for analytical purposes.

What can I get out of the db2pro Appliance?

The primary purpose of the DB2PRO Appliance is to collect, process, and store Db2 internal stats in a repository for basic analytics and get familiar with the concept. The repository comes with a number of stored procedures that can produce meaningful data to push to a virtualization solution of your choice. The list below provides some of the typical reports and graphs one can obtain data from the DB2PRO Appliance.