IDUG Preview Session featuring Robert Catterall and Linda Claussen

SIRDUG Meeting March 12th, 2010

SIRDUG is very pleased to announce that the first 2010 SIRDUG meeting on March 12th, will feature Robert Catterall of Catterall Consulting. Robert Catterall will give us a preview of his 2010 North American IDUG conference presentation. If you concerned about data warehousing on DB2 for z/OS, you don't want to miss this one.

Linda Claussen of Themis, will present "DB2 9 for z/OS Migration Planning Survival Guide"

Robert Catterall is a winner of multiple IDUG Best Speaker awards, which qualified him for the IDUG Speaker Hall of Fame.

Jack Bailey, Robert Donaldson, and Paul Turpin will also be presenting their IDUG NA 2010 presentations.

This year's IDUG North America Conference will be in Tampa, Florida, on May 10th through 14th. 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 Robert Catterall' "" click here

Meeting Details

WHEN? Friday, March 12, 2010

WHERE?IBM Harris Blvd facilitySee 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 - Linda Claussen "DB2 9 for z/OS Migration Planning Survival Guide"
11:50 - 12:50 - Lunch
12:55 -  2:00 - Parallel sessions 2 (? / ?)
 2:00 -  2:20 - Mid-Afternoon Break
 2:20 -  3:25 - Parallel sessions 3 (? / ?)
 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, March 5th. 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 IBM Harris Blvd facility:

North bound on I-77 (from the Rock Hill direction):Turn right onto I-85 North and follow next directions.

On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West. Turn Left at 2stop light onto IBM Drive and follow the directions below.

South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp) Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.

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

Linda Claussen's Biography

Title: "DB2 9 for z/OS Migration Survival"

Bullet Points:

Presentation Category: Implementing new DB2 releases and features
Presentation Platform: DB2 for z/OS

Jack Bailey's Biography

Jack Bailey is manager of Commercial Systems Support for BlueCross and BlueShield of South Carolina and is responsible for 24X7 Production Support as well as Test and Development Support for Commercial lines of business. His DB2 background consists of 15 years as Application database analyst and 10 years as a DB2 developer giving him over 25 years of working with DB2.

Title: "Generic Attach on Z/OS (or attachment demistifyed)"

Attachment is simply the creation and maintenance of the communication path between an application and a database management system while the application is active. While this sounds pretty simple, there is really very little information in any IBM manual on attachment.

If your shop only uses one and only one method of attachment then attachment is not an issue with you, however, most z/OS shops consist of new and legacy systems with a mixture of DB2 and IMS making mixed attachment methods a way of life and a problem.

Bullet Points:
1. What are the various attachment methods and how are they used?
2. Why is this a problem? What is different in todays applications expecially when DB2 and legacy IMS applications are mixed in the equation.
3. How can you free yourself from imbedded attachment with a generic approach that solves mixed attachment problems.
4. Do NOT ignore the importance of two-phased or co-ordinated commits! Why is this a disaster waiting to happen?
5. When you should NOT free yourself from imbedded attachment?

Presentation Category: User Experiences/SQL and XML Features
Presentation Platform: DB2 for z/OS

Paul Turpin's Biography

Paul Turpin is a database architect and database administrator at S1 Corporation 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: "Unlocking the Mysteries of the DB2 Log"

Logging is a critical part of DB2, but often not understood. This presentation will help you understand the log and how to configure it for good performance and recoverability. We will also explore log record layouts and how to use log APIs. In order to use the log APIs, you need a C program, so we will cover what is required to setup a C environment.

Bullet Points:
1. What is a log used for?
2. Understanding log configuration parameters
3. What's in a log - log file layouts
4. Log APIs and how to use them
5. How to setup a C environment to use log APIs

Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows

Robert Donaldson's Biography

Have worked with relational databases for over 13 years, predominately DB2 on UNIX, with occasional forays into Mainframe and Windows. 9 Years experience working with DB2 text search products (including Net Search Extender). I've been at LSSiData for 9 years. I am a Database Architect with responsibility for the design an implementation of many of our Relation Database systems. I also have development responsibility for several of the C++ applications and gateways that accesses these databases. My background includes C/C++ software development, Database Administration, and UNIX System administration. Officer of TriDUG (Research Triangle, NC DB2 users group), IBM Data Champion 2009. Prior Speaker at IDUG and IBM IOD conferences. My hobbies include saltwater fish, wood working, and photography though not all at the same time.

Title: "High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7"

This presentation discusses full text search options in DB2. Solutions compared from a performance perspective are: Word support tables, old legacy NSE, Text Search (introduced in DB2 9.5) and the new NSE introduced in 9.7. Capabilities are compared with main focus on performance and usage limitations and notes. Text searching in DB2 7.2, 8.x, and 9.1, was almost usable. Often unstable if you had lots of text indexes. 9.5 introduced a new Text Search based on the OmniFind engine, solid stability, but indexing performance was not as good. DB2 9.7 brings in a far improved NSE that delivers both the stability we've been waiting for and high performance. Special attention is on the improvements that make NSE 9.7 a true enterprise solution that is has never been in the past. Discard your prior experiences with NSE, it's worth a new look. The old performance and stability limitations of parallel indexing are gone. Bullet Points:
1. Know what free form text search options are available in DB2 UDB 9.1, 9.5, and 9.7. Old NSE (DB2 7.2, 8.x, 9.1, 9.5), Text Search (introduced in DB2 9.5), New NSE 9.7, and the old fashioned word support table method.
2. Compare the functionality between the text search options.
3. Real world indexing performance and space requirements.
4. Text indexing update considerations.
5. Things I've learned to watch out for and advise on usage, primarily relating to NSE.

Presentation Category: New Release for LUW/Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows

IDUG 2010 North America RUG Discount Information

Contact Paul Turpin for RUG discount code.
SIRDUG Home Page

Last Update: February 19, 2010

Copyright © 2009 SIRDUG Inc. All rights reserved.