Articles & Content
Topic: 2009 NA
Subtopic: DB2 for z/OS
DATE: 2009-5-14 (01:30 PM - 02:30 PM)
SPEAKERS: Thanikachalam 'Billy' Sundarrajan (Fifth Third Bank)
As web applications continue to grow, tuning dynamic SQL continues to be one of the significant challenges for a DB2 DBA. DB2 v8 introduces a significant number of enhancements to surmount these challenges. This presentation will provide an insight into the new features that help manage SQL performance. Key aspects include: EXPLAIN SQL Statement cache,ZPARMS for controlling accounting record/SMF101 records accumulation, setting client registers, EXCSQLSET commands etc. The presentation also provides information on how to exploit the client registers to effectively group accounting and performance information for distributed applications.
EXP. LEVEL: Intermediate,Advanced
Dynamic SQL - Performance tuning challenges
Version 8 Enhancements - Intercepting Dynamic SQL cache, Setting Session Variables/Client Identifiers
Version 8 Enhancements - SMF 101 rollup
DB2 9 Enhancements - Resource Limit enhancements, REOPT(AUTO)
DB2 9 Enhancements - Trusted Context
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.