Baltimore / Washington DB2 Users Group
BWDB2UG z/OS Quarterly Meeting

When? Wednesday, September 9, 2009, 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: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50

Meeting Schedule:

  8:30 - 9:00 Registration
  9:00 - 10:15 Upgrades, Migrations, and Archiving Strategies
  Tom Howell, IBM Optim

Are you currently planning for your upgrade or migration to DB2 V9.x? Are youprepared for the next generation of CRM/ERP applications? How are you managing the assortment of databases and/or applications running in your various environments? Are you prepared for the upgrades and migrations which may be on the horizon? Join us as we review the best practices for leveraging archiving to streamline your upgrade or migration project.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Data Privacy - Closing the Gap
  Tom Howell, IBM Optim

Privacy breaches are making headlines as organizations scramble to protect the confidentiality of their critical customer and business data. While companies are making great strides in protecting data privacy in production application environments, the idea of implementing similar strategies in their testing environments is often overlooked. This "Privacy Gap" needs to be addressed immediately because it often represents the most exploited area of an organization's IT infrastructure. Taking a proactive strategy to remove this vulnerability within your enterprise is recognized as a best practice and will help your organization with compliance with many national, international, and industry-specific regulations while at the same time protecting your company from being the next "Privacy Breach Headline."

  11:45 - 12:45 Lunch & product demos provided by IBM Optim
  12:45 - 2:00 What's New in DB2 9 for Applications
  Patrick Bossman, IBM
  This presentation will discuss new SQL features and query optimization enhancements in DB2 9 for z/OS. Attendees will learn what new SQL functions are available in DB2 9. Attendees will also learn query optimization enhancements, including improvements to query costing, new access methods, and enhancements to RUNSTATS.
  2:00 - 2:15 Break
  2:15 - 3:30 Improving Performance with DB2 V9 for z/OS
  David Beulke, David Beulke & Associates
  This presentation is all about getting the most out of the new version of DB2. The presentation will highlight all the new performance parameters and technical features and how to exploit them on the first day of your V9 implementation. Besides presenting new features, current features along with functions and techniques that impact your system and application performance will be discussed. This presentation also briefly talks about new and existing architectural, database, and application performance aspects along with tuning considerations so you can dramatically reduce your CPU and I/O costs. Moreover, it will examine potential problem areas and the improvements that can be made in system configurations, database designs within batch, online and java applications. You will learn the vital activities to prepare and the best techniques to tune up the performance and fully exploit your DB2 z/OS V9 environments.

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, September 4th, 2009.

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
Tom Howell has more than a decade of experience in the technology industry. He has spoken at numerous conferences, user groups and associations on topics ranging from data privacy and compliance to the implementation of data management strategies and the implementation of solutions to secure data in test and development environments. His background includes work with leading organizations such as Gryphon Networks, Princeton Softech, and currently IBM.
Patrick Bossman works on the DB2 for z/OS DB2 Query Optimization team. He has worked for IBM for 8 years and has 14 years of experience with DB2 as an applications developer, DBA, SQL writer/performance tuner, and now a member of the optimization development team. His current focus is on automating the identification and resolution of query performance problems.
David Beulke is an internationally recognized DB2 consultant, author, and teacher, known for his extensive expertise with database performance, data warehouses, and internet applications. He is an inaugural member of IBM's DB2 Data Champions program, one of the 45 IBM DB2 Gold Consultants worldwide, past president of the International DB2 Users Group (IDUG), columnist for DB2 Magazine for the last 8 years, co-author of the IBM V7 and V8 z/OS DB2 Certification exams, co-author of the Business Intelligence Certification exam, former instructor for The Data Warehouse Institute (TDWI), and former editor of the IDUG Solutions Journal. David has experience working with DB2 on the mainframe, AIX/UNIX, and Windows over the last twenty two years in a variety of environments and industries. His clients save millions of dollars by reducing CPU demand, avoid unnecessary hardware upgrades, and improved application implementations through his customer focused solutions, performance tuning expertise, and expert business designs.
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.