(Paul Read and Michel Steinhauer) IBM DB2 9 for Linux, UNIX, and Windows includes a new dictionary-based row compression feature you can use to compress data objects. When you compress data, you achieve disk storage space savings by representing the same data using fewer database pages. Large tables

(Chris Eaton) I often see questions on forums asking how to convert rows to columns and columns to rows. In this posting and the next I’ll give you two queries that will do exactly that for you. Thanks again to Serge Rielau for the material from his IDUG presentation.

(Matthias Nicola) DB2 9 provides pureXML storage and offers XQuery and SQL/XML as query languages. XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This article presents a set of guidelines for writing XML quer

(Uri Lifshitz) In a DB2 for z/OS system that comprises tens of thousands of tables (and even more indexes), how can I find out which database tables require maintenance without running a lot of reports?

(Omer Brandis) In this post I’d like to tell you about a small performance problem I encountered recently.

(Nick Dhupia, Robert Duncan and Michael Hellinger) IBM DB2 Content Manager Version 8.3 provides workflow capabilities that provide native document routing in a content management environment. Such workflows can be used in long lasting processes such as mortgage loan applications or insurance claims

(Steve Wehr) This article offers answers to questions not covered anywhere else to help you develop and deploy WebSphere for Linux on System z applications, including updates for the current product versions as of 2006 October. These technical questions and answers address 64-bit Linux distributions

(Reginald C. Culpepper) Database-management changes can occasionally have unanticipated results when testing environments don’t exactly duplicate the production environment. The data-processing staff can attempt to replicate production environments to the best of their ability, but how can they be s

(Whei-Jen Chen, Art Sammartino, Domromir Goutev, Felicity Hendricks, Ippei Komi, Ming-Pang Wei and Rav Ahuja) IBM DB2 9 for Linux, UNIX and Windows marks a new stage in the evolution of data servers. IBM has continually led the data management industry with the release of innovative technology. DB2

(David Leigh, Ashwin Manekar, Chad Smith and Jonas Richard) This article describes how to construct an automated build engine solution for applications developed using WebSphere Integration Developer and maintained using Rational ClearCase as the Software Configuration Management system (SCM). It ex