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

When? Wednesday, September 9th, 2015, 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 DB2 Performance & Tuning – It’s All About The SQL!
  Mike Wingfield, Solution Consultant, Compuware Corporation

Mainframe Application Performance Management is more imperative today with processor speeds approaching the 7 GHZ limit. Throwing hardware at performance issues is not enough anymore. Application response times and runtimes need to be tuned to run as efficiently as possible and often times when it’s DB2 in the application, most of the performance opportunities will be found there. Various CICS, Batch, and DDF DB2 Version 10 tuning opportunities will be examined; analyzing SQL Text, DB2 Access Paths, and the DB2 Catalog Objects involved.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 iStrobe for DB2 Online Demonstration
  Mike Wingfield, Solution Consultant, Compuware Corporation
  Online demonstration of the latest version of iStrobe for DB2 to show ease of use, measurement capabilities, and navigation to all the pertinent DB2 information required for DB2 Performance & Tuning. CICS Online Transactional DB2 examples, as well as, DB2 Batch and DDF will be examined and analyzed.
  11:45 - 12:45 Lunch
  12:45 - 2:00 Using z Systems and DB2 Cloning for Getting Application Changes into Production Faster
  Cheryl Eckert, Airline Tariff Publishing Company (ATPCO)

Airline Tariff Publishing Company (ATPCO) is the world leader in the collection and distribution of fare and fare related data for the airline and travel industry. Their challenge was updating key applications and delivering the most current results that reflect changing market and economic needs to the airlines. Learn how ATPCO took a manual in-house process that took days into an automated and repeatable one that takes less than one hour and how using advanced technology, such as IBM z Systems Flash Copy with the IBM DB2 Cloning Tool can help your applications get into production faster and safer.

  2:00 - 2:15 Break
  2:15 - 3:30 Attack Of The DB2 For z/OS Clones – Clone Tables That Is!
  John Lyle, IBM
  Introducing Clone Tables which gives DB2 for z/OS an Online Load Replace type of capability.

In this presentation, John will introduce the concept of Clone Tables and detail how they work. Clone Tables have several dependencies on other DB2 functionality and he will briefly go over what these dependencies are. John will then indicate how you create Clone Tables, how data is put into a clone tables, and how the data is magically 'exchanged' between the parent/base table and it's clone. John will then finish up with a discussion of how Clone Tables can be used in a customer environment.


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.

Member Registrations
Non-Member Registrations

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

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, September 4th, 2015.

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
Mike Wingfield has been in IT for over 35 years and has been working with DB2 since Version 1.1 in 1987 as a programmer, DBA, Tech Support, Data Modeler, Data Architect, and for the last 20 years as a DB2 Performance and Tuning Specialist. Mike has been utilizing Strobe since 1991 and has documented mainframe operating cost savings of over 50 million dollars using Strobe from 1994 through 2001. Mike retired from U S WEST (which became Qwest Communications and now Century Link) after 30 years of service. As a Strobe Solution Consultant for the last 10 years in Compuware’s Field Technical Support, Mike takes part in Application Performance Assessments for many Strobe customers throughout North & South America, Asia/Pacific, and Europe analyzing Batch, Onlines, Stored Procedures, and DDF performance with Strobe and iStrobe and providing recommendations for runtime and response time improvements.
Cheryl Eckert is a Senior DBA with over 30 years of IT experience and 20 years as a DB2 DBA for z/OS. She has worked for 29 years at Airline Tariff Publishing Company (ATPCO), the world leader in the collection and distribution of fare and fare-related data for the airline and travel industry. As a member of the DBA team, she is responsible for all facets of data base maintenance throughout the full development and production lifecycle as well as subsystem and data cloning.
John Lyle has worked for IBM at the Silicon Valley Laboratory in the DB2 organization since 1985. Joining DB2 development in 1995, he has worked in the RDS area focusing mostly on the DB2 system catalog, migration and fallback and the data definitional language (DDL) areas. He was the lead designer and implementer of the catalog changes for V5 - V8, the fallback coordinator for V5 - V7 and has worked on numerous other Line Items in these releases. John was the lead designer for DB2 9's Clone table function. In V9 - V11+ John was the Utility lead for all of the ENFM changes that were made to the DB2 catalog and directory. He has also worked in the index manager component and is currently working in DB2's Utility department.
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.