(Michael Schulz) As I just went through the installation of DB2 pureScale 9.8 on an AIX 6.1 machine I thought I’d share a few things that weren’t so obvious and made it a not so smooth experience.

(Jian Feng Cai) In this article, you learn how to develop the Execution Object Model (XOM), Business Object Model (BOM), and rules for implementing dynamic forms in WebSphere Operational Decision Management V7.5. Using a simple web-based questionnaire as an example, the article demonstrates how to r

(Robert Catterall) I’m in Las Vegas this week for the IBM Information on Demand 2012 conference. At this year’s IOD event I’ve particularly enjoyed learning more about DB2 11 for z/OS, the beta program for which is expected to begin in March of 2013. DB2 11 will deliver a lot in the way of new featu

(Richard Wozniak) As the world becomes increasingly instrumented, and the IBM vision of a Smarter Planet becomes reality, the value of IBM Informix TimeSeries is becoming clearer. With its origins in the key architectural breakthrough of Informix Dynamic Server (IDS) Version 9, Informix TimeSeries i

(Richard Tran, Kevin Hite, Nigel Campbell and David Hanson) IBM Cognos BI v10.2 offers a data connection type for direct connections to IMS databases. This article describes best practices for configuring the IBM Cognos BI server, preparing the target IMS system for reporting applications and creati

(Ember Crooks) I have been through a number of IP address or host name changes over the years, and thought I’d share the lessons learned. I’m specifically talking about changes to the IP address or hostname of a DB2 server, and the related changes within DB2. This post focuses on steps for Linux/UNI

(Henrik Loeser) When I read a question about INCLUDE columns that I received I first thought that indexes were meant. The reason is that for performance reason, to achieve index-only access, additional columns, not contributing to the index key, are added to an index during CREATE INDEX.

(Joseph Yeh and Erin A. Wilson) See how Tom, a data modeler for the Sample Outdoors company, uses comparison and synchronization reports to distribute information about proposed, upcoming, and implemented changes to data models.

(David Birmingham) Many data warehouse environments answer the database referential question in the same way—it’s not enforced. That is, the referential constraints are simply disabled in the database because they only create drag on the loading and maintenance processes.

(Lockwood Lyon) Both application designers and database administrators sometimes take the simplistic view that regular backups of application data are sufficient for any recovery needs. The strategy of weekend backups can easily backfire!