(Craig S. Mullins) Today’s blog offers up yet another Top Ten list for DB2 users, perusers, and abusers… This time counting down the most common myths that are perpetrated “out there” regarding DB2 and how it works (or doesn’t work)…

(Jessica Rockwood, Michael Kwok, Roman B. Melnyk and Berni Schiefer) BLU Acceleration is a new collection of technologies for analytic queries that are introduced in DB2 for Linux, UNIX, and Windows Version 10.5. At its heart, BLU Acceleration is about providing faster answers to more questions and

(Julian Stuhler) Ever since IBM introduced DB2/2 for its OS/2 operating system back in 1987, the DB2 community has been divided into two camps: those that mainly use DB2 for z/OS on IBM’s high-end System z mainframes, and those that spend most of their time using DB2 for Linux, UNIX and Windows (DB2

(Antonio Maranhao and Joshua Kim) The IBM Database Conversion Workbench (DCW) is a no-charge plug-in that adds database migration capabilities to IBM Data Studio. DCW integrates many of the tools used for database conversion into a single integrated environment, following an easy to use framework th

(Henrik Loeser) One of the new features that went mostly unnoticed for DB2 10.1 and DB2 10.5 is the support for so-called three-part-names (nice pun?) for Federation. It allows the access to remote tables without the need to create nicknames.

(Cindy Russell) Learn from the DB2 language architect what’s new with the SQL standard and what’s new in DB2 10.5!

(Rajath Ramesh and Manjunatha D) IBM WebSphere Cast Iron introduced two activities, Read JSON and Write JSON to work with JSON data. Part 1 of this 3-part series showed how to configure JSON handling activities to invoke JSON-based REST APIs and to create your own JSON-based REST APIs. Part 2 showed

(Willie Favero) A new webcast has been announced: Diminish infrastructure sprawl by bringing analytic processes to where the data originates.

(Ember Crooks) I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer t

(Joe Pluta) I’ve long extolled the virtues of common table expressions (or CTEs), and I’ve also showed you how to use UNION statements to great advantage. They’re powerful, and I find them particularly well suited to performing ad hoc analysis on production data.