DB2 Five key areas to improve Performance

In DB2, the role of Senior software developers is performance tuning. The real point is where you need to focus. I have discussed key areas where you need to focus.

Advantages of tuning

  1. Good performance reduces CPU time utilisation
  2. application running cost you can reduce.

Performance tuning tips in DB2

Right Access Path…

Here, how to find right access path.

  1. Access path determined by during bind time
  2. Access path at execution time
  3. Read more tuning ideas if you want to know more here

Statistics update…

  • DB2 checks catalog statics updated or not. So that it determines right access path

Index…

  • DB2 checks clustering index defined on any tables, which access so frequently

SQL query written in simple way…

  • SQL query should be as simple as possible
  • Avoid GROUP BY and ORDER BY
  • Avoid unused columns

Avoid Sorts in SQL query…

  • Use Indexes correctly, instead Sorting methods..like GROUP BY or ORDER BY etc

Also read

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.