IBM Db2 & Db2 on Cloud Technical (Lab) Advocate Newsletter - December 2021

IBM Db2 & Db2 on Cloud Technical (Lab) Advocate Newsletter December 2021
	Announcement - IBM Db2 Version 11.5 Modification Pack 7 (v11.5.7.0) is Now Available! Db2 11.5.7.0 Mod Pack Summary of Changes: https://www.ibm.com/docs/en/db2/11.5?topic=new-1157 Db2 11.5.7.0 Download Page: https://www.ibm.com/support/pages/node/6524304 Db2 11.5.7.0 Full APAR Fix List: https://www.ibm.com/support/pages/fix-list-db2-version-115-linux-unix-and-windows Db2 11.5.7.0 HIPER and Security APARs: https://www.ibm.com/support/pages/node/6242296 Some Key Highlights:   • Remote storage (Cloud Object Storage) improvements and lifted restrictions.  • Remote storage support for log archiving and retrieving operations.  • Improved resilience through control file mirroring.   • Improved performance when inserting data into column-organized tables, using trickle-feed inserts.  • Federation pushdown capability for running fetch first n row (FFNR) queries against Snowflake data sources.  • Federated procedure support in fenced wrappers.  • Improve pushdown analysis on the blank-padded string comparison semantics.  • Added support for PPCLE platform for Automated HADR failover with Pacemaker.   • Improved HADR database hang detection on AIX platforms.   • Pacemaker software refresh.  • Improved HADR database hang detection on AIX platforms  • ZLIB compression for backup and log file compression   • The ADMIN_MOVE_TABLE procedure is now able to move tables having an index with an expression-based key.  • Code signing (Linux® and Unix) - All Db2 installation image files will be signed by IBM® to protect its integrity and authenticity.  • New KMIP configuration parameters PRIMARY_SERVER_HOST and PRIMARY_SERVER_KMIP_PORT  • RENAME TABLE statement is now extended to support the renaming of tables with indexes on an expression.  • 196 new APAR fixes.  • and more!.... Webinar - Db2 BLU Acceleration - Updates & Improvements Satya Krishnaswamy (Program Director, IBM), provides an update on the latest DB2 BLU improvements and enhancements, including Catalog enhancements, BLU storage and compression enhancements, and Runtime features. https://www.dbisoftware.com/blog/db2nightshow.php?id=845 Support  - New 'Escalate Case' Button Escalation of Support Cases can now be accomplished through the new 'Escalate Case' button within the Status window of the case.  Please continue to follow IBM Support guidelines for support expectations: https://www.ibm.com/support/pages/ibm-support-guide   Demo - Db2 REST: From Movie Recommendation to… Shazam!? Tanmay Bakshi (Software Engineer, IBM) provides a demo utilizing Db2 REST, Graph, and other Db2 features to build some very interesting applications. https://www.dbisoftware.com/blog/db2nightshow.php?id=841 Badges & Certifications - Db2 11.5 Certifications IDUG and IBM have partnered to develop exams for certification and proctored badges. These exams are typically available at IDUG Conferences, but you also have the option to take these exams outside of IDUG events. For more information, see: https://www.idug.org/learn/badges-certification Tools - Database Conversion Workbench (DCW) v5.0.1! The IBM Database Conversion Workbench (DCW) provides an end-to-end solution through UI tooling to facilitate the conversion of Oracle & Teradata databases to DB2 on premise and cloud databases. DCW provides features such as: SQL evaluation & effort estimation, SQL editing & debugging, SQL conversion & deployment DCW 5.0.1 Download: https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-idcw DCW Community: https://ibm.co/3DCPc1x DCW Tutorials: https://ibm.co/3ECGvFH Db2 on Cloud - Client Case Studies - Valor Holdings Valor Holdings - Achieves dramatically improved performance by migrating all sales data and analysis to IBM Db2 Warehouse on Cloud Valor Holdings, one of Japan’s leading supermarket chains, decided to launch a membership card scheme, and needed to analyze sales data to better serve consumers. The company moved a database of over ten billion transactions to IBM® Db2® Warehouse on Cloud, enabling high-performance analytics to support operations. https://www.ibm.com/case-studies/Valor-Holdings Client Webinar - Lessons Learned: Building Db2 HADR Clusters on AWS Philip Nelson (Lloyds Bank/ ScotDB), provides a small intro to Cloud technologies, describes ways to run Db2 on the cloud, why to roll-your-own on to of IaaS, lessons learned about features while setting up on AWS. https://www.dbisoftware.com/blog/db2nightshow.php?id=843 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/calendar • IDUG North American Tech Conference - July 9-14, 2022 - Boston, MA Upcoming Regional User Groups: Find Other Local Db2 User Groups in your area: https://www.idug.org/rug 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/pages/db2-distributed-end-support-eos-dates   _____________________________________________________________________________________________ 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/pages/ibm-support-guide 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/AnalyticsRoadmaps Follow-us! - Stay up to date on the latest news from the Db2 team IBM Support Community: https://www.ibm.com/mysupport/ IBM DB2 DeveloperWorks: http://ibm.co/3ck2OTH IBM Data&AI Youtube Channel: https://www.youtube.com/user/ibmbigdata developerWorks Answers (forum): https://developer.ibm.com/answers/topics/

 

