Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: tuning

SQL Query Tuning Exercise

Published November 16th, 2016 - by

In this exercise we shall look at several different methods of tuning a poorly performing SQL query. The Problem The Original SQL Query The Original Access Path So, where is the problem? Looking at the Access Path chosen by the DB2 Optimizer, all looks well – all tables are either accessed via indexes, or not Continue Reading

Confession of the Month

DB2 z/OS Quick Tuning Tip

Published May 27th, 2011 - by

Anyone who has spent any time tuning DB2 for z/OS applications will know how painful the occasional dataset open/close process can be – there’s even a specific accounting class 3 suspend counter for it. The problem is even worse when large numbers of datasets have to be opened or closed all at once, such as Continue Reading