(Javier Estrada Benavides) Anomaly detection is perhaps one of the hottest sub-topics in Analytics and Data Science. There are many ways to begin with these fields of study, and one of the first steps that both disciplines have in common is to know your data, and we can’t stress it enough.

(Scott Vetter, Jean-Luc Bonhommet and Ingo Dimmer) IBM Db2 Mirror for i provides a new solution for continuous availability for an IBM i environment based on an active-active clustering design that uses a low-latency communication protocol for synchronous database replication.

(Deepthi Nagarajan) All industries—from healthcare to retail to banking—are digitally transforming themselves every day to become more agile and stay competitive. However, all industries depend on data to be successful, and this impacts the way enterprises plan and execute their operations.

(Martin) 100% of our studio audience learned something!George gave a great tutorial to get users familiar with using Jupyter notebooks for learning and managing Db2.

(Mark Gillis) The previous blog (Behind the scenes with Foreign Keys part 1) was looking at the impact on your data of switching Foreign Keys (FKs) off and how to clean up the ensuing orphan data. I’m going to move on now to what can happen to your access paths regardless of any data manipulation.

(Brian Laube) Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.

(Thomas Eng and Emily Alameida) With APAR PH14688, BIND SERVICE now supports the COPY option to copy existing REST services to either local or remote Db2 servers running on Db2 12 with versioning enabled.

(Ember Crooks) IBM IDs are completely, 100% free. You pay with a bit of your personal information. You have to provide an email address and a first and last name.

(Regina Liu, Long Tu, and Jennie Chang) With Db2 12 function level 506 at application compatibility level V12R1M506 or higher, Db2 now automatically drops explicitly created universal (UTS) and LOB table spaces when the tables they contain are dropped.

(Shikha Garg) Data is all around us. By 2020, IDC expects the entire store of data to be as large as 44 zettabytes, amounting to a single bit of data for every star in the physical universe.