San Francisco DB2 User Group Meeting
Free
San Francisco DB2 User Group Meeting

San Francisco DB2 User Group Meeting

Event Information

Share this event

Date and Time

Location

Location

IBM

4000 Executive Parkway

Conf Room 340

San Ramon, CA 94583

View Map

Friends Who Are Going
Event description

Description

The first meeting of 2017 will feature two distinguished IBM speakers – Adrian Burke and Jase Alpers.

Come out and network with your peers and gain valuable information to make your environment run better.

Here is our agenda for the February 28th meeting:
========================================================
8:30 to 9:00 am Check in and continental breakfast
----------------------------------------------------------------------------------------------------
9:00 to 10:15 am - Adrian Burke, IBM
Avoiding L2 Performance PMRs
---------------------------------------------------------------------------------------------------
10:15 to 10:30 am – Break
---------------------------------------------------------------------------------------------------

10:30 to 11:45 am - Adrian Burke, IBM
zIIP Experiences: Exploitation Not Abuse

---------------------------------------------------------------------------------------------------
11:45 to 12:30 pm Lunch Provided

---------------------------------------------------------------------------------------------------
12:30 to 12:45 am - Clif Burnes, IBM
Announcements

---------------------------------------------------------------------------------------------------
12:45 to 2:00 pm - Jase Alpers, IBM
Runstats Challenges for Optimal Query Performance
---------------------------------------------------------------------------------------------------
2:00 to 2:15 pm - Break
---------------------------------------------------------------------------------------------------

2:15 to 3:30 pm - Jase Alpers, IBM
Tuning Queries Like a DB2 Developer
---------------------------------------------------------------------------------------------------

3:30 pm - Closing
---------------------------------------------------------------------------------------------------

Speaker Bios:

Adrian Burke, IBM
Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab, lead by John Campbell. In this role as a technical advocate for DB2 for z/OS Adrian conducts consulting and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Previously, as a DB2 Advisor, Adrian supported hundreds of DB2 for z/OS customers from a technical sales perspective delivering consultative and educational workshops. Adrian has spoken at numerous DB2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 performance.


Jason Alpers, IBM

Jase Alpers is part of the DB2 for z/OS optimizer development team out of the IBM Silicon Valley Lab. He is a frequent speaker on DB2 query optimization with more than 15 years’ experience with DB2 in application development, consulting, DB2 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 driving improvements to DB2 query optimization as well as deep dive analysis and resolution of SQL performance problems. In the last several releases of DB2, Jase has designed and delivered enhancements to automate identification and management of which statistics to collect for optimal query performance.

Abstracts:

Avoiding L2 Performance PMRs:
Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today's diverse environments. Everything from CEC capacity, LPAR utilization, real/virtual storage, WLM settings, PARMLIB members, and DB2 parameters can play a part in performance degradation. Wouldn't it be nice if there were some tools (no-charge ones at that) which could quickly guide you in the direction of the root cause? Not just in text format but with graphs and trending lines that can visually depict the bottle neck and help educate management and colleagues. Many man hours have been wasted studying the effects of a system slowdown. This presentation will walk through a methodology for avoiding these issues.

zIIP Experiences: Exploitation Not Abuse:
With the constant focus on controlling MIPs consumption on today's mainframe, IT staffs are being pressed to get every cycle possible out of their System z Integrated Information Processor (zIIP) specialty engines and the now defunct System z Application Assist Processors (zAAP). DB2 for z/OS and related processes that run on System z can take advantage of these processors, and will be covered in depth during the presentation. There are two methodologies involved in maximizing off-load potential: 1) ensure everything that is currently eligible is getting access to zIIP cycles and tune appropriately 2) then look at other avenues to increase potential off-load. We will delve into both of these to investigate maximum zIIP exploitation and discuss the reality of current customer environments. We also need to understand what new functions are being offloaded in each release up thru DB2 12, and what the demise of the zAAP means for us.

Runstats Challenges for Optimal Query Performance
Accurate and relevant statistics are the basis of reliable good query performance. How do I identify the important statistics? How do I manage statistics collection? What new features does DB2 for z/OS provide to help with runstats challenges? In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.

Tuning Queries Like a DB2 Developer
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 optimizer's expectations and reality. In this session, we'll walk through the process used at the lab to identify and resolve access path performance problems. We'll discuss the primary reasons optimizer "gets it wrong" along with options to correct the poor performance.

Share with friends

Date and Time

Location

IBM

4000 Executive Parkway

Conf Room 340

San Ramon, CA 94583

View Map

Save This Event

Event Saved