IDUG Preview Session featuring Robert Catterall, David Simpson and Roger Sanders
SIRDUG Meeting February 20th, 2009
SIRDUG is very pleased to announce that the first 2009 SIRDUG meeting
on February 20th, will feature Robert Catterall of Catterall Consulting.
Robert Catterall will give us a preview of his 2009 North American IDUG
conference presentation. If you concerned about data warehousing on DB2 for z/OS,
you don't want to miss this one.
David Simpson of Themis, will present "Physical Database Design for the 21st
Century"
Robert Catterall and David Simpson are both winners of multiple
IDUG Best Speaker awards, which qualified them for the IDUG Speaker Hall of Fame.
Roger Sanders is now a consulting Systems Engineer with EMC and will be
presenting "Best Practices for Deploying DB2 9.5 for Linux, UNIX, and
Windows on Symmetrix DMX". He is a well-known author of
over sixteen DB2 books.
Sally Mir, Steve Overstreet and Paul Turpin will also be presenting their IDUG NA 2009
presentations.
This year's IDUG North America Conference will be in Denver, Colorado, on
May 11th through 15th. If you are not able to attend this year's IDUG
North America Conference, this is your opportunity to catch a piece of the action.
To download Roger Sanders' "Best Practices for Deploying DB2 9.5 for Linux, UNIX, and Windows on Symmetrix DMX" (1.40 MB)
click here
To download Robert Catterall's "DB2 for z/OS Data Warehouse Performance" (3.9 MB)
click here
WHEN? Friday, February 20, 2009
WHERE? The Baxter Hood Center (Rock Hill, SC) See directions below
COST? $30 cash or check, in advance or at the door.
We do not accept credit cards. We are working on a way to accept
Paypal and credit cards, so stay tuned for upcoming announcements.
Tentative Meeting Agenda
8:00 - 8:50 - Registration - Coffee, Danish, and Networking
8:50 - 9:00 - SIRDUG announcements and speaker introductions
9:00 - 10:15 - Robert Catterall - "DB2 for z/OS Data Warehouse Performance"
10:15 - 10:40 - Mid-Morning Break
10:40 - 11:50 - David Simpson "Physical Database Design for the 21st Century"
11:50 - 12:50 - Lunch
12:55 - 2:00 - Parallel sessions 2 (Sally Mir / Roger Sanders)
2:00 - 2:20 - Mid-Afternoon Break
2:20 - 3:25 - Parallel sessions 3 (Steve Overstreet / Paul Turpin)
3:30 - 3:45 - Networking, Adjourn
We are still working on the exact agenda, so what you see may change
a bit.
To pre-register please use our new online registration form at:
meeting registration form
or
email registration@sirdug.org and give us your name and company. If
you are not already on our distribution list and wish to be, include
your email address and phone number.
If you do not wish to continue receiving these occasional notices, please indicate that in
your registration email.
Pre-registration must be completed by Midnight, Friday, February 13th.
Please feel free to invite others from your company (just make sure
they pre-register as well). If you know others in your company who
are interested in attending future SIRDUG events, please encourage
them to become members of our distribution list (we just need their
names, email addresses and phone numbers).
Registration Note
SIRDUG will be calling or emailing a confirmation for each person who
pre-registers by the deadline. If you have pre-registered and have not
received a confirmation by the day after the deadline, please notify
us as your registration may not have been received.
If you have not pre-registered by the deadline, you may pre-register
after the deadline or register at the door, but the availability of
presentation handouts and lunch can not be guaranteed and
confirmations will not be sent.
The Baxter Hood Center
452 S. Anderson Road
Rock Hill, SC 29730
803-981-7100
Less than 2 miles from I-77 & Dave Lyle Blvd intersection
(south side of Charlotte).
Robert Catterall is President of Catterall Consulting, a provider of data-centric
consulting and training services. Robert started his IT career with IBM in 1982. In 1990
he joined the DB2 National Technical Support team at the IBM Dallas Systems Center.
In 2000, Robert joined CheckFree Corporation, where he played a leading role in database
technology strategy and planning. He launched Catterall Consulting in 2007. Robert is a
past President of the International DB2 Users Group and a member of the IDUG Speakers Hall
of Fame. He has been the author of the "DB2 DBA" column in DB2 Magazine since 2000.
DB2 for z/OS Data Warehouse Performance
When DB2 debuted on IBM's mainframe server line in 1983,
it was positioned as a technologically innovative base for
decision support applications. Over the years, DB2's OLTP
performance improved dramatically, and run-the-business
applications built on DB2 proliferated. The past couple of
years has seen a resurgence in data warehouse activity on
the DB2 for z/OS platform, coinciding with the delivery of
modern BI-benefitting features such as materialized query
tables, star join, recursive SQL, 64-bit addressing, and
zIIP engine exploitation. This session will describe the
strengths of DB2 for z/OS as a foundation for data warehousing,
compare performance management in DB2 data warehouse versus
OLTP environments, and provide recomemndations for system-
and statement-level performance tuning for DB2-based BI
applications.
Bullet Points:
1. The technology that is fueling the renewed popularity of DB2 for z/OS as a data-serving foundation for data warehouse applications.
2. Two different DB2 performance management perspectives: OLTP versus data warehouse.
3. System-level DB2 data warehouse performance optimization.
4. Logical and physical database design for a mainframe DB2-based data warehouse.
5. SQL statement performance analysis and tuning in a DB2 for z/OS business intelligence environment.
Presentation Category: Data Warehousing and Business Intelligence
Presentation Platform: DB2 for z/OS
David Simpson is currently a Senior Technical Advisor at Themis
Inc. He teaches courses on SQL, Application Programming, DB2
Administration as well as performance and tuning. He has
supported transactional systems that use DB2 for z/OS databases
in excess of 10 terabytes. David has worked with DB2 for 14 years
as an application programmer, DBA and technical instructor.
David is a certified DB2 DBA on both z/OS and LUW. David was
voted Best User Speaker and Best Overall Speaker at IDUG North
America 2006. He was also voted Best User Speaker at IDUG Europe
2006.
DB2 Versions 8 and 9 introduced some new physical
design concepts that may have significant impacts
on the way objects should be defined. This
presentation explores these new features and
examines how they should be used going forward to
enable the best possible performance.
Bullet Points:
1. Be familiar with the tablespace choices in DB2 9.
2. Understand the effects of index compression.
3. Be able to design and implement indexes that take advantage of new features.
4. Be familiar with the statistics that are available, but not collected by default.
5. Identify the physical design features that enable high performance.
Presentation Category: Implementing new DB2 releases and features
Presentation Platform: DB2 for z/OS
Roger E. Sanders is a Consultant Corporate Systems Engineer with EMC. He has been designing
and developing databases & database applications for more than 20 years and has been
working with DB2 Universal Database since it was first introduced with OS/2. He has
written articles for IDUG Solutions Journal and Certification Magazine, presented at
several IDUG and RUG conferences, writes a regular column (Distributed DBA) for DB2 Magazine,
and is the author of 16 books on DB2 for Linux, UNIX, and Windows.
To achieve optimum performance, many factors must be taken into
consideration when deploying a database on an EMC Symmetrix.
This presentation is designed to provide basic guidelines for
deploying DB2 DB2 9.5 for Linux, UNIX, and Windows (DB2 LUW)
databases in a SAN environment and to offer recommendations for
laying out DB2 LUW databases on Symmetrix DMX arrays.LBAC rules
and rule exemptions will be covered as well.
Bullet Points:
1. Designing for Optimum DB2 database performance
2. Recommendations for deploying DB2 databases on Symmetrix DMX
3. DB2's storage-related registry variables and configuration parameters
4. Table space characteristics that affect performance
5. Recommendations for deploying partitioned databases on Symmetrix DMX
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Paul Turpin is a database architect and database administrator
at Wachovia in Charlotte, NC. He specializes in DB2 for LUW on
large systems. He enjoys exploring new features and
functionality in DB2. He has spoken at IDUG North America, IDUG
Europe, SHARE, IBM’s Information on Demand conference, and
several RUGs. Paul currently serves as co-chair on the IDUG
North America Conference Planning Committee.
He holds the following DB2 certifications: IBM Certified Advanced Database Administrator -
DB2 9 for Linux UNIX and Windows; IBM Certified Applications Developer DB2 UDB V8.1 Family;
IBM Certified Advanced Technical Expert DB2 - DRDA & Clusters; IBM Certified Solution
Designer - DB2 BI V8; IBM Certified Database Administrator - DB2 9 DBA for z/OS
This presentation will go into the use of the command line explain
tools. While there are good reasons for using the Visual Explain
tools, there are still opportunities for using the command line
explain tools. The presentation will introduce the attendee to
interpreting the output of the explain. Some of the red flags to
look for in an explain will be covered.
Bullet Points:
1. Explanation of the dynexpln, db2expln and db2exfmt tools.
2. Executing the command-line explain, including various options.
3. Basics of reading the explain output.
4. Query performance red flags to look for in explain output.
5. More advanced interpretation of the explain output.
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
In mainframe data processing since 1984, when I was trained in
Application programming
I became a DBA in 1986, and two jobs and several years later
became a SYSPROG (1999).
I began my career supporting IMS and now I support DB2 -- except
when I'm oncall (which is more frequently than I like!) when I
provide problem-solving for both IMS and DB2 issues.
My college degree is in philosophy, and has been no help at all
in my SYSPROG career. Apart from two college Assembler
courses (many years ago!) all of my technical training has come
from IBM seminars and classes and as many User Groups as I am
allowed to attend.
SDSNSAMP is a hodgepodge of DB2 bits and pieces designed to
assist your shop to get started with DB2. Some pieces are
essential to your shop; others are useful hold-overs from DB2's
beginnings. Some pieces are useful applications for DBA's,
Systems Programmers, and application programmers needing bridges
to DB2 for z/OS.
Not many SYSPROG's care to be the owners of DB2 application
objects, CLISTS, and programs they do not use or intend to use.
A combination of common sense, certain DBA skills, and team work
gives considerable value from the 'free' resources found in
SDSNSAMP.
1. Go beyond the installation CLIST when migrating from one
release of DB2 to the next. 2. The Old Standby's: DSNTIAUL,
DSNTIAD, DSNTEP2 (and 4!), DB2I and SPUFI. 3. Some critical
pieces for multi-platform interfaces. 4. RLF and many Stored
Procedures, old and new. Do you need to install them? Who will
use them? How do you keep track of them? And what about
DB2 'Coexistence?'
Bullet Points:
1. A list of applications and tools found in SDSNSAMP
2. A list of skeletons used by the Installation CLIST
3. Useful Tools for the maintaining the DB2 subsystem
4. Keeping the metadata tools in sync with the user community and their DB2 interfaces.
5. Migrating the SDSNSAMP applications to your shop's next release of DB2
Presentation Category: Implementing new DB2 releases and features
Presentation Platform: DB2 for z/OS
Sally Mir is a DB2 DBA and Assistant Vice President at Wachovia
Bank in Winston-Salem, North Carolina. She has worked with DB2
since 1990, beginning as an application developer and then as a
DBA. When she is not performing her DBA duties at work,
occasionally she can be seen performing on local opera, oratorio
and concert stages.
DBAs who work with DB2 for z/OS are generally very comfortable
with and know their way around VTAM- and/or ISPF-based tools.
'Greenscreen' applications such as Omegamon and DB2PM/DB2PE are
essential for monitoring performance and producing batch
performance reports. EXPLAIN is an important tool for analyzing
and predicting access paths for SQL. But wait! -- There is a new
generation of desktop-based tools that can provide all of that
information and more in multi-colored splendor! This presentation
will discuss Wachovia's experience with implementing and using
IBM's GUI tools in our environment, focusing mostly on the
DB2PE Client. Once you see this, you will never go monochromatic
again! (Well, almost never.)
Bullet Points:
1. IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS -- What kind of name is that? - A bit about the pedigree of IBM's performance monitor and why it has "multiple personalities". When should I use which interface?
2. Why should I bother to install and use the DB2 PE Client? What's in it for me? - Let's walk through the many ways it can make the DBA's life a little easier. (And more colorful.)
3. What can the DB2PE Client show me about DB2Connect? - Some things you can only get from the client!
4. Never query the PLAN_TABLE again! Visual Explain is the answer! - Whether launched from within the DB2PE client, or run on its own, this is the future of EXPLAIN!
5. This is great! What other GUI tools are there out there for me?
Presentation Category: Implementing new DB2 releases and features
Presentation Platform: DB2 for z/OS
You can download the IDUG 2009 North America Conference RUG coupon by
Clicking here
SIRDUG Home Page
Last Update: February 16, 2009
Copyright © 2009 SIRDUG Inc. All rights reserved.