DB2 lightweight data analysis for DB2 v9.7 and DB2 v10.1 on AIX and LINUX OS

DB2 lightweight data is a collection of different DB2 troubleshooting/monitoring data set that can be enabled to run on DB2 database systems continuously to collect forensic data without impacting production systems. This data set can be stored for weeks to be analyzed/compared when needed. It provides a valuable information to DB2 DBAs and users to proactively monitor their DB2 databases' health, hang/performance issues and apply a preventive action(s) for future problems.

It not only collects DB2 but OS data as well to basic troubleshooting in OS areas like CPU, memory, disk I/O, and network.

 

This article discusses how to analyze the key points in the data collected on regular basis and retrieve the useful information for preventive measures and/or understanding a hang/performance issue.

Read the full article on :http://www.idug.org/p/do/sd/sid=10415&isnew=1&type=0

 

Recent Stories
Microservice Architectures and Performance Models

Improving Performance in Your Data Warehouse – Part 1

Simple DBA Tools for the Db2 DBA