Articles & Content

Archives

Tuning Dynamic SQL - Advances with DB2 v8 (C08)

Topic: 2006 NA

Subtopic: DB2 for z/OS



DATE: 2006-05-10 (08:30 AM - 09:40 AM)
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 number of enhancements to surmount this challenge. This presentation will provide an insight into the new features that help manage SQL performance. Key aspects include:EXPLAIN SQL statement cache, control accounting record ZPARMS, EXCSQLSET, setting special client registers etc.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Dynamic SQL - Performance tuning challenges

Version 8 enhancements

EXPLAIN SQL Statement cache

Setting session variables, EXCSQLSET

ZPARMS - ACCUMACC, ACCUMID



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.