It seems to be a constant battle to ensure that DB2 applications are running at their optimum efficiency and speed, but what are the factors that affect this efficiency. This presentation looks briefly at those aspects of application coding, development and execution that have a bearing on the overall performance.But what if it’s really not the applications fault? How do you determine, before embarking on lengthy analysis, that the problem really IS one you can fix from a DB2 perspective. We’ll also look at why it is important to build a performance database that easily allows comparisons between “now” and “then”.The performance database can also prove invaluable in determining trends in performance – perhaps even allowing problems to be highlighted and resolved BEFORE they cause major impacts