(Robert Catterall) The previous issue of this magazine contained many articles about how to exploit the new XML data management capabilities delivered by DB2 9 for Linux, Unix, and Windows. The article on page 40 by Craig Mullins describes the new and improved XML support in DB2 9 for z/OS (now in b

(Paolo Bruni, Patric Becker, Tim Bohlsen, Burkhard Diekmann, Dima Etkin and Davy Goethals) The requirements for a database management system (DBMS) have included support for very large and complex data objects. DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can c

(Chris Eaton) I wanted to cover off the MERGE statement in this weeks posting (as I’m sure many of the American readers will be merging some turkey and some mashed potatoes later this week 🙂

(Anjali Betawadkar-Norwood, Simon Harris and Susanne Englert) In prior releases of WebSphere Federation Server (WFS), previously called WebSphere Information Integrator, many federated queries execute in a single-threaded manner. This means that even if multiple remote sources participate in a query

(Jarek Miszczyk) In recent years, the perception of the database’s importance in the application architecture has been slowly eroding. Often, the database is reduced to an ambiguous notion of a persistent data repository. Yet it is really hard to imagine an enterprise-class solution without the serv

(Willie Favero) And it fits the “Good New – Bad News” criteria so well. It can help you, hurt you, confuse you, and get you into all kinds of debates about what it does. There’s stuff that affects its behavior and it affects all kinds of other processes behavior. It could be one of DB2’s perfect con

(Paul R. Welka) This tutorial builds on an earlier tutorial (Getting started with DB2 Document Manager, Part 1: Build a simple client application in DB2 Document Manager) and illustrates a valuable feature of the product. In this step-by-step tutorial, learn how to improve productivity and end-user

(Omer Brandis) In this post I’d like to talk about tuning the number of work processes in an application server.

(Reinhold Engelbrecht) DB2 CommonStore for Lotus Domino is a great tool for archiving e-mails or other Notes documents. While in smaller customer environments the default settings are good to achieve sufficient archiving throughput, you should plan to tune CommonStore in medium and large environment

(Michael L. Gonzales) Powerful transaction-oriented information systems are commonplace in every major industry, effectively leveling the playing field. Getting ahead of the competition now requires analysis-oriented systems that can revolutionize an organization’s ability to use information it alre