Articles & Content


A05 - Performance Monitoring and Tuning of Dynamic SQL

Topic: DB2 for z/OS

Subtopic: 2013

It is a real problem to track SQL performance over the life cycle of large Java frame-work based systems. Anixter solved this problem by developing a process to transfer the Dynamic Statement Cache data into a history table. This table contains a reformatted SQL statement and an Explain Report as well as the statics columns for captured statements. Within this presentation, you will get a detailed introduction to the components that are needed to create a Dynamic SQL Cache History process.

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.