(Craig Mullins) DB2 performance is one of those perennial topics that people just can’t seem to get enough of. I guess that is because the performance of applications is one of the bigger issues that end users complain about. And DBAs can be heroes if they can resolve performance problems quickly. I

(Rikki Kirzner) You already know IBM Rational offers a rich portfolio of analysis, design, and construction (ADC) software and tools that are optimized to support a particular set of implementation technologies and development styles. But let’s be honest—the list of IBM Rational products is somewhat

(Willie Favero) I would… and in a New York second. Ok, maybe I’m not really in a position that would allow me to “put up a warehouse someplace”, but if I were, or if I was asked for my opinion, I would most certainly, and without hesitation, recommend it to anyone, anytime, and even for a non-DB2 sh

(Torsten Bittner) You can use the SQL/XML query language to transform relational data into XML format. Since it is cumbersome to manually write SQL/XML queries, IBM Rational Data Architect simplifies this work by automatically generating SQL/XML queries based on graphically defined mappings. Get an

(Michael L. Gonzales) In a competitive environment, businesses require a thorough understanding of their own as well as their partners’ processes. Process knowledge is crucial to reaching across the extended enterprise.

(Omer Brandis) In the last few weeks , I got the chance to work with PATROL central 7.5 and its solutions for SAP (PATROL central is a monitoring tool from BMC).

(Eric Herber) This is the first of a two-part article series talking about locking mechanisms in IBM’s strategic data server, Informix Dynamic Server (IDS). IDS is an optimal choice for high-end online transaction processing (OLTP) and embedded solutions. This article helps you to understand locking

Download a free trial version of IBM DB2 Enterprise 9. DB2 9 is the result of a five-year development project that transformed traditional (static) database technology into an interactive data server that merges the high performance and ease of use of DB2 with the self-describing benefits of XML. DB

Attend “Compliance…Not Just for DBAs”, a teleconference which is packed with important information for not only DBAs, but also Auditors and Compliance and Security Administrators responsible for adherence to regulations in their company. (R)

(Craig Mullins) One area that tends to confuse some DB2 developers until they gain experience is how DB2 partitioning works. A common question I get goes something like this: “If a table is in a partitioned table space, say four partitions, for example, then to process the table in batch can I run f