(Chenhong Xia) This is Part 2 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM DB2 9, using Microsoft Visual Studio .NET 2005. Part 1 explained the application specifications, database design, and how to create DB2 relational

(James Edmiston) I was recently approached by one of my clients to analyze how Informix used memory on their system. The client was concerned about a potential “memory leak,” that might have occurred while some queries ran. Over time, the client needed to reboot the system more often, presumably bec

(Kathleen Richards) IBM’s 5-year development of the DB2 9 data server may offer technology that was worth the wait. In particular, DB2 9 can handle relational and native XML data, allowing DBAs to query across relational and non-relational data repositories at high performance rates using SQL, XQuer

(Vikram S. Khatri, Nora Sokolof and Manas Dadarkar) You’ll find many differences between DB2, MySQL, and PostgreSQL. We’ll start by looking at some of the fundamental architectural ways that these 3 database servers are different or similar.

(Dirk Fechner) The DB2 optimizer is a cost-based optimizer. It makes decisions based on statistics that are available for the tables and indexes. When generating statistics, DB2 offers the possibility to create so-called distribution statistics, in addition to the basic statistics. This article expl

This program is meant to be used for demonstrating the functionality of the DB2 9 for Linux, UNIX, and Windows. In addition, it’s suitable for trying out the features and functions of DB2 for yourself.

(Mark Fontecchio) IBM’s DB2 9, code-named Viper, may help System i customers organize multiple types of data under a single interface, analysts say. (R)

(Stephen Swoyer) The DB2 version 9 release IBM Corp. announced last week helped answer a few long-simmering questions about Big Blue’s competitive strategy vis-à-vis Microsoft Corp. and Oracle Corp. on the relational database front. However, as far as business intelligence (BI) features are concerne

(Bill Moore, Martin Keen, Antonio Carvalho, Michael Hamann, Prasad Imandi, Ron Lotter, Philip Norton, Christian Ringler and Gabriel Telerman) IBM WebSphere Enterprise Service Bus is a flexible connectivity infrastructure for integrating applications and services. It is designed to enable the develop

(Willie Favero) I know it’s been a while since I had a post with a little content. We are all in the same business here so I will skip the long list of excuses and just say I will try to post more often. With that said, let’s see what’s up with DB2.