(Willie Favero) The short, cute answer would be to migrate to Version 8. Just think: first you’re V7 and then you’re V8 and then you’re V7 and then you’re V8 and then you’re… well, I think you get the idea. Now before you start to think that I’m the one that is a little dizzy, how about if I explain

(Madison Pruet) The cdr sync command provides a convenient way to perform a complete synchronization of replicated tables as a foreground process that can be run within a script. The cdr check command determines which rows are out of sync, and can perform a targeted repair of only those rows.

(Jack Boswell) This article is a simplified user’s guide for the review, overview, and use of the IBM DB2 Content Manager’s APIs on iSeries. It addresses the high-level functions of the APIs. This information should be used in conjunction with the Application Programming Reference and online help.

(Don Chamberlin and Cynthia M. Saracco) By now, you’ve probably heard about DB2 Viper’s new architecture, which supports both tabular and hierarchical data structures. Indeed, previous articles have summarized DB2’s new XML features, described how to create database objects and populate them with XM

(Willie Favero) I hope today’s topic for discussion is old news to most of you. It would be great knowing that someone paid attention in one of my IDUG or DB2 Tech Conference presentation on DSNZPARMs. However, some of you all may have just not had the opportunity to hear it yet. This entry is for y

Sarbanes-Oxley compliance is a must for every Financial Service’s Provider. Download this white paper to learn how IBM’s Banking Data Warehouse can accelerate Sarbanes-Oxley compliance within your organization. (R)

(Roger E. Sanders) If I asked what isolation level your most important, mission-critical application is running under, would you know the answer? Do you know how to use isolation levels to control the behavior and performance of applications in multiuser environments? Or do you go with the defaults

(Ueli Wahli, Larissa Leybovich, Eric Prevost, Russell Scher, Andre Venancio, Sascha Wiederkom and Neil MacKinnon) This IBM Redbook presents a business process management (BPM) “round trip” scenario, showing how a business can use a full business integration solution to complete the following tasks:

(Willie Favero) Today’s post is inspired by Rick’s comment to my Saturday, April 1st entry that discussed “One more reason to bind after migrating to DB2 V8”. Rick asked what other optimizer enhancements would be available in new function mode (NFM) if a plan or package was already bound while in co

(Anil Mahadev) HADR stands for High Availability Disaster Recovery, a new technique introduced in IBM DB2 8.2.