IBM Db2 - Technical (Lab) Advocate Announcement - End of Continuing Support for old versions of Db2 (7.2 - 9.5)

IBM Db2 & Db2 on Cloud End of Continuing Support for Db2 7.2 - 9.5 Announcement Oct 2021
	On October 1, 2021, IBM announced changes to the Db2 Continuing Support program. For versions 9.5 and earlier, Continuing Support will not be provided after September 30th, 2022. The technical note can be found: https://www.ibm.com/support/pages/node/6467345. We decided to make this change because most vendors are no longer supporting the hardware, OS or applications being used with these older Db2 versions, which presents technical and non-technical risks outside of the core database engine. What is changing on September 30, 2022: -- Support tickets, even for non-defect issues, for Db2 versions 9.5, 9.1, 8.2, 8.1 and 7.2 will no longer be accepted by IBM support. -- Online knowledge bases for these versions may not be maintained or available. What is NOT changing on September 30, 2022: -- You retain the right to run the unsupported versions of Db2 in your environment. -- Nothing is changing with respect to your entitlement and you will not be forced to upgrade. -- No changes are being made to regular or extended support programs. We value your loyalty to Db2 and want to help you transition to supported versions. A variety of options are available to help upgrade and modernize your Db2 estate. These include free modernization workshops as well as services to assess, plan, or execute a version upgrade, or to fully modernize to a container-based infrastructure. Your options moving forward: 1. Containerization Containerize Db2 directly on RedHat OpenShift or on Cloud Pak for Data and upgrade to the latest Db2 version in the process. 2. Upgrade standalone Upgrade to the latest Db2 version to access better performance, easier administration, better security, as well as newer features such as graph and machine learning. 3. SaaS Move to Db2 on Cloud, our fully managed SaaS solution for transactional and analytical workloads and the default cloud database for Cloud Pak for Data as a service. If you would like to setup a call to discuss this announcement and any questions you have as well as your upgrade and modernization strategy, please let me know and I will connect you with an IBM rep. _____________________________________________________________________________________________ Some additional resources you may find useful: Webinar - The Latest News from Db2 Db2 has come a long way since being one of the first Relational Database Management Systems. Explore the containerization of Db2 and optimization on RedHat OpenShift. New exciting features like Db2 Graph, REST APIs and enhanced ML capabilities with PythonUDF and in-DB Machine Learning. Join Piotr Mierzejewski (Director, Db2 Developemnt) for an exciting overview. https://www.dbisoftware.com/blog/db2nightshow.php?id=834 Classic Webinar  - Db2 Upgrade Best Practices and Tips! Melanie Stopher provides the complete scoop on upgrading DB2.You will not only learn best practices, but you will also learn some very wise and insightful tips, plus some "Hidden Gems" - - the extra "smaller" stuff that isn't making the headlines! https://www.dbisoftware.com/blog/db2nightshow.php?id=694 Webinar Series  -  Db2 Offering Management Webinar Series (including Db2 v11.5.6 Deep Dive) What's New in Db2 11.5.6 Join this exciting session to learn of the latest advancements in IBM Db2.v11.5.6, from core engine enhancements for OLTP and Warehouse, to Graph to Object Store support to Db2 solidifying its leadership in Containers. This session will paint a picture of the next generation of RDBMs. This session will be good for DBA’s, Developers, Kubernetes Enthusiasts, Business users. https://www.ibm.com/events/event/pages/ibm/0ue4vrmb/1581037797007001PJAd.html Db2 Modernization Join us to learn about the latest capabilities that enable Db2 to be the best database for supporting mixed workloads. Mixed workloads are required by modern applications such as web applications, machine learning applications, graph applications, and so on. For such workloads, Db2 has invested considerable effort in NoSQL workloads, JSON support, in-database machine learning, graph analytics, and more. This session will take deep dive into each of these enhancements and elaborate on how they can accelerate and support your modern applications. The session will also unveil for the first time, the new UI for Graph analytics with a live demo. This session will be good for DBA’s, Developers, Kubernetes Enthusiasts, Business users. https://www.ibm.com/events/event/pages/ibm/xq2njtmb/1581037797007001PJAd.html Db2 Resilience and Performance Join us to learn about the latest updates that make Db2 more resilient and performant. Resilience and Performance has always been a strong focus in our product development. This release includes updates to Db2 Purescale, further enhancements in the delivery of Pacemaker (Replacement for TSA). We will also cover updates coming out in backup functionality and Encryption. https://www.ibm.com/events/event/pages/ibm/y7qynvmb/1581037797007001PJAd.html What's New in Db2 Tooling Join us to learn about the new and latest updates in Db2 tools ecosystem. In this session, for the first time we will unveil the brand-new migration tool that will enable you to move your on-prem Db2 data to the cloud seamlessly. We will cover the overview of new capabilities delivered in Db2 Data Management Console for Db2 Admins. This session is loaded with several product demos focusing on migration and database administration use cases. https://www.ibm.com/events/event/pages/ibm/paxz7dmb/1581037797007001PJAd.html Db2 Managed Cloud Products Join us to learn about the new and latest updates in the Db2 cloud ecosystem. In this session, we will cover new feature releases such as Db2 DR and Db2 warehouse replication. We will also address important security integrations like Guardium and Azure AD. Finally, we will cover the IBM Cloud Pak for data SaaS platform that is well integrated with Db2 and helps to deliver broader use-cases. This session will show live demos of latest features that will help you make informed decision for you data cloud strategy. You don’t want to miss this session! https://www.ibm.com/events/event/pages/ibm/mriqu6mb/1581037797007001PJAd.html Db2 Packaging and Pricing This session will cover the upcoming editions of Db2, its pricing and entitlement migration paths from previous versions to new versions.  https://video.ibm.com/recorded/128924634 Db2 Cloud as a Service This session  covers both Db2 services - Db2 on Cloud (OLTP) and Db2 Warehouse on Cloud. We will also discuss the strategy and roadmap so this will be a great session if you are strategizing to move to Db2 on Cloud soon or are already on it. https://video.ibm.com/recorded/128924617 Containerization and Webinar - New IBM Db2 Click-to-Containerize utility IBM Db2 Click-to-Containerize is a new application designed to help users move from a traditional Db2 deployment to a containerized Linux cluster. This tool is currently being offered as a technical preview and is not intended for production environments. Details: https://www.ibm.com/support/pages/node/6416561 Register for Webinar on Friday Mar 12: https://register.gotowebinar.com/register/4095856048584412173 Webinar - Intro to Db2 Managed Service for Enterprises Learn about managed Db2 service on cloud for OLTP workloads. With Managed Database as a Service, users can focus on applications, thus leaving the management to the service provider. IBM Db2 on Cloud Managed Service's robust features provide the depth to handle customer workload requirements such being highly available, scalable, on demand, and being secure. https://video.ibm.com/playlist/633288 Webinar - Intro to Db2 Warehouse on Cloud Db2 Warehouse on Cloud is the Elastic Software-as-a-Service (SaaS) offering from IBM that runs on multiple cloud platforms. Get to know the offering and learn about the new and upcoming features that makes Db2 Warehouse on Cloud support larger warehouse environments with better Disaster Recovery (DR) capabilities. https://video.ibm.com/recorded/128072408 _____________________________________________________________________________________________ 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/pages/ibm-support-guide 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/AnalyticsRoadmaps Db2 Community - Follow the Db2 Developer and Administrator Community Share. Solve. Do More. https://developer.ibm.com/data/db2/ Follow-us! - Stay up to date on the latest news from the Db2 team IBM Support Community: (https://www.ibm.com/mysupport/) IBM DB2 DeveloperWorks (http://ibm.co/3ck2OTH) IBM Data&AI Youtube Channel (https://www.youtube.com/user/ibmbigdata) developerWorks Answers (forum): https://developer.ibm.com/answers/topics/

