Enhanced Monitoring Support in DB2 10 for z/OS

Session Number: 2168
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Mark Rader
Time: Nov 15, 2011 (11:00 AM - 12:00 PM)
Room: Tycho

Speaker Bio: Mark Rader is a Consulting IT Specialist with IBM Advanced Technical Skills (ATS), located in Chicago. He has 27 years of technical experience with IBM, and for the last 22 years has worked primarily with DB2 for MVS, OS/390 and z/OS. Among his specialties are DB2 data sharing, DB2 performance, and DB2 and WLM interaction. He has guided numerous customers in their implementation of DB2 data sharing, and has presented a variety of DB2 topics at user group meetings and customer workshops. He has contributed as an author to redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.
Audience experience level: Select a Value
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Database Administrators, Systems Programmers, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), New Release (DB2 for z/OS)
Objective 1: Understand statement ID and Monitor Class 29 and how they can provide system wide performance statistics
Objective 2: Understand how statement ID supports improved problem determination
Objective 3: Learn how to use profile tables to define sets of users or applications or connectors to DB2 and monitor their use of thread resources
Objective 4: Learn how to manage the number of threads or connections, and idle thread settings, available to a distributed user or application or connector to DB2 for z/OS.
Objective 5: Learn how to distinguish source types of distributed threads and manage their resources.

Abstract:  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.