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

When? Wednesday, December 14th, 2016, 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 SQL Performance Tuning in the Digital World
  Sheryl M. Larsen, BMC Software
 
 

New access paths, size limits, and new features can change the way you look at tuning your DB2 workloads. Add the digital forces attacking our workloads and you got a recipe for disaster if you are not prepared. Come hear about some old and new tuning techniques like adding math, empty data, creative table expressions, applying hints, and profiles that can get you ahead of the learning curve. See what new attributes your SQL tuning solutions should to have to keep up with the frantic pace of business today.

Objective 1: Understand what new DB2 features will change the way we tune queries.
Objective 2: Understand what external forces will change the way we tune queries
Objective 3: Learn the 5 ways to make queries go faster
Objective 4: Learn what the long term implications are in using hints and profiles
Objective 5: Understand the attributes of a modern SQL tuning solution

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 Explain Yourself and Avoid Performance Problems
  Jim Dee, BMC Software
 
  Are you getting the most out of EXPLAIN, and are you doing everything you can to help the DB2 optimizer do its job? This presentation helps you answer these questions. IBM has made many enhancements to the EXPLAIN command and parts of DB2 around it, in DB2 10 and 11. This presentation goes into some of these changes and how you can take advantage of them to help the DB2 optimizer and get the best performance out of your DB2 applications.
 
  11:45 - 12:30 Lunch
 
  12:30 - 1:45 Save CPU with z/OS Large Page Frames and DB2 Page Fixing
  Dave Powell
 
  Save MIPS by reducing TLB misses and lower CP and zIIP CPU time from avoiding page- fix and page- unfix operations and improve response time.
 
  1:45 - 1:55 Break
 
  1:55 - 2:15 DB2 12 LOB Compression
  Daniel Kim, IBM
 
  DB2 12 delivers LOB compression through zEDC express. This session covers how this feature works and shares the latest performance evaluations on this feature.
 
  2:15 - 2:20 Break
 
  2:20 - 3:40 DB2 11 and 12 Top Performance Features
  Akiko Hoshikakwa, IBM
 
  This session covers selective DB2 11 topics and 12 system performance features. DB2 11 features include the buffer pool simulation and its usage guide. Then we will discuss key performance features in DB2 12 that you should look forward when you are planning for DB2 12 migration. DB2 12 topics include the performance improvement by exploiting larger system memory. A fast index look up in memory is automatically created to speed up random key loop up. DB2 z/OS can insert 10 million rows per second utilizing in-memory look up to avoid space search in a new insert algorithm. Just as previous versions, the range of improvement varies depending on the workload characteristics. This session will help to set the right expectation for your workloads and what actions are needed or recommended to fully utilize DB2 12 improvement.
 

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:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, December 9th, 2016.

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
Sheryl M. Larsen is a Sr. DB2 Product Specialist at BMC Software. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.
Jim Dee is a Corporate Architect in the Data Management organization in R&D at BMC Software. He is responsible for the technical content and integration of the DB2 for z/OS product lines. He has worked at BMC since 1990, mostly in DB2 Backup and Recovery, as a developer, product author, and architect, and has held his current position as Chief Architect since 2007. Prior to joining BMC Software, Jim worked at various employers in the IT industry for 16 years. He worked as an application developer, systems programmer, DBA, and vendor developer. Jim has a B.A in Mathematics with a minor in Computer Science from Queen’s University in Kingston, Ontario.
Dave Powell is a DB2 zOS Platform Engineer and a member of the Baltimore & Washington DB2 Users’ Group.
Daniel Kim is a recent graduate from Johns Hopkins University and a new hire at IBM. He is working currently under Akiko's lead in the Performance OLTP team. He is looking forward to learning more about everything there is to know about performance of DB2 and, more importantly, about customer interactions that nurture real business in large companies.
Akiko Hoshikawa is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where she leads the performance engineers and engine developers for DB2 for z/OS development. She drove performance initiated development in DB2 10, 11 and 12 to achive impressive performance improvement in each releases of DB2. She loves the hands-on working with customers, providing performance evaluation, tuning, benchmarks, designing performance features to solve customers challenges.
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.