(Aji) Use this clause to avoid sorts – You can influence the access path most by using OPTIMIZE FOR 1 ROW.

(Dan Burger) People may have problems defining a data warehouse. They may have problems designing and building a data warehouse, too. But that hasn’t slowed down the desire to get a better grasp on data and use it more effectively to drive the business and preserve revenues. “What many people descri

(Frank Fillmore) Choosing a particular parameter value when creating a Q Replication subscription can sometimes set off a complicated chain reaction. An example is the “Automatic Load” option. When you create a new Q Replication subscription, tables in the source DB2 environment frequently are alr

(Dave Beulke) Once you have reviewed the overall system for the aspects that we have discussed over the last few months, it’s time to drill down into your more critical transactions and processes. Critical transactions are those frequently executed transactions that are using excessive CPU or I/O re

(Craig Malton) Learn how to use Web 2.0 and merchandising associations to implement a package builder within WebSphere Commerce. This package builder allows shoppers to create custom bundles. This tutorial describes how to implement the package builder and how to use it in a sample scenario. (R)

(Roger Sanders) Let’s kick off the certification sample questions for 2009 with the entry below. I’ll be posting the questions one at a time from now on, but I promise to post two a week. That way, those of you preparing for the DB2 9 database administration exam can keep on testing your progress.

(Antonio Cangiano) A little over a week ago IBM released a new version of the DB2 beta for Mac OS X Leopard, following up on valuable feedback that we’d received in response to earlier versions. This version is important because it resolves a reported issue that was occurring when building drivers f

(Xiao Feng Zhao, Qiang Wang, Susan Malaika and Keith Wells) The pureXML feature of IBM DB2 9 has revolutionized support for XML data—handling XML as a new data type that is stored in a natural hierarchy—different from relational data. IBM Data Studio can create Data Web Services with multiple pureXM

(Robert Catterall) About 30 some-odd years ago, a team of IBM researchers (working on what would become DB2) invented cost-based SQL statement optimization (thank you, Patricia Selinger et al). This development ended up being a very big part of DB2’s appeal in the marketplace, because it meant that

(Craig Mullins) In today’s difficult economic climate it can be difficult to get the training you need to ensure optimal job performance. Training budgets are notoriously the first thing that gets slashed when earnings and margins dip. And even if you have a training budget it can be difficult to ge