Baltimore / Washington DB2 Users Group
BWDB2UG LUW Quarterly Meeting

When? Wednesday, September 14th, 2011, 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 - A Primer
  Bill Arledge, Principal Consultant, CA Technologies

DB2 performance is a broad topic that can focus on system and/or application performance, depending on the role of the interested party. A z/OS performance management specialist wants a high-level DB2 performance perspective while a production DBA will depend on a more detailed application-level view. Finally, an application DBA or DB2 developer may focus on SQL and object access to tune applications. And of course, some DBAs do it all. This session provides a DB2 performance management overview, discussing performance data sources, key metrics, and techniques used to optimize DB2 performance. We’ll briefly discuss the types of tools that are used to manage DB2 performance.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 Database Performance Discoveries and Recommendations
  Dave Beulke, Dave Beulke & Associates

Is your database application experiencing poor response time, scalability problems, and too many deadlocks or poor application performance? One or a combination of zParms, database design and application coding techniques can cause these performance issues.

There are many new DB2 9 and DB2 10 techniques, system parameters, database design, and application coding methods to avoid problems and revitalized your older databases' performance. This presentation will take you through the discoveries found during recent performance reviews and you will learn about the latest recommendations for fixing your database and application performance problems.

  11:45 - 12:45 Lunch
  Optional product-specific lunch presentation Introduction to CA's Chorus DB2 DBA Role, a new CA Technologies product (presented by Bill Arledge, Principal Consultant, CA Technologies)
  12:45 - 2:00 DB2 Dynamic Statement Cache in a Nutshell
  Bill Arledge, Principal Consultant, CA Technologies

Dynamic SQL is a significant portion of the DB2 workload at many large shops around the world. Dynamic SQL presents inherent performance management challenges and the dynamic statement cache can help mitigate these performance issues. This technical session will review dynamic SQL implementation, including dynamic SQL coding techniques and DB2 bind options that will ensure optimal statement cache usage. We’ll review details on the dynamic statement cache, including monitoring performance of dynamic SQL using cache statistics. Finally, we’ll review DB2 10 enhancements that improve dynamic statement cache utilization.

  2:00 - 2:15 Break
  2:15 - 3:30 Real Time Statistics
  Svetlana Kacapor, Geico

This presentation will provide a short overview of RTS in DB2 V8 and V9 with examples of using RTS for REORG and RUNSTATS utilities. It will focus on researching the use of indexes and monitoring for object growth.


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 9th, 2011.

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
Bill Arledge is an IT veteran with 36 years experience across a variety of roles, including application development and database administration. Bill's database experience began in the late 1970's as an IMS DBA and developer. He began working with DB2 in 1984 as a database specialist at IBM where he consulted with numerous IBM customers on existing and planned DB2 implementations. In 1990 Bill began working in the DB2 and IMS database tools business. He recently joined CA Technologies as a technical sales consultant focused on DB2 technologies and tools. Bill presents on DB2 technical topics at numerous venues around the world.
David Beulke is an internationally recognized DB2 consultant, author and instructor. He is known for his extensive expertise in database performance, data warehouses and internet applications. He is currently a member of the IBM DB2 Gold Consultant program, an IBM Information Champion, past president of the International DB2 Users Group (IDUG), co-author of the IBM DB2 V8 and V7 z/OS Administration and the Business Intelligence Certification exams, columnist for the IBM Data Management Magazine, a DB2 performance topics blogger at and former instructor for The Data Warehouse Institute (TDWI). With over 25 years of experience working with mainframe, UNIX and Windows environments, he designs and tunes systems, databases and applications dramatically reducing CPU demand and saving his clients from CPU upgrades and millions in processing charges.
Svetlana Kacapor is an application DB2 DBA with Geico. She is a Certified DB2 Solutions Expert for DB2 V8 and V9 and has been working with DB2 since 1999 (DB2 V5) in database administration and application development.
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.