Articles & Content

Archives

Managing Dynamic Workloads with BMC's SQL Performance soluton (I14)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: William Arledge (BMC Software)

Dynamic SQL continues to increase in usage in many DB2 shops. This Dynamic SQL is driven from distributed workloads and applications running on the mainframe. Dynamic SQL introduces additional complexities unlike those seen in more traditional static SQL environments. This presentation will show you how BMC's SQL Performance for DB2 solutions helps you effectively manage dynamic SQL performance, from capturing and analyzing SQL performance metrics, and leveraging available tools for managing dynamic SQL performance. Tools like the dynamic statement cache are discussed. Techniques for identifying performance problems across application environments and different release levels are discussed as well.

EXP. LEVEL: Intermediate

OBJECTIVES:

Describe the differences between dynamic and static SQL environments and difference in performance management approaches

Describe a high-level approach to tuning SQL with focus on dynamic SQL using BMC's SQL Performance for DB2 solution.

Discuss dynamic SQL performance metrics to identify the best ones to collect and maintain historically. Use of a performance database is highlighted

Desribe the role the dynamic statement cache plays in dynamic SQL performance management

Introduce a technique for identifying when dynamic SQL performance will change when migrating to new DB2 environments or release levels



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.