Articles & Content

Archives

How and Why of DB2 9 for z/OS SQL Performance Features (E04)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-9 (08:30 - 09:30)
SPEAKERS: Terry Purcell (IBM), Andrei Lurie (IBM)

This presentation will cover the new DB2 9 for z/OS features introduced for improving the application performance.The goal is to highlight how and why you would exploit each of the new DB2 9 features related to application performance. Some of the features that will be covered are: MERGE, SELECT from MERGE/UPDATE/DELETE, OLAP functions, NTERSECT/EXCEPT, Dynamic index ANDing, INSTEAD OF triggers, Global query optimization, Index on expression, APPEND YES option for CREATE/ALTER TABLE, and TRUNCATE.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Highlight SQL function and query performance enhancements in DB2 9.

Provide attendees with an appreciation as to the reason why a feature may be used.

Provide an expectation of the performance of each enhancement.

Target DBAs and application developers.

Encourage greater exploitation of DB2 9 for z/OS.



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.