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

When? Wednesday, December 7th, 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 Rev up your SQL Applications with Enhanced Statistics
  Ken McDonald, BMC Software

You may have heard that Enhanced Statistics were added to DB2 for z/OS with DB2 9, and you probably wondered what they are and how they can help. This presentation will answer your questions about what the statistics are, how they are enabled, how they get collected, and what effect they will have on your SQL execution. Session objectives:

  • What statistics are affected by the STATCLUS DSNZPARM parameter in DB2 9?
  • What improvements have been made to the calculation of cluster ratio?
  • What does Data Repeat Factor mean and how is it calculated?
  • When are the enhanced statistics used by the DB2 optimizer?
  • What can you do to exploit these statistics to improve the performance of your SQL applications?
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 The Online Schema (R)evolution
  Ken McDonald, BMC Software

The latest improvements in Online Schema capabilities introduced in DB2 10 for z/OS represent something more like a Revolution rather than an enhancement to the OLS Evolution capabilities we've been used to seeing in successive releases of DB2. For the first time DBAs can register the changes they wish to make and then implement them at a time of their choosing using an Online Utility rather than having the object concerned move into an Advisory Status which may cause serious Performance Issues or worse. This session will describe the new OLS capabilities, how to use them and some pitfalls which may not be immediately obvious when you read the new features list. Come and listen to the way of the future as far as making Changes to your DB2 database structures is concerned! Session objectives:

  • Explain the limitations in OLS capabilities provided in previous releases of DB2
  • Describe what has been delivered in DB2 10 for z/OS with the new Deferred Alter capability
  • Discuss how to use the new feature in a real life environment including overcoming any pitfalls or gotchas that may not be obvious from the release notes
  • Provide an Online Schema Change Checklist that delegates can use back at the ranch
  • What's still missing and what may be coming next (bearing in mind that I don't work for IBM!)
  11:45 - 12:45 Lunch
  12:45 - 2:00 DB2 for z/OS Stored Procedures - Trends and Technology
  Robert Catterall, IBM

Stored procedures have been widely used for years in DB2 for Linux, UNIX, and Windows application environments. On the mainframe side, adoption of the technology was initially more limited, but it is becoming mainstream now, in part due to the advent of native SQL procedures, delivered with DB2 9 for z/OS and enhanced with DB2 10. This presentation will lay out a vision of a modern DB2 data-serving system in which stored procedures play a very important role. It will also provide a review of DB2 for z/OS stored procedure enhancements, with a particular emphasis on the advantages of native SQL procedures. The presentation will conclude with some hints, tips, and go-forward recommendations.

  2:00 - 2:15 Break
  2:15 - 3:30 The MOST VALUABLE Information I Get From DB2 for z/OS Monitor Accounting and Statistics Reports
  Robert Catterall, IBM

Online monitoring of a DB2 for z/OS subsystem is very useful at times, but to REALLY see "what's going on in there" I rely on the accounting and statistics detail reports that a number of DB2 monitoring tools can generate. Drawing on my 20+ years of experience in analyzing and using the information in DB2 monitor reports, I will describe in this session the report fields that contain the highest-value information, and how I use them.


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, December 2nd, 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
Ken McDonald joined BMC Software in 1994 as a developer on RECOVER PLUS for DB2, moved to development on Log Master for DB2 (v1) and ultimately became the Product Architect for Log Master and the High-speed Apply Engine. Ken also contributed to the development of the Log Apply feature of CONCURRENT REORG. He is currently the Solution Architect for DB2 Recovery Management Solution. Prior to BMC, Ken worked at EDS for 11 years as an application programmer, an IMS, IDMS, and DB2 systems programmer, and finally as an MVS systems programmer.
Robert Catterall is an IBM DB2 Specialist. Robert started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist at CheckFree Corporation (now part of FiServ). After working for three years as an independent DB2 consultant and trainer, he rejoined IBM in August of 2010. Robert is a past President of the International DB2 Users Group, a member of the IDUG Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He is the author of the "Data Architect" column that appears in each issue of IBM Data Management Magazine, and of Robert's DB2 Blog.
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.