Articles & Content


A05 - Performance Monitoring and Tuning of Dynamic SQL

Topic: 2013 NA

Subtopic: DB2 for z/OS

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.