(Ember Crooks) When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered. Sometimes binds h

(Thuan Bui) IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows. Unlock the enterprise features by adding a data repository that lets you monitor historical metrics for SQL statements, database access patterns, storage optimiz

(Amit Kumar) InfoSphere Data Replication (IIDR) CDC supports data replication from databases running on Windows Cluster services. Follow the step-by-step process that outlines all the required tasks to configure IIDR CDC on MSCS with failover capability.

(Craig S. Mullins) “Vendor speak” can be a difficult thing to decipher. And that is particularly true within the realm of DBA tools vendors. It would be easier if every vendor followed the same terminology… but, of course, they do not.

(Jack Vamvas) Question: How is the function COUNT_BIG() used and what is the difference with COUNT()?

(Thuan Bui) IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows. Explore the lightweight option for real-time monitoring and administration with auto-discovery of databases, at-a-glance health view of all your databases, detai

(Pavan Kristipati) In this blog post, I will make a case for why you should specify a DISTRIBUTION KEY clause for a table that is about to be created on a single partition in a DPF database. This doesn’t make sense.. Does it?

(Dr. Ali Arsanjani, Nakul Bharade, Magnus Borgenstrand, Philipp Schume, J. Keith Wood and Vyacheslav Zheltonogov) IBM Business Process Manager (IBM BPM) is a comprehensive business process management (BPM) suite that provides visibility and management of your business processes. IBM BPM supports the

(Kim J. Clark) At a high level, both SOA and web APIs seem to solve the same problem – expose business function in real-time and in a reusable way. This tutorial looks at how these initiatives are different and how they align into an evolving integration architecture. It discusses how API Management

(Troy L Coleman) I was recently asked how to calculate the moving average for a given metric. To be honest, I’ve only done minimal work with OLAP functions, so I consulted the SQL Reference guide for help. I need to see examples to get an understanding of how things work; unfortunately, those were l