Pittsburgh DB2 Users Group Meeting - Monday, March 14th - Caring Place

Chris Straub

Pittsburgh DB2 Users Group Meeting - Monday, March 14th - Caring Place

Here's the agenda for the Pittsburgh DB2 Users Group on March 14th.

Please note, it is being held at the Caring Place on Stanwix Street right
next to Max and Erma's.

Pittsburgh Regional DB2 User Group

Date: Monday, March 14th, 2005
Place: The Caring Place – 620 Stanwix Street
Cost: FREE
Reservations: Email or call: [login to unmask email]
[login to unmask email] 412.544.7006
For details and directions: See http://www.db2parug.org

Agenda for March 14th, 2005
8:30 - 9:00 Breakfast
9:00 - 10:15 SQLJ Developer Experiences w/DB2
Presenter: John Mallonee, Highmark
SQLJ is an open standard for using static SQL in a Java
application. Come see a developer's experiences in configuring
a Windows desktop environment, coding SQLJ Java classes, using
the SQLJ translator within a development tool, running the
profile customizer to bind the package to DB2, and finally
running the application. Finally, see how this all becomes
easier with DB2 version 8.
10:15 - 10:30 Break
10:30 - 11:45 DB2 V8 z/OS SQL Enhancements
Presenter: Randy Ebersole, IBM Software Group
This presentation will look at the new features related to SQL
for DB2 Version 8 for z/OS. There is a long list of new
features associated with DB2 V8 z/OS SQL. The focus of the
presentation will be to deliver the basics to build the
foundation to allow application developers to exploit this new
SQL functionality.
11:45 - 12:15 Lunch, Compliments of IBM Corporation
12:15 - 12:45 Lunch and Learn Session
Presenter: Kevin Ondriezek, IBM Corporation
Topic: IBM Database Tools on DB2 V8
12:45 - 1:00 Break
1:00 - 2:15 DB2 V8 Implementing Materialized Query Tables MQTs
Presenter: David Beulke, Pragmatic Solutions, Inc
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 &
turned query response time from hours to sub second w/MQTs.
2:15 - 2:30 Break
2:30 - 3:45 Real Time Stats – Really Needs Initialized
Presenter: Chris Straub, Highmark
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

3:45 - 4:00 Closing