(Xiaohong Fu) Referential integrity (RI) is the state in which all values of all foreign keys are valid. Both traditional RI and temporal RI are relationships between pairs of tables, in which the business rules are represented.

(Wei Li and Michael Wendel) Db2 12 function level 503 (V12R1M503) introduces a new built-in global variable, SYSIBMADM.REPLICATION_OVERRIDE, that provides support needed to replicate system-period temporal tables or tables that contain generated expression columns.

In part 3 of our new series of DB2 Support Nightmares we look at the risks of staying on out of support databases.

(Marna Walle) Here are the show notes for Episode 20 “Two Is One And One Is None”. The show is called this because our Topics topic is trying to figure out how to archive family photos and videos.

(Tom Snyder) You may have read my MC Press Online articles about Microsoft SQL Server Integration Services (SSIS). I’d like to broaden the topic to discuss Extract, Transform, and Load in a philosophical sense to give you a better understanding of how you could use it. However you decide to implemen

(Tom Toomire and Emily Alameida) In Db2 11 and 12, APAR PI98649 introduces three new Db2 commands, START RESTSVC, STOP RESTSVC, and DISPLAY RESTSVC for operational control of Db2 REST services and support for versioning of REST services.

(Craig S. Mullins) Data modeling is the process of analyzing the things of interest to your organization and how these things are related to each other.

(Henrik Loeser) Well, that title is a little bit long and ugly, but it basically describes what I wanted to tell you about today.

(Mark Gillis) The set-up You have a mission critical database that uses DB2 V9.7 or 10.1 (or even earlier! We do have customers still running V8). It’s robust, reliable and gives little cause for concern.

(Henrik Loeser) Few days ago, it was announced that IBM Cloud Key Protect integrates with the Kubernetes Service. It means that cluster secrets such as service credentials, TLS certificate information and other confidential information can be encrypted using a managed root key.