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:
|
||
| 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.