Baltimore/Washington DB2 Users Group LUW Meeting – Friday, 3/6

Posted by Kim May on March 3, 2009 under Baltimore Washington DB2 Users Group, Data Studio, DB2 Education, DB2 for Linux Unix Windows, MQT's, SQL Tuning. Tags: .

The second LUW track meeting is scheduled for this Friday, March 6, 2009, at the IBM TEC in McLean, Virginia.  Petrus Chan from the Toronto Lab will be presenting. 

I’ve spent a good portion of the past couple weeks getting individual invitations out to local DB2 for LUW users but if you are out there and I have not personally invited you, please consider yourself welcome – and try to join us.  Details on the presentations are below.   There is no charge for the sessions (they are *free* thanks to Tak Lee and the local IBM team) and pizza will be provided by The Fillmore Group.

One note:  because we are meeting at a secure IBM facility, I need the name, email address and a contact phone number of anyone interested in attending so they know in advance who will be in the building.  Shoot me an email at kim.may@thefillmoregroup.com, if you can make it.  I hope to see you there.

Agenda:

10:00-11:30am  Session 1:  An In-depth Look at DB2 Active Data Features – Constraints and Triggers
A DB2 Active Data Feature allows an SQL statement to invoke an action that is not explicitly specified by the SQL statement.  Such features are generally used to verify data integrity and to trigger general-purpose
automatic actions.  We will take a look at the different types of DB2 constraints (check constraints, foreign
key constraints, generated columns, etc.) and triggers, examples of how they are used in business contexts, and their pros and cons.  We will also explore how constraints can be exploited by DB2 Optimizer for semantic query optimization.

11:30-12:00pm  Customer presentation:  DB2 Tuning

12:00-12:30pm  Break & Lunch Served

12:30-2:00pm  Session 2:  A First Look at DB2 Materialized Query Tables (MQT)
In a data warehouse environment, users often issue queries repetitively against large volumes of data with minor variations in query’s predicates.  Materialized Query Tables (MQT) can be used to improve performance for such queries.  We will introduce the general concepts of MQTs,  including the different types of MQTs, their design and maintenance considerations.  We will also go through some examples of how MQTs can be used to improve performance of complex queries.  

Petrus Chan
Petrus Chan is an advisory software developer specializing in the DB2 SQL Compiler for DB2 on LUW at the IBM Toronto Software Lab.  Petrus has over 10 years of experience in the SQL Compiler area, with expertise in DB2 active data features such as constraints, triggers and materialized query tables.   Petrus is a graduate of the University of Waterloo, where he earned a B.S. in Math and his Master’s in Math and Computer Science in 1997. Petrus holds four data systems and methodologies patents.

1 Comment so far

  1. Michael Wiebracht March 9, 2009 2:28 pm

    Kim, I have a consultant who is looking for a new DB2 assigment. He has just come off a suceesfful migration for one of my clients. The best environment for him would be a zSeries platform. He has a strong mainframe background. If you knnow of anyone who is looking for someone to do a DB2 migration, would you please let me know? Thanks so much.

    Michael Wiebracht – 415-616-6302
    michael@strategic-staffing.com

Leave a Comment

Name

Email

Website

Comments

More