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.

Download Presentations

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

Meeting Details

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

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
email 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.

Directions to to The Baxter Hood Center:

The Baxter Hood Center
452 S. Anderson Road
Rock Hill, SC 29730

Less than 2 miles from I-77 & Dave Lyle Blvd intersection (south side of Charlotte).

Robert Catterall's Biography

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.

Title: "DB2 for z/OS Data Warehouse Performance"

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's Biography

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.

Title: "Physical Database Design for the 21st Century"

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. Sander's Biography

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.

Title: "Best Practices for Deploying DB2 9.5 for Linux, UNIX, and Windows on Symmetrix DMX"

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's Biography

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

Title: "Explain Fundamentals"

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

Steve Overstreet's Biography

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.

Title: "Get the Most out of SDSNSAMP - With the Least Amount of Trouble"

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's Biography

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.

Title: "Ooooooey GUI! (Or, Take a Break From the Greenscreen)"

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

IDUG 2009 North America RUG Discount Information

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.