Db2 performance steps

[Former Member]

Hello Experts,

I need to do performances tuning of db2 Database in Linux server ..I'm using DB2 version 10.5.

What are the steps i need to consider for that?

[Johan_sapbasis]

Hi,

Like Frank suggested look at the usuals. Also considering the following.

1. Check your Earlywatch report for recommendations

2. Check for your DB statistics

3. Check your SQL statement cache for highest users of CPU/Wait time e.t.c.

Regards,

Johan