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

IBM Db2 & Db2 on Cloud Technical (Lab) Advocate Newsletter June 2020

Announcement - IBM Db2 Version 11.5 Modification Pack 4 ('Nebula') is Now Available! Mod Pack Summary of Changes: https://ibm.co/2NHllxv Db2 11.5.4.0 Download Page: https://www.ibm.com/support/pages/node/6241724 Db2 11.5.4.0 Full APAR Fix List: https://www.ibm.com/support/pages/node/1102545 Db2 11.5.4.0 Client Drivers Download Page: https://www.ibm.com/support/pages/node/323035 Some Key Highlights: Db2 REST API  Automatic INDOUBT Resolution for DPF  Adaptive workload management for WORKLOAD=ANALYTICS  CPU Controls Columnar Page based VARCHAR compression  Query Performance (early aggregation; early distinct; full outer join; join residual predicate support; NULL=NULL) Memory Stability (COMPACT VARCHAR; Full Outer Join)  Advanced Log Space Management  Ability to block operations which put table in reorg-pending state Optimizer Version Control  Enhance Support for Unicode Data in a Non-Unicode Database  Faster Database Activation  Queries can kkipped locked data SSO with JWT Token  Authentication Caching  Security-Enhanced (SE) Linux support on RHEL 7 & 8  Enhancement to improve compression for numeric data stored in string data types in columnar tables Federation: Parallelism ; Numerous JDBC connectors Tech Previews:  Graph Database;, ML Optimizer; Automated HADR with Pacemaker; Containerized Deployments: Db2U on RedHat OpenShift standalone for both Db2 and Db2 Warehouse; Db2 Community standalone docker container on DockerHub (non-production) And much more: https://ibm.co/2NHllxv Webinar Series - Db2 Offering Management Webinar Series (including Db2 v11.5.4 Deep Dive) The Db2 Offering Management team provides a series of informative webinars covering Db2 roadmaps, strategies, new feature and capability overviews, and much more: Overview of Db2 Editions and Entitlement migration paths from older editions to new. Overview of Db2's strategic direction and future Roadmap. Overview of Db2's Containerization Strategy for Docker and Red Hat Open Shift. Overview of Db2 REST Service, Python UDF and Drivers. Deep Dive into Db2 v11.5.4 Nebula release. We will go through exciting new features. Deep Dive into Db2 Graph Capabilities. Deep Dive into Db2's Machine Learning capabilities. Deep Dive into Db2's new Enterprise readiness capabilities. Register for access to recordings, as well as upcoming webinars: https://mailchi.mp/aee32565e7c6/db2-nebula-webinar-landing-page Announcement - IBM Db2 on Cloud - Enterprise Plan Whether you are shifting workloads to cloud or augmenting your on-premises business, IBM Db2 on Cloud has never been more ready to take on your toughest, mission critical workloads.  Starting June 24, 2020, you can purchase the brand-new Enterprise plan. Some of the key features are... Online scaling of storage and compute. Zero downtime maintenance. Leverages Multi-Zone Region (MZR) support for a 99.99% high availability!!! 10TB of free backup storage for up to 14 days of backups Self-service managed backup with point-in-time restore (Watch for news about our upcoming Standard plan, available later this summer.) https://www.ibm.com/cloud/blog/announcements/db2-on-cloud-announces-new-enterprise-high-availability-plan Webinar - The new face of Db2: Cloud-Native and AI ready Piotr Mierzejewski (Director, Db2) described the future directions in Db2 11.5 for AI and the cloud. There is a lot to unpack from this presentation. A must-see! https://www.dbisoftware.com/blog/db2nightshow.php?id=805 Problem Determination - Enabling Db2 Historical Monitoring (db2histmon) - Continuous diagnostic data collection and archival To aid with problem determination and improve the availability of diagnostic and monitoring data at the first occurrence of a problematic event, the new Db2 Historical Monitoring (db2histmon) scripts and framework are now available. These scripts deploy a broad set of monitoring and diagnostic data collection, at varying intervals, and manage the archival and purging of historic data. Data collection sets can by customized as needed. Download the db2histmon scripts: https://github.com/IBM/db2histmon Learn more about deploying and using the db2histmon scripts: https://bit.ly/31uc580 Blog - How-To: Running HA IBM DB2 on Kubernetes IBM Cloud Kubernetes Service is a managed Kubernetes offering to deliver powerful management tools, an intuitive user experience, and built-in security and isolation to enable rapid delivery of applications—all while leveraging IBM Cloud Services, including cognitive capabilities from Watson. The aim of this blog post is to demonstrate a Db2 deployment architecture on Kubernetes using Portworx persistent volumes. Following this post, you’ll understand how to run Db2 in production on Kubernetes. https://www.ibm.com/cloud/blog/how-to-running-ha-ibm-db2-on-kubernetes Webinar - Db2 Resiliency Models and HA Best Practices Join Dale McInnis (Executive Technical Specialist), as he provides an overview of Db2 resiliency and high availability best practices. https://www.dbisoftware.com/blog/db2nightshow.php?id=796 Hands-on Lab - IBM Db2 on OpenShift With the move to DevOps and Agile frameworks and the shift towards "hybrid" in public and private cloud, platforms such as IBM Red Hat OpenShift are becoming the standard in application delivery. This lab teaches you how to deploy and work with Db2 in a OpenShift Environment for both OLTP and MPP deployments. The lab includes how to deploy Db2 applications on Node.js and the Use of Db2 External Tables in OpenShift. https://www.ibm.com/cloud/garage/dte/tutorial/db2-openshift-hands-lab/ 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. IDUG Db2 Virtual Tech Conference July 20, 21 & 23: https://www.idug.org/p/cm/ld/fid=2059 Upcoming Regional User Groups: Find Other Local Db2 User Groups in your area: https://www.idug.org/rug Webinar - Data Security for Database Administrators Today, data is the corner stone of any business. As a result, database teams are facing a number of challenges including the increasing size and complexity ofworkloads, moving data and applications to the cloud, and migrating legacy technologies to cloud-based/cloud-native architectures. To successfully navigatethese trends, organizations must account for new operational risks inherent in hybrid multicloud data environments and view data security as an essential aspect of modern database administration. In this session we will discuss the core data security use cases that database management teams need to consider as they build next-generation database platforms. https://bit.ly/2B7mgo2 _____________________________________________________________________________________________ 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. https://ibm-analytics-roadmaps.mybluemix.net/ 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://bit.ly/sig_Blog) IBM DB2 Chat Bubble (http://bit.ly/sig_forums) IBM DB2 Twitter page (https://twitter.com/db2_support) IBM DB2 Facebook page (https://www.facebook.com/DB2Support) IBM Youtube Channel (http://bit.ly/sig_YouTube) developerWorks Answers (forum): https://developer.ibm.com/answers/topics/