IBM Support

What to look in CPU, Memory, I/O system resources while facing DB2 perf issue

Technical Blog Post


Abstract

What to look in CPU, Memory, I/O system resources while facing DB2 perf issue

Body

From a  simple  vmstat  and iostat output the area of possible bottleneck  area could  be  observed.

A wider data  will be needed for deeper  understanding.

 

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

image

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11140670