| Officers
Meeting Schedule Meeting Minutes Membership Links of interest DB2 Trivia Hot Tips Home |
Meeting at NiSource - Formerly Columbia Gas
|
| 12:30-1:00 | Registration |
| 1:00-1:15 | Business Meeting. Announcements. |
| 1:15-2:45 | Presentation: DB2 V8 Implementing Materialized Query Tables (MQTs) Presented by David Beulke, Pragmatic Solutions, Inc. Abstract |
| 2:45-3:00 | Break - Refreshments will be served. |
| 3:00-4:30 | Presentation: Real Time Statistics - Really Need Initialized Presented by Chris Straub, Highmark Blue Cross/Blue Shield Abstract |
This session will cover the nuts and bolts of implementing Materialized Query Tables (MQTs) in a production data warehouse environment. The session will discuss the research, development and definition of the MQTs along with the system parameters and settings necessary for success. This session is written from the experiences I had while solving a client's data warehouse performance problems. The environment had hundreds of users submitting SQL through an OLAP front-end tool asking random questions against a large data warehouse of over 800 million rows (2TB). The session will detail how we saved the project and client over 750 million I/Os per day and turned query response time from hours to sub second with MQTs.
About the Speaker - David Beulke, Pragmatic Solutions, Inc.
David Beulke is an internationally recognized DB2 consultant, author and lecturer. He is known for his extensive expertise in database performance, data warehouses and internet applications. He is currently a member of the IBM DB2 Gold Consultant program, co-author of the IBM V8 and V7 z/OS DB2 Certification exams, co-author of the Business Intelligence Certification exam, past president of the International DB2 Users Group (IDUG), columnist for DB2 Magazine, former instructor for The Data Warehouse Institute (TDWI), and former editor of the IDUG Solutions Journal. He has helped clients with system and application issues on the mainframe, UNIX and Windows environments and has over 20 years experience in numerous industries.
Real Time Statistics (RTS) is the first step toward autonomic database administration. Does that mean the end is near for today's DBA? I don't think so and neither will you after this presentation. The session will help you understand why you need to initialize your RTS tables; it will show you how to initialize these tables; and it will allow you to understand some of the many benefits RTS can provide to your organization.
About the Speaker - Chris Straub, Highmark Blue Cross/Blue Shield
Chris Straub has been a DB2 Database Administrator for the past 2 years, at Highmark Blue Cross/Blue Shield, primarily supporting mainframe applications. He is the Co-Leader of the Pittsburgh DB2 Users Group and will be presenting at IDUG in Denver this May. Prior to becoming a DB2 DBA, Chris worked as an IMS DBA and a Programmer Analyst. He has over 7 years experience in the IT field.
All in attendance must have either paid in advance or be prepared to pay the dues at the meeting. Please review the Membership
page. Our Officer of Dues and Membership is Sharon
Hamilton. She can be reached at membership@codug.org or (614) 249-4313. Contact her with any questions regarding your company's membership status.
North I: 315 S. to I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.
North II: I-71 S, I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.
North III: Riverside Dr. south, becomes Dublin Rd.
South: I-71 N to 315 N. exit Long St./Dublin Rd. Turn left.
East: I-70 W, to 315 N, exit Long St./Dublin Rd. Turn left.
Airport: I-670 W, exit Rt 33 N (#1a), left on Dublin Rd.
Downtown: W. on Spring St., becomes Dublin Rd.
From the West: I-70 E to I-670 E, exit Grandview Ave., right (N) on Grandview, left on Dublin Rd.
Created: March 17, 2004 / Updated: April 17, 2005
Send changes and corrections to webmaster@codug.org