(Greg Nash) If you need to store XML data in DB2, translate XML to relational data, or shred relational data into XML, the XML Extender for DB2 is an essential utility. But it’s not always straightforward. Find out what it can do and what problems to expect.

(Dale McInnis) This article provides the details on how to implement log shipping to guarantee high availability for your DB2 UDB for Linux, UNIX and Windows databases.

(Craig S. Mullins) DB2 for OS/390 has provided the capability to create temporary tables since Version 5. But the initial functionality was practical only in certain circumstances due to some inherent limitations. This first type of temporary table is known as a created temporary table. IBM’s suppor

(Naga Ayachitula and Michael S. Schwartz) This article describes the architecture of the IBM DB2 Records Manager V 3.1(IRM) product. We describe the various components of the IRM and discuss the architecture and design of the engine, Web administrator application, J2EETM design patterns like Session

(Rahul Kitchlu and Connie Tsui) If you are responsible for developing and delivering three-tier Java applications that access data on DB2 servers, you may have found it hard to choose between various available accessibility options. In a typical scenario, applications could access data from one or m

(Susan Lawson) In the past two colums I have covered topics regarding Version 8 features that we may want to consider in the databases and applications that we are designing today. We have talked about the new data partitioned secondary indexes and additional index changes, and in the last issue we

(Shivakumar Venkataraman and Tian Zhang) DataJoiner (DJ) is a heterogeneous database system that provides a single database image of multiple databases. It provides transparent access to tables at remote databases through user defined aliases (nicknames) that can be accessed as if they were local ta

(Hernando Bedoya) Stored procedures, triggers and User Defined Functions are the key database features for developing robust and distributed applications. In V5R1, SQL Triggers are supported on DB2 Universal Database for iSeries to give much more portability to the database. This IBM Redbook inc

(Michael Epley and Kulvir Singh Bhogal) In this article, you’ll learn how to build an application that will allow for the efficient transfer of Microsoft Excel spreadsheet data into a DB2 UDB database using Apache’s POI and HSSF.

(Susan Visser and Bill Wong) Although the DB2 documentation covers the installation and configuration of DB2 servers and clients, today provides more detailed instructions on installing the server. (Day 6, “Installing and Configuring DB2 Clients,” shows how to install the DB2 clients.) I also explai