Baltimore / Washington DB2 Users Group
Archived
BWDB2UG Quarterly Meeting

When? Wednesday, June 11, 2008, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $20
Pre-registered non-members: $30
At-the-door for members: $30
At-the-door for non-members: $40

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 The Impact of Regulatory Compliance on Database Administration
  Craig Mullins, Neon
 
 

Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA BASEL II, and more make the news, but what do they mean to a DBA? This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:

  •  What are the Regulations?
  •  Compliance Issues
  •  IT Controls
  •  Long-term Data Retention
  •  Database Auditing
  •  Additional DBA Concerns
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Null & Void? Dealing with Nulls in DB2 for z/OS
  Craig Mullins, Neon
 
 

Nulls are one of the most controversial aspects of SQL database systems. On the one hand, they seem to be useful as a 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.

 
  11:45 - 12:45 Lunch provided by Neon Enterprise Software - Product session given by Neon
 
  12:45 - 2:00 Performance Management and Capacity Planning
  Nghi Eakin, IBM Global Services
 
  This presentation introduces key SMF data which can be used to observe the various components in the z/OS environment in which DB2 operates. DB2 workload performance could be impacted by the performance of the supporting infrastructure (CPU, memory, Workload Manager policy, the IO subsystem, Coupling Facility, zIIP engine) and DB2 requesters (CICS, IMS, DDF, etc.). This presentation will show charts built from the SMF data of various customers' production environments to show the benefits of looking beyond DB2.
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 Java Stored Procedures - Getting the Environment Ready
  John Lantz, Federal Reserve Board
 
 

The Federal Reserve Board has recently enabled the development of Java stored procedures on the mainframe in their environment using the Development Center. This presentation goes through the steps to set up that environment. It will include the steps necessary from a system programmer perspective, the DBA perspective, as well as that of the application programmer. It will include some of the problems encountered so that you can avoid the same issues.

   

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, June 6th, 2008.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
Craig S. Mullins is the Corporate Technologist for NEON Enterprise Software. As a data management strategist, Craig has extensive experience in the field of database management and data architecture having worked as an application developer, a DBA, and an instructor with multiple database management systems. Craig also has worked in technology planning and operations with BMC Software and PLATINUM technology, as well as having been a research director for the Gartner Group. Additionally, Craig has worked with DB2 since Version 1, is an IBM gold consultant and has written two books: DB2 Developer's Guide and Database Administration: The Complete Guide to Practices and Procedures.
Nghi Eakin is an IBM Certified I/T Specialist. She has over 25 years of experience in the IT industry with the last 18 years with IBM, working as Performance Analyst, Engagement Manager on customer contracts, DB2 DBA, Application Systems Analyst. Technically skilled in large systems, storage systems, and DB2 products. Has professional skills in project management and application development.
John Lantz is an IBM Certified Database Administrator. He started his career over 25 years ago as a programmer in an IMS environment. Since then he has been a DBA for more than 20 years in a variety of organizations. Currently, he is employed as a DBA at the Federal Reserve Board in Washington DC.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.