(John Campbell, Claire McFeely, and Jennie Chang) Back in Version 9, Db2 for z/OS introduced very simple and minimal support for the SQL MERGE statement, only providing an upsert capability with limited functionality.

(Michael Krafick) The Db2 REORG is a fundamental command and a best practice for regular maintenance.

(Luiz Aoqui) Ever since we launched, Cognitive Class has hit many milestones. From name changes (raise your hand if you remember DB2 University) to our 1,000,000th learner, we’ve been through a lot.

(Michael Krafick) How do I get access to a database? How do I get access to the data I need in a table? Today we will answer those questions.

(Mike Johnson, Chris Backhouse, Stéphane Faure, David Griffiths, Yann Kindelberger, Ke Wei Wei and Hao Zhang) This Redpaper introduces the integration between two IBM products that you might like to consider when implementing a modern agile solution on your Z systems.

(Henrik Loeser) Remember my blog posts about how to manage Watson Assistant from the command line and how to test context for a conversation? Well, that tool did not work well for server actions which I used in this tutorial on building database-driven Slackbot.

In part 1 of our new series of DB2 Support Nightmares we look at the implications of only having one userid for all users to use and the frighteningly consequences.

(Eric Radzinski) For many Db2 for z/OS customers, Query Management Facility (QMF) is a crucial and indispensable piece of their enterprise. They rely on QMF as a means to easily and efficiently reveal insights into their business data and to render those insights visually on dashboards and as report

(Lockwood Lyon) Typical big data applications have a load phase, where a snapshot of data is extracted from operational systems, transformed and cleaned, and then loaded into your big data appliance. Analysts and data scientists can then execute business analytics (BI) queries against the data store

(Michael Krafick) There are tons of metrics to show pain, but there are just as many to show efficiency. Index Read Efficiency (IREF) is a way to find SQL performance hogs.