(Keith McDonald) In the past three posts, we have written metaprograms to create functions for comparing objects of built-in types, user-defined distinct types, ROW types, and ordinary ARRAY types. In today’s post, we will write a single metaprogram that can create comparison functions for all four.

(Pat Romanski) IBM has unveiled a new technology platform designed to transform the way that financial services firms manage the ever increasing amount of data and transaction volumes generated by capital markets around the world.

(Michael Sansoterra) A difficult task for developers is to foresee how an application may evolve in the future. As we all know, sometimes the unrealistic becomes reality. Say you have an application that will start on SQL Server and possibly later be moved to DB2 for i or vice versa. How do you crea

(Naresh Chainani and Liping Zhang) IBM DB2 for Linux, UNIX, and Windows V9.7 introduced several major table partitioning enhancements, including partitioned indexes (also called local indexes), integration with XML, online roll-out using DETACH, and support for data and index REORG at the partition

(Keith McDonald) In the first post in this series, I introduced the concept of metaprogramming in SQL using dynamic SQL and applied the technique to write a procedure that could generate comparison functions that compare two objects of any basic type. In the second post, I expanded the procedure to

(Robert Catterall) Unless you are somehow beyond the reach of advertising, you’re probably familiar with IBM’s “smarter planet” campaign. It’s all about leveraging analytics — the purposeful analysis of timely, relevant information — to improve decision-making outcomes.

(Madhu Ananthapadmanabh) This article describes how to use the REST interface of WebSphere Business Events to emit business events from any application that has access to Web protocols.

(Willie Favero) The DB2 catalog and directory have fascinated me as long as I have worked with DB2. Maybe it’s the IMS in me that occasionally wants to show its face. I remember back in the days of DB2 Tech Conferences doing presentations on how to use REPAIR (online utility) and DSN1CHKR (stand-alo

(cherry.shu) I’ve recently been working on a performance study of running IBM DB2 database on the new Sun Fire X4470 server, which is based on the Intel Xeon CPU X7560. This blog entry is a case study of scaling DB2 on the Sun Fire X4470 by using Solaris Container technology. The performance on the

(Gene Fuh, Kendrick Ren and Kathryn Zeidenstein) If you are a developer, DBA, or query tuning specialist, it is critical that you understand the basics of access paths so that you can precisely tune queries and query workloads before they cause problems in your production environment. This basic un