IDUG Preview Session featuring Craig Mullins

SIRDUG Meeting April 13th, 2007

Featuring: Craig Mullins

SIRDUG is very pleased to announce that the April 13th SIRDUG meeting will feature Craig Mullins. Craig is a well-known DB2 author and frequent speaker at events like IDUG.

This year's IDUG North American Conference will be in San Jose, California, birthplace of DB2, May 6 through 10th. If you are considering attending this year's IDUG NA conference, make sure you scroll to the bottom of this announcement for some exciting discount information!

Meeting Details

WHEN? Friday, April 13, 2007

WHERE? IBM Harris Blvd facility

COST? $35 cash or check, in advance or at the door.
We do not accept credit cards.

Tentative Meeting Agenda

Tentative Meeting Agenda

 8:00 -  8:50 - Registration - Coffee, Danish, and Networking
 8:50 -  9:00 - SIRDUG announcements and speaker introductions 
 9:00 - 10:30 - Craig Mullins - "Change Control for DB2 Access Paths"
10:15 - 10:35 - Mid-Morning Break
10:35 - 11:50 - Craig Mullins - "Null and Void?  Dealing With Nulls in DB2" 
11:50 - 12:50 - Lunch
 1:00 -  2:30 - Craig Mullins  - "Managing Data for Long-Term Retention"
 2:30 -  2:45 - Mid-Afternoon Break
 2:45 -  3:15 - Q & A / Book Drawing
 3:30 -  4:00 - Networking, Adjourn

We are still working on the exact agenda, so what you see may change 
a bit.


To pre-register please use our new online registration form at:
meeting registration form
email and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.

Pre-registration must be completed by Midnight, Friday, February 16th. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to the meeting site:

The meeting is in the IBM Harris Blvd facility

North bound on I-77 (from the Rock Hill direction):Turn right onto I-85 North and follow next directions.

On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West. Turn Left at 2stop light onto IBM Drive and follow the directions below.

South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp) Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.

Craig Mullins's Biography

Craig S. Mullins is a data management strategist for NEON Enterprise Software, Inc. Craig has extensive experience in the field of database management having worked as an application developer, a DBA, and an instructor with multiple database management systems, including working with with DB2 for z/OS since Version 1. Craig is also an IBM gold consultant and is the author of two books: - DB2 Developerís Guide; and Database Administration: The Complete Guide to Practices and Procedures.

Presentation Abstracts

Change Control for DB2 Access Paths
On the mainframe, change has traditionally been strictly controlled. One exception has been DB2 access paths. Binds and Rebinds are typically done in the production environments without the benefit of oversight or prior testing. This lack of change control results in unpredictable performance impacts. Come learn how you can use Bind ImpactExpert to analyze and manage access path changes whether you are upgrading to a new version of DB2 and want to analyze access path changes prior to upgrading or managing the performance of your production environment. There is finally a tool that enables efficient prescreening of DB2 access paths and provides automated performance protection. Bind Impact Expert can help you to bring a change control discipline to the DB2 access path generation process.

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

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.

IDUG North America 2007 Discount Information

You can download the IDUG 2007 North America Conference RUG coupon by Clicking here

SIRDUG Home Page

Last Update: March 23, 2007

Copyright © 2007 SIRDUG Inc. All rights reserved.