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!
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
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
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 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.
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 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.
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. 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.
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 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.
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 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.
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
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?
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
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.