Abstracts and Biographies (scroll down)

 

Utilizing Views, RI and Other Stuff for Performance

Tink Tyser

Abstract:

The DB2 optimizer has long been recognized for reliably finding the access path for the best response time for most SQL

statements. With DB2 V8, this has been taken to new heights. Now with ever decreasing hardware costs, programming cost

becomes more and more significant. Codd's original 12 rules for relational data stressed the goal of separating program

logic from specific data implementation. With the advent of OO Programming, and SOA, this becomes even more desirable.

Now with DB2 version 8, that separation can be further realized utilizing views. Views can make programming easier and more

productive, while allowing for the changing of the underlying data organization. This session will cover how to set up Views,

RI and etc. so that DB2 can adjust the access path to the underlying data based on predicate data both at bind time and execution

time. Taking advantage of these new capabilities will make application programmers more productive while enhancing query response time

Bio:

 

 

Top 25+ DB2 SQL Tuning Tips For Developers

Tony Andrews

Abstract:

- Learn what makes queries, programs, and applications perform poorly

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

- Help developers better understand what SQL optimization is about

- Teach developers what to do with table scans

- Teach developers the fundamentals of the DB2 Explain tool

- Teach developers the difference between Stage 1 and Stage 2 predicates

- Learn the top 10 steps to tuning a query or program

Bio:

Tony Andrews has more than 23 years experience in the development of IBM DB2 relational database applications.

Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies.

Tony has written literally thousands of queries and programs during his development years, and has also served as

a DB2 database analyst. His experience has shown that the majorities of performance issues are directly related to

poorly coded programs or improperly coded SQL statements. For the last 10 years, Tony has been splitting his time

between performance and tuning consulting engagements and DB2/SQL training. His main focus is to teach todayÕs developers

the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance.

 

 

Planning Your DB2 for z/OS Migration

Roger Miller

Abstract:

This presentation discusses migrating, primarily to DB2 9, preparing to use the new functions, understanding and

early planning for DB2 10. Process, customer recommendations, and pointers to more information are included.

This session will focus on the tasks of the person who installs DB2. Systems programmers and database administrators

generally perform this task. This session will help you get ready to migrate to the new version and to be ready for the next one.

Whether you are ready to migrate now or are still years away, the planning step should start now, so that you can use

your time more effectively.

The speaker has worked in DB2 development for the past 30 years, and continues working with the team building the install

& migration process.

Objectives Early planning: deciding to migrate, what can be gained

Prerequisite planning

Avoiding incompatibilities

Planning performance and storage

Resources on the web

Bio:

title Ð DB2 for z/OS technical evangelist, strategist, architect, designer, developer, writer, service,

DB2 factotum (from the Latin for does everything or jack of all DB2 trades, master of several).

current projects - Roger is working to roll out DB2 9 for z/OS, to design the next improvements in DB2.

technical accomplishments/education - Roger Miller is a DB2 for z/OS technical evangelist, architect and designer

who worked on many facets of DB2, ranging from overall design issues to SQL, languages, install, security, audit,

standards, performance, concurrency, and availability. He has worked for 30 years on DB2 development, product design

and strategy. He often helps customers to use the product, answers many questions and presents frequently to user groups.

B.S. Mathematics, Stanford University, M.S. Quantitative Methods of Business, U.C.L.A.

fun fact - Roger likes hiking, bicycling, music, reading, Shakespeare, Yosemite and bears. He has learned to like working

out with a personal trainer

 

 

DB2's Distributed Data Facility - In a Nutshell

Bill Arledge

Abstract:

Distributed DB2 distributed workloads have been on the rise for a number of years and may be a major portion of your DB2 workload today.

The DDF (Distributed Data Facility) manages your distributed implementation. In this presentation we'll discuss the DDF in detail,

with an intro to DB2's distributed architecture, DSNZPARMS and other options used to configure the environment, and distributed

application threads and workflows. Finally, we'll discuss how to monitor and manage distributed performance to identify problems at the

subsystem and application level.

Bio:

Bill Arledge is an IT veteran with 33 years experience across a variety of roles, including application

development and database administration. Bill's database experience began in the late 1970's as an IMS DBA

and developer. He began working with DB2 in 1984 as a database specialist at IBM. He worked with DB2

throughout the late eighties, consulting with numerous IBM customers on existing and planned DB2

implementations. Bill joined BMC in 1990 and is currently a technical product manager responsible for

BMC's DB2 data management products. In that capacity he consults extensively with BMC DB2 customers

and works closely with BMC's Research and Development organization to drive product direction.