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?

[db6thomas]

Hi,

as a good starter, please check SAP Note 1851832 DB6: Db2 10.5 Standard Parameter Settings.

If you apply the recommended settings, the system should be in a good overall shape. If tuning is still required, you can use the approach described in this IBM Whitepaper:Tuning and Monitoring Database System Performance.

The basic idea of the approach is to identify the are where your bottleneck is, follwed by a drill down to the relevant area. Instead of the Db2 native tolls, you can use the DBACOCKPIT.

Regards,

Thomas

[Frank-Martin]

Hi,

this is a very general question which is difficult to answer in a forum ...

Thre is some basic information around DB2 configuration and performance tuning in the administration guide ( https://help.sap.com/viewer/db6_admin ).Also I suggest to look a SAP transaction DBACOCKPIT for performance relevant information.

Also compression and a good tablespace layout are very relevant for good performance. You will find some more information about this on our SAP on Db2 SCN site.

If you need more information about Db2 performance tuning or even SQL tuning you may have to vistit a DB2 course.

Regards

Frank

[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