IDUG Preview Session featuring Robert Catterall and Roger Sanders

SIRDUG Meeting February 23rd, 2007

Featuring: Robert Catterall - IDUG Speaker's Hall of Fame and Roger Sanders - A well-known DB2 author.

SIRDUG is very pleased to announce that the first 2007 SIRDUG meeting on February 23rd will feature Robert Catterall of Check Free. After receiving the IDUG Speaker's Hall of Fame award as an IBMer, Robert now works for Check Free, and so he now qualifies as a User Speaker. Robert Catterall will give us a preview of his 2007 North American IDUG conference presentation. Roger Sanders has recently completed his 14th DB2 book and will be giving a lot of tips on dealing with XML. Robert Donaldson, Sally Mir and Lisa Ouellette will also be presenting their IDUG NA 2007 presentations.

This year's IDUG North American Conference will be in San Jose, California, birthplace of DB2, May 6 through 10th. If you are considering attending this year's IDUG NA conference, make sure you scroll to the bottom of this announcement for some exciting discount information!

Meeting Details

WHEN? Friday, February 23, 2007

WHERE? IBM Harris Blvd facility

COST? $30 cash or check, in advance or at the door.
We do not accept credit cards.

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 - "What DB2 People Should Know about SOA"
10:15 - 10:35 - Mid-Morning Break
10:35 - 11:50 - Parallel sessions (? / ?)
11:50 - 12:50 - Lunch
12:50 -  2:10 - Parallel sessions (? / ?)
 2:10 -  2:20 - Mid-Afternoon Break
 3:30 -  4:00 - 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 16th. 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 the meeting site:

The meeting is in the 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 a Director of Engineering at CheckFree Corporation. As part of the Company's Technology Strategy and Planning group, Robert works to establish corporate-wide standards for the use of information technology in CheckFree applications and systems. Prior to joining CheckFree in February of 2000, Robert spent 17 years at IBM, the last ten of those as a member of the DB2 for z/OS national technical support team at IBM's Dallas Systems Center. Robert writes the DB2 DBA column that appears in each issue of DB2 magazine, and regularly speaks at local, national, and international user group meetings He is a member of the IDUG Speaker's Hall of Fame.

Title: "What DB2 People Should Know about SOA"

Misperceptions about Service-Oriented Architecture abound. Do you think that Web services equates to SOA? Do you think that mainframes and SOA are mutually exclusive? Do you think that loose coupling of application components implies multiple back-end database servers? Wrong, wrong, and wrong. This session aims to demystify SOA concepts and terminology, explain the relationship between SOA and XML, and describe the advantages of SOA in business terms.

Bullet Points:
1. Why SOA is such a hot topic these days.
2. What the "Service" part of SOA is all about.
3. The relationship between SOA and XML.
4. Web services concepts and terminology.
5. What SOA isn't, and how SOA can deliver benefits to an organization.

Presentation Category: Emerging technology (e.g. XML, .NET, SOA, Java, Open Source)
Presentation Platform: Cross Platform

Roger E. Sander's Biography

Roger E. Sanders is the Sr. Manager of IBM Alliance Engineering for NetWork Appliance, Inc. 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 for DB2 Magazine, and is the author of 14 books on DB2 UDB.

Title: XML - What it means to DBAs

With DB2 Version 9, XML documents can be stored in their native format (in other words, without having to be converted into large objects or be shredded and stored into tables) along side relational data. This new "pure" XML storage enables quick information retrieval from the documents with either SQL or XQuery. But what does this capability mean to the DBA who is responsible for the “care and feeding” of the database that contains XML data? This presentation will cover the concepts a DBA needs to know in order to create and manage an XML-enabled database.

Bullet Points:
1. Creating an XML-enabled database.
2. The XML data type - creating tables with XML columns.
3. Inserting, updating, and deleting XML data.
4. Indexes and XML columns; RUNSTATS and XML data.
5. Importing and Exporting XML data.

