Articles & Content

Archives

DB2 Top 25+ Tuning Tips For Developers (E03/E04)

Topic: 2011 NA

Subtopic: DB2 for z/OS



DATE: 2011-5-3 (03:15 PM - 05:00 PM)
SPEAKERS: Tony Andrews (Themis Inc. )

This two part presentation offer is for developers, database analysts, business analysts, testers, and end users and provides them with the knowledge and tools learn about performance issues associated with SQL development in an IBM DB2 z/OS environment. The audience will:1) Learn what makes queries, programs, and applications perform poorly2) Learn what you can do in your IT shop to improve performance3) Help developers better understand what SQL optimization is about4) Teach developers what to do with table scans5) Teach developers the fundamentals of the DB2 Explain tool6) Teach developers the difference between Stage 1 and Stage 2 predicates7) Teach the developers the difference between indexable and non- indexable predicates8) Learn why filter factors are so important to know9) Learn about the new V9 'Native Store Procedures'10) Learn the top 10 steps to tuning a query or program11) Learn about many of the V8 and V9 features specific to performance12) Learn about the new Visual Expain in OSC and Data Studio

EXP. LEVEL: Advanced

OBJECTIVES:

1) Learn what makes queries, programs, and applications perform poorly

2) Learn what you can do in your IT shop to improve performance

3) Help developers better understand what SQL optimization is about

4) Teach developers the fundamentals of the Explain tool and the new Visual Explain with Data Studio and OSC

5) Learn the top 10 steps to tuning a query or program



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.