Baltimore / Washington DB2 Users Group
BWDB2UG LUW Quarterly Meeting

When? Wednesday, June 9th, 2010, 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 Exploring IBM® Downloadable No-charge Features for Databases
  Paul Wirth

IBM provides the DB2® family and Informix® Dynamic Server customers with several downloadable products at no-charge.  The purpose of these "no-charge" database features is to improve the productivity of database administrators and accelerate application development.  During these very difficult economic conditions and strained resources, employee productivity is of more importance than ever.  Therefore, to improve productivity and learn about available tools, this presentation will explore the following IBM® no-charge database features of: IBM Data Studio, IBM Data Server Client, Optimization Service Center and the IBM .Net Add-Ins.   These features provide many abilities such as; supporting Service Oriented Architecture (SOA), create database objects, compare table objects, create SQL and help in problem identification.  This presentation will focus the following IBM databases: DB2 for Linux, UNIX and Windows, and DB2 for z/OS.  The ultimate goal if the presentation is to improve productivity and show how easy it is to work the IBM family of databases, review new features and help with database migration planning.


  • Review the simplification of workstation connections to DB2 z/OS using IBM Data Studio
  • Review abilities to create and alter: tables, views, triggers and indices
  • Demonstrate table object comparison and table drop impact analysis
  • Explore the DB2 z/OS dynamic statement cache for opportunities to improve SQL and save CPU cycles
  • Demonstrate SQL query building and the new Visual Explain feature
  • See how to create web services from DB2 stored procedures
  • Demonstrate exposing DB2 stored procedures as a web services
  • Demonstration of  DB2 SQL stored procedure creation and debugging
  • Review support for XML data
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Exploring IBM® Downloadable No-charge Features for Databases (cont.)
  Paul Wirth
  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 Connections to DB2 for z/OS (DB2 z/OS Distributed Threads End-2-End)
  Paul Wirth

Hang on to your hat for a whirlwind "end-2-end" tour of distributed application connectivity to DB2 z/OS.  The purpose of this presentation is to provide an "end-2-end" overview of distributed connections to DB2 z/OS, from the client all the way to z/OS Workload Manager. Given distributed transactions cross many different business organizations, gaining an understanding of the "big picture" of a distributed transaction is difficult.  The goal of this presentation is to provide a high level view of distributed transactions, trying to de-mystifying the behavior of DB2 z/OS distributed workloads.  During the presentation there will be focused attention on application: availability, resiliency, capacity planning and workload prioritization.  New DB2 9.x Linux/Unix/Windows Client features and DB2 9 for z/OS migration considerations will also be covered.


  • DB2 Clients - Review of the DB2 Runtime Clients, drivers and Client Deployment tools
  • DB2 Connect - Configuration Strategies and the Java Type-4 Driver
  • DB2 z/OS and Distributed Connections - Thread Pooling and Thread Parameters
  • DB2 z/OS and Connection Resources - Capacity Planning for Threads on DB2 z/OS
  • z/OS Workload Manager (WLM) - WLM and DB2 Threads, also zIIP Processors and DDF
    (Java and Microsoft® .Net application programming considerations for WLM are also covered)
  2:00 - 2:15 Break
  2:15 - 3:30 DB2 Connections to DB2 for z/OS (DB2 z/OS Distributed Threads End-2-End) (cont.)
  Paul Wirth

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

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

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
Chris Eaton is a DB2 Technical Evangelist for DB2 primarily focused on planning and strategy for DB2 for LUW. Chris has been working with DB2 on the Linux, UNIX, Windows platform for over 17 years. From customer support to development manager, to Externals Architect and now as Product Manager for DB2, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is the author of "IBM DB2 9 New Features" and "The High Availability Guide for DB2" and has one of the most popular blogs about DB2 on IT Toolbox at
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.
DB2 Gold Consultant Frank C. Fillmore, Jr. is the Founder and President of The Fillmore Group, Inc., an IBM Business Partner specializing in Information Management services and sales. Frank's areas of expertise include replication and high availability, InfoSphere, DB2 Server for VSE&VM, IBM Content Manager and technical Project Management. Frank oversees a staff of full-time employees and contractors who deliver consulting services to customers worldwide and delivers IBM authorized training classes at The Fillmore Group's headquarters in Towson, Maryland. Frank blogs on DB2 related topics at
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.