Articles & Content

Archives

DB2 Top 25+ Tuning Tips For Developers (E04)

Topic: DB2 for z/OS

Subtopic: 2011



DATE: 2011-05-03 (04:30 PM - 05:30 PM)
SPEAKERS: Tony Andrews (Themis Inc.)

This presentation offers 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 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 what to do with table scans. 5) Teach developers the fundamentals of the DB2 Explain tool. 6) Teach developers the difference between Stage 1 and Stage 2 predicates. 7) Teach the developers the difference between indexable and non-indexable predicates. 8) Learn why filter factors are so important to know. 9) Learn about the new V9 'Native Store Procedures'. 10) Learn the top 10 steps to tuning a query or program. 11) Learn about many of the V8 and V9 features specific to performance. 12) 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.