Presentation Platform: DB2 for Linux, UNIX, Windows

Sally Mir's Biography

Sally Mir is a Lead 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: Stuck in V8 Compatability Mode? How to Make the Best of It

Everyone is looking forward to reaping the benefits of DB2 V8 New Function Mode. But what if you find yourself stuck in Compatibility Mode for a long time? There are still a lot of V8 enhancements and features that can be used while in CM. This presentation will explore a few of them and share the experiences we have had in CM at Wachovia.

Bullet Points:
1. Bufferpool improvements
2. Access path enhancements that improve SQL performance
3. Utility enhancements
4. Adapting to DFSort from SyncSort
5. Visual Explain enhancements

Presentation Category: Experiences with new releases and features of DBMS
Presentation Platform: DB2 for z/OS

Lisa Ouellette's Biography

Lisa is a member of Wachovia's Z/OS Capacity, Performance and Optimization team. She has worked with DB2 since 1987, starting as a version 1 release 2 data base administrator. Since 1995, Lisa's role at Wachovia has been to reduce mainframe hardware and software licensing costs via application, database and system optimization. "Spreading the wealth" of knowledge about tools and techniques is one of the ways the mission is accomplished.

Title: Mainframe Optimization – Measure It!

Why measure? - product decisions, architecture decisions, contract decisions, understand what ‘it’ costs and is ‘it’ worth it. Data sources - Standard reporting examples - Relationship to each other - Relationship to address spaces - Mine data from your friends Example #1 - Production report examples for a Websphere / DB2 application Example #2 - Production report examples from DB2 stored procedures called both from client and CICS program Mistakes to Avoid: - hardware - system software - I/O subsystem - Memory - Load Runner reporting

Bullet Points:
1. Introduction – Why measure?
2. Data sources – Workload Activity data (WLM Service class and Report class – SMF Type 72), Address space data (SMF type 30), DB2 Accounting trace (SMF type 101), CICS (SMF type 110), Websphere (SMF type 120)
3. Example #1, Websphere Z/OS and DB2
4. Example #2, DB2 stored procedures
5. The list of mistakes to avoid when measuring.

Presentation Category: Experiences with new releases and features of DBMS
Presentation Platform: DB2 for z/OS

Robert Donaldson's Biography

Have worked with relational databases for over 10 years, predominately DB2 on UNIX, with occasional forays into Mainframe and Windows. I've been a UNIX sysadmin and DBA as well as a software developer. 9 years experience writing applications and interfaces into relational databases, mostly DB2 using using C and C++. 5 Years working with text search (DB2 Text Information Extender/Net Search Extender). Officer of TriDUG (Research Triangle, NC DB2 users group) Father of two adorable 7 year old twin daughters. (Whom are both perfect by-the-way.) My hobbies include saltwater fish and wood working, though not at the same time. My sense of humor tends to get me into more trouble than it gets me out of, but hey, life should be fun right?

Title: Space, The Final Frontier: DB2 Native Compression Options

DB2 provides 3 methods to compress data to conserve storage space. This presentation discusses the three methods and gives the advantages and disadvantages of each based on my experiences. Most attention is given to Data Row Compression which was introduced in DB2 v9. The older Table Null Value compression and Column Default Value compression methods are also discussed and compared.

Bullet Points:
1. What does each compression option do to help reduce your data size.
2. Advantages and disadvantages to each of the compression options discussed based on my experiences.
3. When to consider one of the compression options (Choose wisely, sometimes they can hurt more than help).
4. Performance impact on an i/o bound system and a CPU bound system.
5. General considerations

Presentation Category: Experiences with new releases and features of DBMS
Presentation Platform: DB2 for Linux, UNIX, Windows

IDUG North America 2007 Discount Information

You can download the IDUG 2007 North America Conference RUG coupon by Clicking here

SIRDUG Home Page

Last Update: January 29, 2007

Copyright © 2007 SIRDUG Inc. All rights reserved.