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

When? Wednesday, June 10, 2009, 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 My DB2 Process is Broken! Fix It!
  Jeff Gross, Computer Associates

DB2 application processing can fail for a variety of reasons and due to no changes in the original application. Learn what time can do to a process that used to run just fine. This presentation will:

  • Discuss what DB2 product changes can happen
  • Discuss what data changes can happen over time
  • Discuss what other processing can change (vendor or environmental)
  • Discuss how a process can be designed to be less sensitive to change
  • Discuss what to do when a problem is found
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 How to Predict DB2 Performance Changes
  Jeff Gross, Computer Associates

This presentation will provide a quick overview of Explain evolution over time and how this feature has become the mirror of the Optimizer. The presentation will look at some potential methods to exploit in order to influence the Optimizer's decisions and some issues to have in mind where Explain does not show the "real picture." In addition, some ideas of how Explain information can be versioned in order to quickly find the reason for a performance change will be provided as well as how to predict performance before a program or SQL statement is bound/rebound -- a major concern during DB2 upgrades.

  11:45 - 12:45 Lunch & session provided by Computer Associates
  12:45 - 2:00 Advanced Technical Support (ATS) DB2 Health Check -- What will the Specialist Prescribe for You?
  John Iczkovits, IBM
  Maybe you are concerned about your DB2 environment or maybe you just want to validate your environment, so you are thinking about an Advanced Technical Support (ATS) DB2 Health Check. You wonder what really happens in a DB2 health check. What will you walk away with? Will management approve of the final analysis? How will you and your company benefit from the analysis? If you have ever seen the required and extensive documentation list and have needed to revive yourself after seeing it, you might ask if this is all really necessary. Why does ATS really need this detailed information and what will they do with it? Find out the answers to these questions and more by attending this presentation. You will leave with an understanding of why the ATS DB2 Health Check is truly one of the best in the industry and how it will benefit you and your company.
  2:00 - 2:15 Break
  2:15 - 3:30 ATS DB2 Health Check (cont.)
  John Iczkovits, IBM

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 5, 2009.

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
Jeff Gross is currently the WW Support Delivery Manager of the DB2/IMS Tools for z/OS at CA and leads the technical support group in implementing CA's Mainframe 2.0. Jeff has more than 25 years of experience in the computer industry starting with a computer science degree from Northern Illinois University. He has seen DB2 grow since release 2.3 and has used it in online, data warehousing, and ad-hoc systems. He has spoken at NA and European IDUG and CA World in Las Vegas.
John Iczkovits is a Consulting IT Specialist with IBM Advanced Technical Support (Dallas Systems Center). He provides DB2 z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work at IBM includes experience supporting DB2 as a systems engineer, database administrator, IT specialist, consultant, and project lead. He has an operations background and more than 25 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, and has presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, and at local DB2 users' groups.
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.