3/15/05 Central Pennsylvania Regional DB2 User Group

Terry Gawlas

3/15/05 Central Pennsylvania Regional DB2 User Group




The Central PA Regional DB2 User Group has been scheduled for March 15,
2005. Below you will find the details, hope to see you there!

Central Pennsylvania Regional DB2 User Group

Date: Tuesday, March 15th, 2005
Place: Camp Hill Corporate Center, Building 300, Large Auditorium
Cost: FREE
Reservations: Email or call: [login to unmask email] (717) 302-3991
For details and directions: See http://www.db2parug.org

Agenda for March 15th, 2005

8:30 to 9:00 Breakfast, Compliments of Themis, Inc.

9:00 to 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 to 10:30 Break

10:30 to 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 to 12:15 Lunch, Compliments of Compuware Corporation

12:15 to 12:45 Lunch and Learn Session, Compliments of Compuware
Corporation
Presenter: Byron C. Hutchinson, Compuware Corporation

12:45 to 1:00 Break

1:00 to 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 to 2:30 Break with afternoon snack – sponsored by Themis, Inc.

2:30 to 3:45 To Laugh Or To Cry? Further Fallacies In Data Management
By: Fabian Pascal, Technical Analyst, Editor/Publisher
A lot of what is being said, written, or done in the information management
field by vendors, the trade press and "experts" is increasingly confused,
irrelevant, misleading, or outright wrong. The problems are so acute that,
claims to the contrary notwithstanding, knowledge, practices and technology
are actually regressing! That is because data management practitioners and
users do not possess the foundation knowledge necessary to see through the
misleading hype and misinformation in the industry and media, and their
costly implications. This presentation debunks some of the persistent
misconceptions prevalent in the information/data management industry and
exposes their (im)practical consequences. Test your ability to see through
the former and avoid the latter.

3:45 to 4:00 Closing