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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140670