IDUG DB2 Tech Conference EMEA 2011
    Clarion Congress Hotel, Prague, Czech Republic
    14 - 18 November, 2011

    View Printable Version

    Optimising DB2 for z/OS System Performance Using DB2 Statistics Trace

    Session Number: 1881
    Track: Full Day Seminars
    Session Type: Podium Presentation
    Primary Presenter: John Campbell [IBM DB2 for z/OS Development]
    Room(s)/
    Time(s):

    Tycho => Fri, Nov 18, 2011 (09:00 AM - 05:00 PM)

    Speaker Bio: John is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database and applications design. He specialises in design for high performance and data sharing. He is one of IBM's foremost authorities for implementing high end database / transaction processing applications.
    Audience experience level: Intermediate, Advanced
    Presentation Category: Managing Performance
    Presentation Platform: DB2 for z/OS
    Audiences this presentation will apply to: Database Administrators, Systems Programmers
    Technical areas this presentation will apply to: Database Performance (DB2 for z/OS)
    Objective 1: Introduce and discuss the key areas of system performance: system address space CPU, EDM pools, dataset activity, logging, lock/latch contention, DBM1 virtual and real storage, buffer pool and GBP, DIST (DDF) activity etc.
    Objective 2: Understand the key performance indicators to be monitored
    Objective 3: Provide rules-of-thumb to be applied
    Objective 4: Understand how to investigate with more detailed tracing and analysis
    Objective 5: Provide tuning advice for common problems

    Abstract:  This one day seminar will focus on the key areas of system performance - dataset activity, buffer pool and GBP, lock/latch contention, system address space CPU, EDM pool, RID pool, DBM1 virtual and real storage etc. Information will be provided on key performance indicators to be monitored and the rules of thumb to be applied in each area. Information will be provided on what more detailed tracing and analysis is required. Tuning advice will be provided for common problems.

    For questions or concerns about your event registration, please contact support@idug.org


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact