Central PA Regional DB2 User Group, November 30, 2017

Philip Gunning

Central PA Regional DB2 User Group, November 30, 2017
Central PA Regional DB2 User Group

Date: Thursday, November 30, 2017

Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill,
PA 17011

Cost: FREE

Reservations: Email: Odessa Fennen - <mailto:[login to unmask email]>
[login to unmask email]



Agenda for November 30, 2017

8:30-9:00 Breakfast & Announcements

Sponsored By Gunning Technology Solutions



9:00-10:15 "DB2 11.1 - An Update on Where We Are and Where We Are Going"

Presenter: Mike Winer, IBM

This session will provide an overview of Db2 and all the significant
additions we've added in Db2 11.1 (include mod levels 1 and 2). Use cases
and performance results will be explained. Following the summary of new
features and improvements delivered in Db2 11.1, we will briefly cover what
direction the product taking. The roadmap discussion will include not only
short and medium term directions, we will discuss additional strategic and
longer term themes.

10:15-10:30 Break



10:30-11:45 "SQL Tuning in the Digital World"

Presenter: Sheryl Larsen, BMC

The Digital World includes all kinds of transactions most of which contain
SQL. Trapping and fixing nonperforming SQL has gotten more complicated, or
has it? The speed at which SQL performance problems need to be resolved has
shrunken to .1ms or 0 - meaning that they should never happen. Come learn
tips and techniques that can assist you in today's Digital World.



Objective 1: When your monitors find this, what should you do?

Objective 2: What crazy SQL can do for you!

Objective 3: Finding the most expensive query running in the peak

Objective 4: Some old and new tuning techniques

Objective 5: Monetize your MLC savings with compares.



11:45 -1:00 Lunch - Sponsored By: Gunning Technology Solutions



1:00 - 2:15 "Db2 11.1 Performance and Tuning - (LUW)"

Presenter: Phil Gunning, Gunning Technology Solutions

This session will highlight and present monitoring in DB2 11.1 with emphasis
on what has changed from 9.7 to DB2 11.1. In addition, an overview of DB2
provided monitoring facilities will be presented with emphasis on db2top
(for both Linux, UNIX and Windows) and an update of the MONREPORT reporting
package along with a discussion on using the MON_GET table functions and
administrative views. Upon completion of this session, you will be familiar
with the latest in DB2 11.1 monitoring and be able to put them to use in
your organization.



2:15 - 2:30 Closing







IBM Champion for Analytics

Certified Information Systems Security Professional(CISSP)

Certification Number 539059

Certified Advanced DB2 DBA v10.5

Certified Database Adminstrator, DB2 11.1

IBM DB2 LUW Support Page --
https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.ht
ml

Skype: DB2LUW

Twitter: DB2LUW

Direct +1.610.451.5801

IDUG DB2-L Hall of Fame

http://www.philipkgunning.com/AskMrDB2 www.philipkgunning.com

IBM Business Partner