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.
To download Robert Catterall' ""
click here
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
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
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, 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.
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 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
Bullet Points:
1.
2.
3.
4.
5.
Presentation Category: Implementing new DB2 releases and features
Presentation Platform: DB2 for z/OS
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.
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 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
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
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.
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
Contact Paul Turpin for RUG discount code.
SIRDUG Home Page
Last Update: February 19, 2010
Copyright © 2009 SIRDUG Inc. All rights reserved.