<!--
@page { margin: 0.79in }
P { margin-bottom: 0.08in }
-->

1.If application team is contacting you telling the application is running very slow , what all things you will check out ?

2.If you are given with a query,how you tune it?

Regards

Pawan

1.If application team is contacting you telling the application is running very slow , what all things you will check out ?

- Check table reorganization -  When to REORG a table on DB2

- Check if there are good indexes -  http://www.dbatodba.com/Forums/db2/157608501/#449402641

- Bufferpool hit ratio -  Monitoring performance with SQL -Buffer pools

- Memory parameters

2.If you are given with a query,how you tune it?

- Create good indexes - How to check queries that have bad performance

- Check possible improvements to your query(Ex.: Eliminate subselects )

- Check if the applications are using prepared statements

Regards