As mandated in our by-laws, annual elections will be held at
this meeting. Anyone interested in an office please notify
us prior to the start of this meeting to be added to the
Intro to SQL Performance Tools
DB2 for i SQL
performance is a big topic and can't be covered in a short
amount of time! But this session will provide a valuable
overview of three major areas.
• The first is the process of query optimization including the
DB2 for i approach, critical inputs, sources of metadata, the
outputs of query optimization, and the tools that provide
feedback on the optimizer's choices.
• The second area is indexing strategy and addresses the two
types of SQL indexes, how they work, when and what kind of index
to create, and some advanced indexing options.
• The third area covers the system level tools that can be used
to monitor and tune SQL activity including the SQL plan cache
and SQL catalogs.
Jim Denton is a senior consultant in the Lab Services DB2 for i
team where his responsibilities include both customized skills
transfer and hands on consulting. Jim specializes in SQL
performance, data-centric programming, and database
modernization. Jim started his IBM career in 1981 as an S/38
operating system programmer. Before joining the consulting team,
his key assignments included ten years as a systems performance
specialist, five years as the lead “JDE on i” performance
analyst, three years as a consultant at the IBM Benchmark and
Briefing Center in Montpellier France, and a total of eleven
years as an operating system developer, including five years
designing and implementing enhancements to DB2 for i.
President Dawn Dawson, The Moore Company (401) 315-6351 email@example.com
Vice President Chip DiFolco, Callico (774) 227-7373 firstname.lastname@example.org
Secretary Rasa Pizzi, Franklin Sports, Inc. (781) 573-2443,
(508) 944-1545 email@example.com
Treasurer Eileen Newell, FGX International (401) 719-2337
IBM Liaison Rick Cowles, IBM (781) 895-4714 firstname.lastname@example.org
Webmaster Jerry Perreault (401) 949-2613 email@example.com
NE Conference Liaison Chip DiFolco, Callico (774) 227-7373
firstname.lastname@example.orgMessage from the President
Message from the President
It was great
to have Rob Bestgen from IBM at our last meeting to share SQL
Writing Tips & Techniques with us. I know I learned quite a bit
from this presentation like how you have to change your mindset
with regards to Native Record Level Access vs. with SQL and how
you can combine Multiple SQL Statements and create either a
Simplified or Single SQL Request and the Create or Replace
statement. He shared some very helpful hints for all of us to
use. Thanks Rob for a great presentation!!!
Joining us on June 21st will be another IBM’er – Jim Denton. He
will be presenting ‘Intro to SQL Performance Tools and Methods’.
His topic will focus on three main areas: Query Optimization,
Indexing Strategy and System Level Tools. I believe this will be
a great follow up to Rob’s session. As a reminder, this is the
last meeting until September. If you have any topic or topics
you would like us to focus on next year, please let us know –
whether you plan to attend or not.
Chip DiFolco, Vice President NEMUG
If you are not on our e-mail list, go to the web site at
www.nemug.com and click on the "Subscribe" button to be added to
to the following New and Renewing Member Companies
Franklin Sports, Inc.
|The Moore Company
Thank you for your support of NEMUG!
If your company has not registered yet, go to the website to
download the annual invoice for membership (on left side of the
home page). Bring a check (payable to NEMUG) and the form with
you to get the member prices at the meeting.
(Schedule is subject to change)
June 21 — What's new in DB2
for I, Jim Denton (IBM)