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

When? Wednesday, September 12th, 2012, 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 10 Online Schema Management
  Bill Arledge, CA Technologies, Principal Consultant

Prior to DB2 V8, change to database definitions frequently required disruptive processes that impacted application availability. DB2 V8 introduced enhancements that allowed you to change some object attributes online, without affecting availability. DB2 9 added more possible changes. DB2 10 introduces new ALTER options that allow you to convert the structure of the table space and change physical object attributes with minimal impacts to availability. This presentation will discuss this schema management history and delve into the details of the DB2 10 enhancements, explaining the process for changing existing object attributes while minimally impacting application availability.

  10:15 - 10:30 Coffee Break
  10:30 - 11:45 DB2 Dynamic Statement Cache - A DB2 10 Redux
  Jim Wankowski, CA Technologies, Principal Consultant

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 local and global dynamic statement caches, with details on DB2 10 enhancements that improve local and global dynamic utilization. We’ll also discuss monitoring performance of dynamic SQL using cache statistics including new DB2 10 metrics that improve statement cache management.

  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 10 Security Enhancements
  Bill Arledge, CA Technologies, Principal Consultant

DB2 10 dramatically changes the security model for managing DB2 applications and objects, extending the role-based security model introduced in DB2 9. Security, regulatory compliance, and audit capability are improved as well while providing increased administrative flexibility and reduced exposure to unauthorized data access by applications or administrators. DB2 10 introduces label-based row and column access control and masking or encryption of sensitive data. This presentation covers details of these significant enhancements in DB2 10.

  2:00 - 2:15 Break
  2:15 - 3:30 Application Optimization in DB2 for z/OS V10
  Jim Wankowski, CA Technologies, Principal Consultant

Managing the many facets of DB2 performance is a monumental and time consuming task. Most DBAs today simply do not have the time or band width to effectively monitor, manage, and maintain their DB2 z/OS environments. Over the last few releases of DB2, IBM has been introducing automatic facilities such as Real-Time statistics to help make application performance, and maintenance management more “hands off”. DB2 V10 introduced several new features focused particularly on managing statistics and assisting in testing and optimizing application performance.

This presentation will discuss real-time statistics and the new maintenance features added in V10 such as autonomic statistics, and statistics profiles. It will also cover application optimization features such as statement level optimization, virtual indexes, and bind options.


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:

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

All pre-registrations must be received by Friday, September 7th, 2012.

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 37 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. In 2010, Bill joined CA Technologies as a technical sales consultant focused on DB2 and IMS technologies and tools. Bill presents DB2 technical topics at numerous venues in North America and around the world.
Jim Wankowski has more than 27 years of development and database administration experience with DB2 for both z/OS and LUW. Jim is currently a principal consultant with CA Technologies supporting their DB2 z/OS tools. Prior to joining CA, Jim spent 10 years as the DB2 product manager for Quest Software and nine years as a DB2 product specialist at Platinum Technology. Jim is a well-known international speaker who has written articles for DB2 Magazine, and Z/Journal, and has regularly presented at IDUG NA, IDUG EMEA, IDUG AP, IBM Technical conference (IOD), regional DB2 user groups, and vendor seminars worldwide.
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.