DELAWARE VALLEY DB2 USERS GROUP
_____________________________________________________________________________
MEETING DATE: Friday, March 26, 2010
LOCATION: IBM,
STARTING TIME: 9:00 AM
REGISTRATION
and BREAKFAST: 8:30 AM - 9:00 AM
COST: Free
_____________________________________________________________________________
AGENDA
09:00 - 09:15 Opening
Remarks
Joe
Carola, Chairperson DVDUG
_____________________________________________________________________________
09:15 -10:30 DB2 10 for z/OS
Roger Miller, Lead DB2 for z/OS Strategist, IBM Corp
_____________________________________________________________________________
10:30 - 10:45 BREAK
_____________________________________________________________________________
10:45 - 12:00 DB2 for z/OS
Selected Performance Topics
Roger Miller, Lead DB2 for z/OS Strategist, IBM Corp
_____________________________________________________________________________
12:00 - 01:00 LUNCH: Sponsored by IBM
_____________________________________________________________________________
01:00 - 02:15 DB2 for Linux,
UNIX and Windows Query Tuning Best Practices
John Hornibrook, IBM Canada Lab
_____________________________________________________________________________
02:15 02:30 BREAK
_____________________________________________________________________________
02:30 03:045 DB2 9.7 for Linux,
UNIX and Windows Optimizer Update
John
Hornibrook, IBM Canada Lab
_____________________________________________________________________________
The DELAWARE VALLEY DB2 USERS GROUP reserves the right to
change the agenda without notice.
Visit
our Web Site for the latest information @ www.dvdug.org
Mark your calendars for the next
meeting: June, 2010 (tentative)
Casual Dress
Message from the chair:
IBM will sponsor our Spring 2010 meeting, and will present updates on the latest releases DB2 V9 for z/OS and DB2 for Linux, UNIX, and Windows. We are once again fortunate to have great support being provided by IBM. Due to this strong support, we are able to offer this meeting free of charge. Be sure to take special note that this meeting will be held at IBMs facilities in West Chester, PA.
We are proud and happy to have Roger Miller back as our keynote speaker. Roger, from the Silicone Valley Labs, has more than a quarter century of experience working on DB2 development, product design and strategy - and will be sharing his excitement with the new features and capabilities coming with DB2 10 for z/OS. His presentations are always very informative and he adds a lot of real world Customer experience stories that he can share with us. The meetings where Roger is presenting are always very well attended so be sure to register early to reserve your seat.
Our DB2 UDB speaker, John Hornibrook, from the IBM UDB Labs in
Please join us for a very informative day and get a great
start on the weekend with an early Friday dismissal to enjoy what will
hopefully be great early Spring weather!
REMINDER: PRE-REGISTRATION IS HIGHLY ENCOURAGED!! In an effort to better plan for handouts and
food, we are urging the membership to please try to pre-register for our
sessions.
Joe Carola
BOARD OF DIRECTORS
Chairperson Joe
Carola (610) 219-8328 joseph.carola@siemens.com
Vice-Chair Rachel
Murawski (570) 200-1558 rachel.murawski@bcnepa.com
Program Anne
Stout (609) 520-5240 anne.stout@dowjones.com
Newsletter Tom
Orner (215) 238-6872 orner-tom@aramark.com
Joseph
Mako (610) 359-6766 joseph.mako@siemens.com
Membership Stan
Katinsky skatinsky@comcast.net
Arrangements Mark Weichman (856)346-5752 mcweichman@comcast.net
Secretary Mike
Piontkowski (610) 326-9529 michael_piontkowksi@compuserve.com
Treasurer Bill
Saunders (215) 625-5892 bill.saunders@attglobal.net
Website Joseph Mako (610) 359-6766 joseph.mako@siemens.com
IBM Liaison: Linda Snow (610) 578-2367 lindasnow@us.ibm.com
Howie
Hirsch (732)-926-2362 hshirsch@us.ibm.com
The Delaware Valley DB2 Users Group wants
you! Think about joining our Board.
Were looking for new blood. All positions are in need of your assistance. Please let us know if you would like help out by contacting any of the Board members.
First Morning Presentation
DB2 10 for z/OS
Roger Miller, IBM Corp.
DB2 10 for
z/OS provides the best reduction in CPU for transactions and batch for 22
years, since V2R1. We expect most customers to reduce CPU times between 5% and
10% initially, with opportunity for more.
Applications which can take advantage of additional benefits, such as
hash access, can have larger CPU and memory reductions. Scalability is the
second major benefit, with the ability to run five to ten times as many threads
in a single subsystem by moving 80% to 90% of the virtual storage above the
bar. Schema evolution or data definition on demand enhancements improves
availability. SQL, pureXML, and web services extend usability and application
portability for this platform.
Productivity
improvements for application developers and for database administrators are
very important as data grows in scale and complexity. Warehousing continues to evolve, with key
trends matching System z and DB2 for z/OS strengths of performance,
scalability, reliability, stability, availability, resilience, and
security. DB2 10 has a lot for
everyone. Your organization needs to lower operating costs thru CPU cycle
reductions while still building a strong foundation for SOA and XML
initiatives. Database Administrators (DBAs) will find improved database
performance, scalability, and availability. Memory management is dramatically
reduced, so growth is much simpler. DBAs also get more flexible security to
help with regulatory compliance. A wide range of enhancements improve ERP
application and data warehouse functionality and performance. Large object
(LOB) performance and flexibility are improved. Many DBA tasks are simplified.
Speaker:
Roger Miller has worked more than a quarter
century on DB2 development, product design and strategy. He often helps
customers to use the product, answers many questions and presents frequently to
user groups. He was a customer for ten years before working on many facets of
DB2, ranging from overall design issues to SQL, languages, install, security,
audit, standards, performance, concurrency, and availability. We sometimes call
him a jack of all DB2 trades and a master of several. His favorite response is,
It depends.
Second
Morning Presentation
DB2 for z/OS Selected Performance
Topics
Roger Miller, IBM Corp.
This
talk presents some of the latest challenges and achievements for DB2
performance, noting some recent measurements and what can be achieved with the
latest software and the latest hardware.
The discussion will be centered on what you can do to help improve
performance in your shop, particularly on the items that can help in DB2 10. Objectives: The first part of this presentation is system
performance, looking at the subsystem and overall system, covering the aspects
of objectives, metrics, managing, resources, tuning and System z. The second
part is application performance, with sections for tuning, SQL, languages,
utilities, environment, database design, and application design. We'll finish
with pointers to many other sources and resources, providing a detailed roadmap
of where to look for more information.
ftp://ftp.software.ibm.com/software/data/db2/zos/presentations/performance/
selected-performance-topics-idug-2009-miller.pdf
Afternoon Presentation 1
DB2 for Linux, UNIX and Windows Query
Tuning Best Practices
John Hornibrook, IBM Toronto Lab
Query
performance is not a one-time consideration. It should be considered throughout
the design, development, and production phases of the application development
life cycle. SQL is a very flexible language, which means that there are many
ways to get the same correct result.
This flexibility also means that some queries are better than others in
taking advantage of the DB2 data server optimizer's strengths.
This presentation covers the best practices for writing and tuning queries to
best leverage the DB2 data server's strengths. It will provide guidance for
writing efficient SQL statements as well as configuring DB2 to ensure the
optimizer is running at peak performance.
It will also provide tips on using the explain facility to monitor and react
to access plan problems.
Speaker:
John Hornibrook is a senior technical staff
member and development manager for DB2 for Linux, UNIX and Windows query optimization,
which includes statistics collection, the explain facility, and the design
advisor. He has been a DB2 developer for 19 years, focusing on the SQL compiler
and relational data services components.
Afternoon Presentation 2
DB2 9.7 for Linux, UNIX and Windows Optimizer Update
A number of changes
were made to the DB2 data server's query optimizer in V9.7 and V9.7 FP1 to
improve access plan selection, access plan stability and to support new
functionality such as partitioned indexes.
The explain facility was also extended to support explaining captured
access sections and to report the actual number of rows processed by each
access plan operator at query execution time. This presentation will provide an
overview of all significant changes made to the query optimizer and its
associated components in DB2 9.7.
Registration is FREE...
simply send an email to dvdug@dvdug.org with "Registration 3/26" as
the Subject and include your Name and Company in the body of the email. That's all there is to it! We need you to register so we can get a count
of how many will be attending for seating and food so please try to register
before 3/19/2010 if you plan to attend.
Advance registration is strongly
encouraged. Please note that no
telephone registrations or requests for confirmation will be honored.
IBM West
Constitution Room, on the Lower Level
Address:
IBM West Chester
1475 Phoenixville Pike
(610) 578-2475
Site Policies:
Parking
Parking is in
the front of the building and is free;
Directions:
Follow PA Turnpike West to Exit 24 (
Take Route 202 South (
Take Business Route 30 (Frazer/Exton) and turn left at the light onto Rt. 30
East.
At the second light, (Home Depot is on your right) turn right onto Phoenixville
Pike.
Follow Phoenixville Pike around Home Depot, past
IBM (1475) will be on your left. Park in front of the building.
Follow I-95 South to I-476 North.
Follow I-476 North to I-76 West (toward
Follow I-76 West to Route 202 South (
Follow 202 South to the Route 30 exit.
Take Business Route 30 (Frazer/Exton) and turn left at the light onto Rt. 30
East.
At the second light, (Home Depot is on your right) turn right onto Phoenixville
Pike.
Follow Phoenixville Pike around Home Depot, past
IBM (1475) will be on your left. Park in front of the building.
From
Follow 202 North to Route 30 (Frazer exit).
*Note: Do not take the Route 100 & 30 Exit to Exton. The Route 30 Frazer
exit is further north on 202.
At the light at the end of the ramp, turn right. Go to the next light at
Phoenixville Pike (beside Home Depot) and turn right.
Go around Home Depot, past
Turn left into IBM (1475 Phoenixville Pike).
Park in front of the building. .
Exit Turnpike to Rt. 100 South.
Route 100 South (six miles) to left onto Route 30 East.
Take Route 30 East 4 miles to Phoenixville Pike.
Turn right onto Phoenixville Pike.
Follow Phoenixville Pike around Home Depot, past
IBM (1475) will be on your left. Park in front of the building. .