Friday 14 September 2018

Db2 and Db2-on-Cloud - Technical Advocate Newsletter - Sept 2018

image



Announcement - Db2 Version 10.5 Fix Pack 10 (v10.5.0.10) is Available for Download
List of high impact & pervasive (HIPER) fixes (APARs): https://www-01.ibm.com/support/docview.wss?uid=swg21994955
List of all fixes (APARs) included in this fixpack: http://www-01.ibm.com/support/docview.wss?uid=swg21633303
Fixpack download page: https://www-01.ibm.com/support/docview.wss?uid=swg24045012

Announcement -
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 (v11.1.3.3.ifix2) is Available for Download
List of high impact & pervasive (HIPER) fixes (APARs): https://www-01.ibm.com/support/docview.wss?uid=swg21647054
List of all fixes (APARs) included in this fixpack: http://www-01.ibm.com/support/docview.wss?uid=swg21995889
Fixpack download page: https://www-01.ibm.com/support/docview.wss?uid=ibm10720009

Announcement -
End of Support (EOS) for Db2 Version 10.5 is April 30, 2020.
Effective April 30, 2020, IBM will withdraw support for Db2 Version 10.5. Extended support will be available beyond this date.
https://ibm.co/2NCGTNi

Virtual Conference -
2018 Db2 Lab Day - Monday October 1, 2018
Please join us for a great set of sessions on our 2018 Db2 Lab Day. Db2 is at the core of IBM’s Hybrid Data Management strategy. This will be a full day of sessions to update you on all the latest news related to Db2 and the Db2-based Common SQL Engine offerings and strategy..
https://www.idug.org/p/cm/ld/fid=1625

Conferences & Summits -
Upcoming International Db2 Users Group (IDUG) Technical Conferences & Summits
The events offer new educational opportunities and more training than ever before! Attendees will experience: Five days of education sessions; Half and full-day workshops; More than 100 one-hour technical sessions; Three expert panels on Db2 for z/OS, Db2 & Application Development; Opportunities to get certified; And much more!
IDUG & IBM Data Tech Summit, 8 – 10 October 2018 | San Jose, California, USA: https://www.idug.org/p/cm/ld/fid=1591
IDUG EMEA Db2 Tech Conference, 4 – 8 November, 2018 | Malta: https://www.idug.org/EMEA2018

Webinar -
What's New in Db2 on Cloud
From the time that we announced the free tier (Lite Plan) at THINK 2018, the past few months have shown significant enhancements to Db2 on Cloud. In that time, we have brought federation capabilities to make it easier to connect to another Db2 database, offsite disaster recovery to ensure the highest levels of availability and ease-of-use updates to our web console and IAM/backups integration. Join us for a two-part series where we will do a deep dive into all of this and a few other core features to help you get the most out of using Db2 on Cloud. Part one on September 13th will cover HADR and Federation. Part two on October 18th will cover IAM and backups and various web console enhancements.
Part 1: http://bit.ly/2Ogfdet
Part 2: http://bit.ly/2p1kb3H

Webinar -
Adaptive Workload Management in Db2 Warehouse
IBM Db2 Warehouse (and Db2 Warehouse on Cloud) has recently rolled out a new Adaptive Workload Management technology that allows you to easily manage your database resources across workloads and ensure they meet their desired performance objectives. This exciting new technology automatically manages the scheduling and execution of work in your system based on resource targets you assign, ensuring stable and reliable performance even in the face of the most highly concurrent workloads. This session will introduce you to these new capabilities and show you how you can leverage them in your own environment.
Register to access the video replay: ibm.biz/Db2TT_Jul2018

Announcement -
Data Virtualization (Federation) for Db2 on Cloud
IBM is happy to announce Db2 Data Virtualization features for Db2 on Cloud. Sometimes called “federation”, this feature lets our customers access data from multiple different databases with a single query. With this latest addition, users will now be able to access data that is located on any of their Db2 or Informix data sources including both cloud and on premises systems. This functionality is supported on all versions of Db2 on Cloud, except for the free Lite plan. However, users can use the Lite plan as a target that you can pull data from.
https://www.ibm.com/blogs/bluemix/2018/06/announcing-data-virtualization-federation-db2-cloud/

Announcement -
Disaster Recovery Node for Db2 on Cloud
Disaster recovery (DR) is now available on Db2 on Cloud. This new features leverages Db2’s HADR technology and lets users add a DR Node on demand in an offsite data center of their choice. In an unlikely event where the primary data server is affected by external circumstances, such as a natural disaster, users can failover to their Geo-Replicated Disaster Recovery Node with a few clicks. Users can also fail back to their primary node just as easily.
https://www.ibm.com/blogs/bluemix/2018/07/db2-cloud-announces-disaster-recovery-node/

Blog -
Improving Performance in Your Data Warehouse – Part 1
This article is one in a series that focuses on improving performance in Db2 Warehouse. The first part provides some background information and lays out the first and most important aspect of query optimization, namely, cardinality estimation or estimating the number of rows that flows through the various operators in a query execution plan. Subsequent articles will discuss other topics of interest to query performance.
https://www.idug.org/p/bl/et/blogaid=779

Redbook -
Running an SAP System on IBM Db2 11.1 with the Db2 pureScale Feature
This document explains how you create an SAP system running on IBM Db2 with the Db2 pureScale Feature. It describes how you can convert the IBM Db2 11.1 database of an existing SAP system to an IBM Db2 11.1 database with the Db2 pureScale Feature, and how to install a new SAP system on IBM Db2 11.1 with the Db2 pureScale Feature.
https://help.sap.com/viewer/db6_purescale_11_1

_____________________________________________________________________________________________


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: (http://ow.ly/rPsM30fHnwI)
Db2 Support Twitter channel: @AskIBMAnalytics (https://twitter.com/AskIBMAnalytics)
AskIBMAnalytics Facebook channel: @AskIBMAnalytics (https://www.facebook.com/AskIBMAnalytics/)
developerWorks Answers (forum): https://developer.ibm.com/answers/topics/
Thoughts from Db2 Support (blog): https://www.ibm.com/developerworks/community/blogs/IMSupport?lang=en
Db2 Technical Advocacy Wiki: https://www.ibm.com/developerworks/community/groups/community/Db2_Technical_Advocacy_Program

Translate