[Home] [Membership] [Mailing List] [DB2 News] [Downloads] [Meeting Info]


March 25, 1999
To: Los Angeles Area DB2 Users Group Members
The next meeting of the Los Angeles Area DB2 User Group will be on Thursday, April 1, at the Sequoia Conference Center in Buena Park. Directions: The Sequoia Conference Center is located at 7530 Orangethorpe Avenue, Buena Park, CA. Telephone is (714) 670-9252. It is one block north of the 91 Freeway at the Beach Boulevard exit (same exit as for Knott's Berry Farm). Coffee will be served at 8:30 am; the presentation will begin at 9:00 and end at 12:00.
Program: The April program will consist of two parts.

"Time Dependent Data? Two Companies - Two DB2 Solutions." How to store and access time dependent data is a weighty design issue with numerous pros and cons. Two nationwide companies, an insurer and an automobile manufacturer, have addressed their specific requirements with very different DB2 solutions. Faced with all the legal ramifications that go along with being an auto/home/life insurer, one of our nations largest insurance companies requires an audit trail of every single change applied to a policy. They support present-dated, past-dated and future-dated transactions. And, they require access to this data in their operational DB2 database as it was (or will be) at any point in time. A well-known automobile manufacturer has quite different time dependent data requirements in their expanding DB2 Data Warehouse. While some user views include a complete audit trail, other user views require limiting the result set to only the most current data. The detailed requirements and solutions chosen by these two companies will give you insight into handling your own time dependent data issues.


Janice Bies has supported every version of DB2 since 1984 when she joined the DB2 V1.1 ESP (Early Support Program) at Northrop Corp. As a DBA, she has provided design, development, capacity planning and maintenance support, managed Northrop's participation in the DB2 V2.1 ESP, and trained over 600 programmers in DB2/QMF. She currently supports a DB2 Data Warehouse expansion project for a large automobile manufacturer. Her specialty is designing for performance and the tuning of large-scale databases.

Round Table Panel Discussion

An "open question" session, during which your technical DB2 questions will be addressed by a panel of specialists. Moderated by Judson Howard. So, bring your burning questions to our April meeting. And, tell your friends!

I look forward to seeing all of you at the next meeting.

Tom Glass
President -- Los Angeles Area DB2 User Group

  Home Up

Created and maintained by MicroChip Consulting Group. Copyright 2003. All rights reserved. Last revised:05/22/03

Home • DB2 Jobs • DB2 Links • 2003 Steering Committee • A legacy of excellence