#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.
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
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.
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!
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=
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
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
