Articles & Content

Archives

Enhanced Monitoring Support in DB2 10 for z/OS (A05)

Topic: DB2 for z/OS

Subtopic: 2011



Do you want to know what SQL statements were involved in that deadlock? Do you want to manage DDF threads with more granularity than MAXDBAT or CONDBAT? DB2 10 for z/OS adds exciting function in two areas of monitoring DB2 activity. One of these includes problem determination and performance monitoring based on SQL statements, rather than threads. The other is granular monitoring and control of DDF resources. This presentation will introduce both sets of functions, including support for the SQL Statement ID and examples of how to monitor DDF threads with more flexibility than MAXDBAT and CONDBAT provide today.



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.