Skip to content

IDUG EMEA 20-24 Oct 19

#Db2 #IBMChampion. Check out our booth and get a t-shirt at IDUG EMEA in Rotterdam, Netherlands, Oct 20-24, 2019 idug.org/emea2019. My session is on Db2 SQL Coding Best Practices. Real world client examples will be presented and analyzed. SQL predicate Analysis and index design will be presented via Db2 explain facility. Learn how to identify suboptimal SQL and review and explain and develop a solution. You will learn a few different techniques to identify capture and tune high cost SQL. Predicate review and index redesign will be discussed.

All You Need to Know About Db2 11.5, The AI Database

My friend and Principal Offering Manager for Db2, @IBM_lindJon,  Jon Lind has a nice article on the new AI capabilities in the newly announced and available for download Db2 11.5, The AI Database. Check it out! https://www.ibmbigdatahub.com/blog/ai-database-db2-11dot5

Db2 11.5, The Hybrid Data Management and AI Database

Recently announced and available for download this week is Db2 11.5, packed with improvements to take advantage of AI and Cloud. Db2 11.5 the AI and Cloud database.

Db2 11.5 !

 

Db2 10.5 End of Support

Just want to remind everyone that 10.5 end of support is April 2020. I know there are a lot of you still on 10.5 so now is the time to plan your upgrade strategy and timeline!

https://www-01.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/8/897/ENUS918-138/index.html&request_locale=en

Questions on Data Server Manager and Db2 Edition?

Data Server Manager or DSM has come a long way and is now the tool of choice for many companies for managing Db2. I get a lot of questions on how to get it and what Db2 editions are supported. Check out Peter Kohlman’s info here and you should find what you need. https://community.ibm.com/community/user/hybriddatamanagement/blogs/peter-kohlmann/2018/08/29/using-dsm-with-bundled-copies-of-db2?CommunityKey=e0967b49-f3c2-42c0-9cca-a415e3896fb3&Tab=

Db2 Version and OS Requirements

I have lots of clients running Db2 on Windows Server 2008 R2… End of Service for Windows 2008 R2 is 1/14/2020. Db2 11.1 and above requires Windows 2012 Standard Edition or above so if you are running a Db2 10.5 on Windows Server 2008 R2 you should be making plans to upgrade to Db2 11.1 and Windows Servers 2012 Standard Edition or preferably Windows Servers 2016 Standard Edition.. Get the details for all of this at the below links:

Db2 — http://www-01.ibm.com/support/docview.wss?uid=swg27038033#1111Work

Windows — https://www.microsoft.com/en-us/cloud-platform/windows-server-2008

Mid-Atlantic Db2 User Group May 7, 2019

Don’t miss Dale McInnis’s presentation on the Db2 logger and update from Dr. John Lind on Vnext!

Register today: https://conta.cc/2UAGYWa
9am-10:30 SESSION 1
Futures (vNext coming soon!) presented by Jon Lind

10:30-1045 BREAK

10:45-12:00 SESSION 2
IBM Streams presented by Roger Rea

12-12:45 – Networking Lunch

12:45-2:00 SESSION 3
Demystifying the Db2 Logger presented by Dale McInnis

2:00- 2:15 BREAK

2:15-2:30 IDUG Overview