IBM Db2 & Db2 on Cloud Technical (Lab) Advocate Newsletter April 2021 | |||
Announcement - IBM Db2 Version 11.5 Modification Pack 5 Fix Pack 1 (v11.5.5.1) is Now Available! Db2 11.5.5 Mod Pack Summary of Changes: https://ibm.co/2NHllxv Db2 11.5.5.1 Download Page: https://www.ibm.com/support/ Db2 11.5.5.1 Full APAR Fix List: https://www.ibm.com/support/ Db2 11.5.5.1 Client Drivers Download Page: https://www.ibm.com/support/ Some Key Highlights: • Numerous APAR fixes. Webinar - Db2 Latest News The evolution of Hybrid Cloud, Containers, Kubernetes , AI/ML and the explosion of new data formats like JSON or Graph has left CIOs with a search of Polyglot or Universal Databases that satisfy their enterprise needs. Driven by this demand IBM Db2 LUW has evolved into Universal Database providing wide range of deployment patters and advanced capabilities that satisfy modern age requirements. Join Piotr Mierzejewski (Executive Director of Development for IBM Db2, Db2 Big Sql and Data Virtualization) for this exciting session filled with latest news on Db2 v11.5 features and capabilities Register Now: Friday May 7, 2021, 11am EST - https://register.gotowebinar. Conferences & Summits & User Groups Over the years, IDUG has become known for hosting dynamic conferences packed with the cutting-edge content you need. This year will be no exception. Be sure to make your plans to attend. With great sessions, keynote speakers, workshops, and more, you won't want to miss this event. Upcoming Events: https://www.idug.org/events/ • IDUG North America Conference - June 7–16, 2021 • IDUG EMEA Conference - Edinburgh - October 17-21, 2021
• Hundreds of technical sessions across three tracks • Live presentations & custom content • Educational sessions by experts from IBM Labs • Discussion panels with Db2 Lab experts • Live Q&A • Presentation slide downloads with notes • A certification or proctored badging voucher • A one-year IDUG premium membership Upcoming Regional User Groups: Find Other Local Db2 User Groups in your area: https://www.idug.org/rug Webinar - Unlock your Db2’s potential with Cloud Pak for Data Tanmay Sinha (Program Director, IBM Data & AI) - The importance of data has now been the topic of discussion for more than two decades, it is hard to argue against the benefits of using data to make decisions. Our past actions help us better understand the nature of the problem at hand - regardless of industry. The AI applications take that process to the next level by automating the most crucial part - actual decision making. Learn how Db2 and Cloud Pak for Data combined can help fuel your journey to new and exciting use cases from your existing data - all the while saving you real money. Register Now: Wednesday, April 21, 2021, 10pm EST - https://bit.ly/39wPQS5 Announcement - Db2 Developer Enablemen - New VS Code Extension, New Django 3.1 Support - Db2 Connect for Visual Studio Code version 2.1.3: https://bit.ly/3dmQBOL - IBM DB2 Driver for the Django added support for Django 3.1:https://github.com/ibmdb/ Webinar - Db2 Introduction to Query Optimization John Hornibrook (Senior Technical Staff Member, IBM Db2) - Optimal query access plans are essential for good data server performance. The optimizer is a very sophisticated component of the data server, tasked with the challenging job of choosing good access paths for the variety of features and table organizations supported by Db2. Attend this session to get an overview of how the optimizer works and to get some tips on how to understand its decisions and control its behavior Register Now: Friday April 9, 11am EST - https://register.gotowebinar. Health Check - Evaluating the Health of a Db2 Database Every database can be improved upon. Sometimes a second set of eyes finds problems that we don't see when we work with a database every day. What should you check when evaluating the health of your database or a co-worker's database? How do you get all of the information you need? Join Ember Crooks (IBM Gold Consultant) to see what she looks at when doing a health check and why https://www.dbisoftware.com/ Blog - Db2 Python Programing, IBM_DB vs IBM_DB_DBI John Maenpaa provides an overview of the Python programming with IBM Db2, providing useful information and examples. Getting Started with the IBM_DB package: https://bit.ly/3dC3bKj Intro to John's DB2_HELPERS package: https://bit.ly/3waEA7P IIBM_DB vs BM_DB_DBI: https://bit.ly/3uf9IBf Blog - Enterprise-Grade Machine Learning at Scale with IBM Db2 As ML becomes mainstream for the Enterprise use cases, more and more companies will try to create AI applications. When working with large data, it’s impractical to expect that everyone will have infrastructure for processing the data for AI model development and deployment. With IBM Db2’s in-database ML capabilities, Db2 users can have a head start in building and deploying their AI models near the data and easily integrate the models with their existing business applications. In the end, this will help Db2 customers save on IT costs and accelerate the process of turning data into assets. https://bit.ly/31zo4Qz Blog - Db2 -Types of I/O Martin Hubel (IBM Gold Consultant) - Understanding the types of I/O is important background information for every tuning effort. https://bit.ly/3sDd94k Reminder - End of Support (EOS) For Db2 Version 11.1 is April 30, 2022 Effective April 30, 2022, IBM will withdraw support for Db2 Version 11.1. Extended support will be available beyond this date. https://www.ibm.com/support/ ______________________________ Support - Overview of IBM Support Framework, Guidelines, and Escalation methods Please review the IBM Support guidelines for a description of the IBM support framework; how to get setup for IBM support; methods to help yourself via watson search; and how to escalate a support case. https://www.ibm.com/support/ Roadmaps - Db2 Development Roadmaps are Accessible to Everyone Curious about the feature and function committed to upcoming versions of Db2? You can now explore live development roadmaps for Db2 and the IBM Analytics family of products. This content is live and subject to change. http://ibm.biz/ Db2 Community - Follow the Db2 Developer and Administrator Community Share. Solve. Do More. https://developer.ibm.com/ Follow-us! - Stay up to date on the latest news from the Db2 team IBM Support Community: (https://www.ibm.com/ IBM DB2 DeveloperWorks (http://ibm.co/3ck2OTH) IBM Data&AI Youtube Channel (https://www.youtube.com/user/ developerWorks Answers (forum): https://developer.ibm.com/ | |||