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 – odessa.fennen@highmark.com
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
I get a lot of questions from customers regarding Db2 EOS dates so I thought I would post an update to the link, see below:
If you haven’t been using DB2 11.1 and are just getting started or need a refresher on all the goodies included in it, download the ebook by longtime Db2 Lab guru George Baklarz at: https://ibm.ent.box.com/v/DB2v11eBook/file/98872949530
Getting used to the new Db2 naming can be quite confusing as there are many different locations on the web where it is discussed and blogged about. Use the IBM announcement to sift through the fog. It can be found here: https://www-01.ibm.com/common/ssi/cgi-bin/ssialias?htmlfid=877/ENUSZP17-0457&infotype=AN&subtype=CA
Mod-packs have been introduced in Db2 11. To understand the terminology and to differentiate between the two and know what the heck is going on, learn all about them at this link : http://www-01.ibm.com/support/docview.wss?uid=swg22003131
With the rebranding of DB2 recently, you may want to become familiar with the new edition names and capabilities. Note DB2 Express is no longer an offering. See the details of the new editions here: https://www.ibm.com/vi-en/marketplace/ibm-db2-direct-and-developer-editions/purchase#product-header-top
DB2 is now Db2….find out about the rebranding here….Db2
https://www-03.ibm.com/press/us/en/pressrelease/52682.wss
Before I became an expert on DB2 LUW I was a DB2 for z/OS Database Administrator and DB2 systems programmer. I see lots of questions lately from current DB2 for z/OS DBAs picking up responsibility for a DB2 LUW installation and they ask where they should start, that because it is on LUW they must do something different. Well it is really quite simple, all the things that are important on the mainframe DB2 are as important on DB2 LUW. Things like reorgs, backups, monitoring, SQL tuning, support of application developers, etc are the same, just how you do it on DB2 LUW might be different. So it is easy to learn how to do a reorg, how to determine if a reorg is required, what type of backup to use, and how to monitor SQL, just the interfaces are different but all the things that must be done on z/OS must be done on LUW. After you learn the way to do these things on LUW then and only then start to learn about the LUW Operating Systems and the various scripting languages you might need. Lots of folks get a mental block about UNIX or Linux and can’t see the forest because of the trees…..So, in closing, learn how to do all the DB2 important things on DB2 LUW then worry about learning UNIX or Linux.
I’ve been seeing a lot of questions in various forums regarding the operations of HADR. The best source for info is the HADR wiki on Developer works at https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/page/HADR%20Tutorial
This is good news for the DB2 9.7 install base which is extensive….See the details at
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 