Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2010

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


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.

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.