(Henrik Loeser) Wow, what a title for this article. Today I will describe exactly that, nothing more. Recently I created a SQLDB service (DB2) in my IBM Bluemix account. Looking at the documentation for the SQLDB service, it describes how to use DB2 for programming languages like Java, Ruby, and Nod

(Ember Crooks) We all know that table scans can be (but aren’t always) a negative thing. I have spent less time worrying about index scans, though. Index access = good, right? I thought I’d share a recent scenario where an index scan was very expensive. Maybe still better than a table scan, but with

(Barrie Shaw) When tuning performance for an IBM Informix instance, one important issue to look for is the presence of tables and indexes containing a large number of extents. Today’s high speed disks and SSD drives can mask some of the performance hit, making this an area that is often overlooked.

(Craig S. Mullins) Things break. When a new database is created or a new application goes online, everything is fresh and new—and running as designed. But the environment changes over time. New hardware and software is added, along with more users, more data, more requirements—more, more, more. Syst

(Scott Walkty, Mike Springgay, Dan Behman and David Kalmuk) BLU Acceleration is a collection of technologies for analytic queries that was introduced in IBM DB2 for Linux, UNIX and Windows (LUW) Version 10.5. BLU Acceleration can provide significant benefits in many areas including performance, stor

(Willie Favero) I’m guessing that if you are reading this blog, you have downloaded a Redbook; and probably not all that long ago. With that in mind, today’s post isn’t about any one specific Redbook, but rather keeping up to date on the latest and greatest happenings around Redbooks.

(Henrik Loeser) In an earlier blog post I had written about why Workload Management is needed. It’s not just something for the database system or on the operating system level, it is really useful and done in “real life”. But what is managed in the system, how are you able to identify activies in a

(Sindhu S. Chandran) This article provides an overview of how predictive analytics and business rules can be used together for better business outcomes. A banking example illustrates how IBM decision management products might be used for smarter business processes.

(Harishkumar Baburao Pathangay) How to Find if a Database was implicitly or explicitly activated or deactivated

(Craig S. Mullins) In the first part of this series on DB2 health checks, DB2 Health Checks – Part One, I discussed the general concept of a health check and their basic importance in terms of maintaining a smooth-running DB2 environment.