IBM Db2 & Db2 on Cloud
Technical (Lab) Advocate Newsletter
Announcement - IBM Db2 Version 11.5 Modification Pack 6 (v188.8.131.52) is Now Available!
Db2 184.108.40.206 Mod Pack Summary of Changes: https://ibm.co/3h0Mzxq
Db2 220.127.116.11 Download Page: https://ibm.co/3h0Mzxq
Db2 18.104.22.168 Full APAR Fix List: https://www.ibm.com/
Db2 22.214.171.124 Client Drivers Download Page: https://www.ibm.com/support/
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 126.96.36.199.
• 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.
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.
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.
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.
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!
Collaborate - Join the Db2 DISCORD Server
Join the new Db2 DISCORD discussion server! Chat, Discuss, and Collaborate with Db2 users and developers worldwide.
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.
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.
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)
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?!?!
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/
• 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.
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.
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.
Db2 Community - Follow the Db2 Developer and Administrator Community
Share. Solve. Do More.
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/
Wednesday, 23 June 2021
Posted by David Sciaraffa at Wednesday, June 23, 2021