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!
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
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
To pre-register please use our new online registration form at:
meeting registration form
email email@example.com 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).
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.
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
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.
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.
You can download the IDUG 2007 North America Conference RUG coupon by
SIRDUG Home Page
Last Update: March 23, 2007
Copyright © 2007 SIRDUG Inc. All rights reserved.