Houston Area DB2 User Group
 
The Houston Area DB2 User Group is alive once again.
All details will be posted here as they become available.  Check back often for the latest updates!

And tell all of your DB2 friends to start watching this space. Without attendees, a user group cannot survive.

Next meeting date  
Tuesday, July 17, 2007
9:00 AM - 1:00 PM
 
Meeting location  
Mays Clinic    (Ambulatory Clinic Building)
1220 Holcombe Blvd    (Holcome Blvd and Bertner Ave)
Houston, TX    77030-4004
Conference Room: ACB1.2325 A-C    (On first floor)
Click here for directions
 Commuting Tips
  To get to the Mays Clinic using MetroRail or bus:
Take MetroRail or bus to the Texas Medical Center Transit Center. Walk one block east on Pressler Street to Bertner Avenue. Turn north onto Bertner Avenue. The Mays Clinic entrance will be on your left.
 
Access to public parking is via ramps on the Bertner (east) side of the Mays Clinic.
Next meeting agenda
 
9:00 AM   Opening - Intro
 
9:15 AM Topic: Managing Data For Long Retention Periods: Requirements and Challenges
Several events in recent years have changed the requirements for retaining data from operational databases to long periods of time. Required retention periods have ballooned to many years, and in some cases, to many decades. This coupled with the rapid rise in data volumes and the importance of providing archived data on demand many years after it is created, has surfaced the need for companies to build a solid practice for archiving and managing business data from their online operational databases. The presentation covers the basics of an archiving methodology and a number of topics that require special consideration in building a database archiving practice. Topics covered are application independence, metadata independence, data authenticity, change management, storage management, and access control.
  Speaker: Craig Mullins, NEON Enterprise Software
Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database administration and system administrator, and data analysis and modeling. He has worked with DB2 for z/OS and OS/390 since Version 1 and has experience working with Microsoft SQL Server, Sybase and IMS. Craig has worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.

Craig is the author of the book "DB2 Developer's Guide" published by SAMS Publishing. The book contains more than 1500 pages of in-depth technical information on DB2 for z/OS and OS/390 updated through DB2 Version 8.

Craig is also the author of "Database Administration: The Complete Guide to Practices and Procedures", published by Addison Wesley. This book offers the industry's only comprehensive guide to heterogeneous database administration.
  Handout Download to View             (PDF format - size: 370KB)
Download to Print 2-up    (PDF format - size: 0KB)
 
10:15 AM Topic: Null and Void? Dealing with Nulls in DB2
Nulls are one of the most controversial aspects of SQL database systems. On the one hand they seem to be useful as means to record missing information; on the other hand, they introduce three-valued logic and other difficulties into our applications. This presentation will delve into the various aspects of nulls, show some of the problems presented by nulls, and give advice on how best to use/avoid them.
  1. What is a Null?
  2. How DB2 Implements Nulls
  3. Nulls in General Practice
  4. Some of the Problems with Nulls
  5. How to Use/Avoid Nulls
  Speaker: Craig Mullins, NEON Enterprise Software
  Handout Download to View             (PDF format - size: 600KB)
Download to Print 2-up    (PDF format - size: 0KB)
 
12:00 PM   Lunch
1:00 PM   Meeting end
We would like to thank  M.D. ANDERSON  for providing the conference room for this quarter's user group meeting.

We'll also be handing out IBM's "System z Data Servers & Tools zStick" while supplies last


If you are planning to attend a meeting or need additional information, please contact the Houston Area DB2 User Group at: HADUG_Info@db2now.com

 
Sponsored by:         IBM blue logo
 

  Popular Links  
International DB2 User Group (IDUG) logo DB2 Family Home Page 2007 Information on Demand Conference Banner
Previous meetings
2007-03-01 meeting

This page has been visited

Copyright © 2007 Houston Area DB2 User Group
All rights reserved.