Skip to content

Upgrading from Db2 9.7 to Db2 11.1

I know many of you are still running Db2 9.7, which was a really good solid release. We are upgrading some of our clients to 11.1.2 and found the below doc a bit disjointed but helpful. Bring back the PDFs!

Operating System Support levels for Db2 11.1 and above

This information is no longer included in the product announcement and while I am working on a clients upgrade I of course checked this for compatibility with the OS they are running. So I thought I would include the link for the rest of you since it is a bit of an effort to find…..|S006|S005|S003|S004|A002|A007|A008&mandatoryCapIds=183|25&optionalCapIds=30|341|47|17|1|20|28

Central PA DB2 User Group, 11/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 –


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




Db2 End of Support Dates

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:


DB2 11.1 IBM Db2 ebook

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:

Revised Naming for Db2 family products

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:

Understanding Db2 Mod-packs and Fixpacks

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 :