IBM Db2 - Technical (Lab) Advocate Newsletter - June 2021

IBM Db2 & Db2 on Cloud Technical (Lab) Advocate Newsletter June 2021
	Announcement - IBM Db2 Version 11.5 Modification Pack 6 (v11.5.6.0) is Now Available! Db2 11.5.6.0 Mod Pack Summary of Changes: https://ibm.co/3h0Mzxq Db2 11.5.6.0 Download Page: https://ibm.co/3h0Mzxq Db2 11.5.6.0 Full APAR Fix List: https://www.ibm.com/support/pages/node/1102545 Db2 11.5.6.0  Client Drivers Download Page: https://www.ibm.com/support/pages/node/323035 Some Key Highlights:   • Improved high availability with Advanced Log Space Management (ALSM).  • Graph modeling and analysis of Db2 data using IBM Db2 Graph.    • Technical preview update to Machine Learning Optimizer.  • ADMIN_MOVE_TABLE performance improvement for column-organized tables.  • Integrated Pacemaker installation.  • Enhanced resiliency for automated failover to HADR Standby on Linux on-premises non-containerized cloud deployments with Pacemaker.  • Improved primary HADR hang detection for both Tivoli SA MP and Pacemaker HADR deployments.  • NX842 compression can be used in conjunction with encryption.  • CLI driver enhancements, and IBM Data Server Driver for JDBC and SQLJ enhancements.  • Monitoring elements to report peak estimated and actual shared sort memory consumption by any activity in a service class or workload.  • Security enhancement for Hostname validation for TLS connections  • Spacial enhancements: Support for aggregate functions; Support for subset of GeoJSON, and others...  • Workload Manager enhancements: Activity sort memory limits; Enablement of Adaptive Workload Manager.  • 242 new APAR fixes since 11.5.5.1.  • and more!.... Webinar Series  - #1 What's New in Db2 11.5.6 Join this exciting session to learn of the latest advancements in IBM Db2.v11.5.6, from core engine enhancements for OLTP and Warehouse, to Graph to Object Store support to Db2 solidifying its leadership in Containers. This session will paint a picture of the next generation of RDBMs. This session will be good for DBA’s, Developers, Kubernetes Enthusiasts, Business users. https://www.ibm.com/events/event/pages/ibm/0ue4vrmb/1581037797007001PJAd.html Webinar Series  - #2 Db2 Modernization Join us to learn about the latest capabilities that enable Db2 to be the best database for supporting mixed workloads. Mixed workloads are required by modern applications such as web applications, machine learning applications, graph applications, and so on. For such workloads, Db2 has invested considerable effort in NoSQL workloads, JSON support, in-database machine learning, graph analytics, and more. This session will take deep dive into each of these enhancements and elaborate on how they can accelerate and support your modern applications. The session will also unveil for the first time, the new UI for Graph analytics with a live demo. This session will be good for DBA’s, Developers, Kubernetes Enthusiasts, Business users. https://www.ibm.com/events/event/pages/ibm/xq2njtmb/1581037797007001PJAd.html Webinar Series  - #3 Db2 Resilience and Performance Join us to learn about the latest updates that make Db2 more resilient and performant. Resilience and Performance has always been a strong focus in our product development. This release includes updates to Db2 Purescale, further enhancements in the delivery of Pacemaker (Replacement for TSA). We will also cover updates coming out in backup functionality and Encryption. https://www.ibm.com/events/event/pages/ibm/y7qynvmb/1581037797007001PJAd.html Webinar Series  - #4 What's New in Db2 Tooling Join us to learn about the new and latest updates in Db2 tools ecosystem. In this session, for the first time we will unveil the brand-new migration tool that will enable you to move your on-prem Db2 data to the cloud seamlessly. We will cover the overview of new capabilities delivered in Db2 Data Management Console for Db2 Admins. This session is loaded with several product demos focusing on migration and database administration use cases. https://www.ibm.com/events/event/pages/ibm/paxz7dmb/1581037797007001PJAd.html Webinar Series  - #5 Db2 Managed Cloud Products Join us to learn about the new and latest updates in the Db2 cloud ecosystem. In this session, we will cover new feature releases such as Db2 DR and Db2 warehouse replication. We will also address important security integrations like Guardium and Azure AD. Finally, we will cover the IBM Cloud Pak for data SaaS platform that is well integrated with Db2 and helps to deliver broader use-cases. This session will show live demos of latest features that will help you make informed decision for you data cloud strategy. You don’t want to miss this session! https://www.ibm.com/events/event/pages/ibm/mriqu6mb/1581037797007001PJAd.html Collaborate  - Join the Db2 DISCORD Server Join the new Db2 DISCORD discussion server! Chat, Discuss, and Collaborate with Db2 users and developers worldwide. https://discord.gg/pAWAGs73zH Technotes - Guides to Querying various data sources via Federation   How to query the data from Salesforce via JDBC connection in Federation Server?  How to query the data from Google BigQuery via JDBC connection in Federation Server?  How to query the data from Amazon S3 via JDBC connection in Db2 Federation Server?  How to query the data from Amazon Redshift via JDBC connection in Db2 Federation Server?  How to query the data from RESTful service via JDBC connection in Federation?  How to query values from Snowflake via JDBC connection in Db2 Federation Server?  How to query Microsoft SQL Server data source by using Federation Server through JDBC Driver  How to query IBM Data Virtualization Manager (DVM) data source using Federation Server through JDBC driver  How to query Db2 for z/OS data source using Federation Server through JDBC driver  How to query Apache Hive data source using Federation Server through JDBC driver  How to query MySQL Enterprise Edition data source using Federation Server through JDBC driver  How to query PostgreSQL data source using Federation Server through JDBC driver  How to query Greenplum data source using Federation Server through JDBC driver   How to query SAP HANA data source by using Federation Server through JDBC driver  How to query MariaDB data source using Federation Server through JDBC driver  How to query MySQL Community Edition server using Db2 Federation through ODBC driver?  How to query values from Snowflake via ODBC connection in Federation Server?  How to tune DB2_FMP_COMM_HEAPSZ for federation FMP  How to query data on CouchDB via Db2 Federation  How to query data From Multiple Flat Files Using Db2 Federation Server? Tutorials - IBM Db2 Big SQL Learn more about IBM Db2 Big SQL and the IBM Big Data and Analytics Platform. Watch a video, read a solution brief, take a product test drive or download the free trial edition.     • Leveraging Your Db2 Skills with Big Data     • IBM Db2 Big SQL Product Tour     • IBM Db2 Big SQL Demos  Webinar - Analyze Data with the New Db2 Graph, and Train an ML Model using Db2 on Cloud Tanmay Sinha (IBM Program Director) and Nidhi Bhatnager (Product Manager) provide an overview and tutorial of data analysis using the New Db2 Graph, and a tutorial of of training a machine learning model using Db2 on Cloud. https://www.dbisoftware.com/blog/db2nightshow.php?id=836 Webinar - The Latest News from Db2 Db2 has come a long way since being one of the first Relational Database Management Systems. Explore the containerization of Db2 and optimization on RedHat OpenShift. New exciting features like Db2 Graph, REST APIs and enhanced ML capabilities with PythonUDF and in-DB Machine Learning. Join Piotr Mierzejewski (Director, Db2 Developemnt) for an exciting overview. https://www.dbisoftware.com/blog/db2nightshow.php?id=834 Classic Webinar - High-Impact Performance Tuning Tips for DB2 Want to make your OLTP databases run faster? Ember Crooks (Gold Consultant) offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD) https://www.dbisoftware.com/blog/db2nightshow.php?id=646 Classic Webinar - DB2 LUW Security & Auditing Melanie Stopfer (IBM Db2 Consultant) gives the complete scoop on DB2 LUW auditing how-to's, best practices, and some gotchas! You'll learn advice on DB2 LUW security too! And, hey, who wants to be in the news for a data breach or the victim of identity theft?!?! https://www.dbisoftware.com/blog/DB2NightShowNews.php?id=655 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/calendar • IDUG EMEA Conference - Edinburgh - October 17-21, 2021   Upcoming Regional User Groups: Find Other Local Db2 User Groups in your area: https://www.idug.org/rug 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/pages/db2-distributed-end-support-eos-dates   _____________________________________________________________________________________________ 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/pages/ibm-support-guide 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/AnalyticsRoadmaps Db2 Community - Follow the Db2 Developer and Administrator Community Share. Solve. Do More. https://developer.ibm.com/data/db2/ Follow-us! - Stay up to date on the latest news from the Db2 team IBM Support Community: (https://www.ibm.com/mysupport/) IBM DB2 DeveloperWorks (http://ibm.co/3ck2OTH) IBM Data&AI Youtube Channel (https://www.youtube.com/user/ibmbigdata) developerWorks Answers (forum): https://developer.ibm.com/answers/topics/