Db2 performance steps

[#1]

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?

[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