Articles & Content

Archives

A02 - DB2 Application Performance - APRTI (Access Path Run Time Investigation)

Topic: DB2 for z/OS

Subtopic: 2013



The DB2 Optimizer is responsible in choosing the best access path to satisfy SQL data manipulation requirements. The review of the explanation of the access path allows for a certain level of performance understanding. But, at SQL execution time, other variables will impact actual application performance. All good access path choices don’t always lead to good run time results. This review will provide various examples of common DB2 application performance scenarios and considerations for evaluating execution time variables. The goal of this presentation is to present possible solutions on database design and SQL coding to reduce the impact of run time variables and improve application performance.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.