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

When? Wednesday, June 13th, 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 Optimizing Applications Using Extended Explain Tables
  Jase Alpers, IBM
 
 

The plan table externalizes DB2 optimizer's access path choices, but does not include the information which led to that decision. In this session, we will focus on the information contained in a key extended explain table - the predicate table - and the insight it can provide into the DB2 optimizer's decisions. Queries will be provided that can be used to mine the explain tables and catalog so that potential query performance issues can be proactively identified and resolved.

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Tuning Queries Like a DB2 Developer
  Jase Alpers, IBM
 
 

Tuning DB2 applications for optimal DB2 performance does not need to be a complex exercise. Most SQL performance problems can be easily solved by identifying and resolving differences between the optimizer's expectations and reality. In this session, we'll walk through the process used by the DB2 service team to identify and resolve access path performance problems. We'll discuss the primary reasons the optimizer "gets it wrong" along with options to correct poor performance.

 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 Achieving the Best of Both Worlds - The hybrid data server approach
  Willie Favero, IBM
 
 

Everything seems to be taking too long from tuning complex queries to giving executives access to the right analytics. The world of data and information has changed and organizations are looking for new ways to quickly exploit the explosion of information available. However, yesterday’s approach to decision systems is not meeting the need.

New access paths and a new resource manager delivered via the hybrid data server can be the answer to this challenge. The approach makes data warehouse modernization much simpler and more robust. It creates an environment for operational data store, data warehouse and analytic marts on the same platform as operational systems. This session will explore the blending of traditional techniques for query management with the usage of accelerator technology.

Topics include:

  • Building the System z foundation for analytics
  • Deploying the hybrid data server approach
  • Customer success and lab proof points
  • Traditional techniques that augment this strategy
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 Achieving the Best of Both Worlds - The hybrid data server approach (cont.)
  Willie Favero, 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.

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, June 8th, 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
Jase Alpers works for the DB2 for z/OS optimizer development team at the IBM Silicon Valley Laboratory. Jase has more than 10 years experience with DB2 in application development, consulting, DB2 technical service/support, and DB2 optimizer development. Prior to joining the DB2 optimizer team, Jase led the SQL performance and Relational Data Systems DB2 support teams. Jase's work is focused on deep dive analysis and resolution of SQL performance problems.
Willie Favero is a Senior Certified IT Software Specialist with IBM's Silicon Valley Lab working with the Data Warehousing on System z Swat Team. He has almost 35 years experience working with databases with more than 27 years working with DB2. He is a sought after speaker at major international conferences and user groups, has authored numerous articles, White Papers and Redbooks, and has one of the top technical blogs on the Internet. Over his career, Willie has been an application programmer, systems programmer, DBA, consultant, IBM Senior Instructor, sales support technician, and an IBM Sales Representative.
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.