Articles & Content

Archives

Dynamic SQL in z/OS - Advances in DB2 v8/9 (G10)

Topic: DB2 for z/OS

Subtopic: 2009



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

OBJECTIVES:

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.