DB2 Archive Expert for z/OS Version 1 has been enhanced in order to support the new limits of DB2 for z/OS Version 8. With the implementation of long names in DB2, larger indexes, and larger SQL statements, Data Archive Expert has undergone several changes in its panels structure and Row Filter

(Mika Nikolopoulou) High availability of your data is a must for the on-demand environment. This article takes you through a specific example of how the author set up high availability as part of a proof-of-concept demonstration of IBM DB2 Universal Database with High Availability Cluster Multi-Proc

(David Kline and Gabor Wieser) This article helps the new DB2 DBA understand the importance of table spaces and bufferpools, and explains how properly designing and tuning them can enhance database performance.

(Bob Swart) This article uses Kylix 3 on Linux and the Borland dbExpress data access drivers to analyze the DB2 UDB database tables, fields (names and types) to allow the user to select a specific table, toggle which fields should be shown, and dynamically view the output in both a datagrid and indi

(Chris Fierros) DB2 Universal Database (UDB) for Linux, Unix, and Windows v.8.2 (initially known by its codename, “Stinger”) continues to deliver on IBM’s promise of self-configuring, self-optimizing, and self-managing database management capabilities. In fact, with more than 100 new and improved fe

(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction p

(Chitrang Shah) Interested in learning more about performance tuning techniques and debugging methodologies for J2EE applications? This article focuses on the high-level architecture of a J2EE application developed on IBM DB2 Content Manager V8.x, while introducing the concept of queuing a network,

(John Munteanu) This article presents the design of a Java implementation for a user-defined function for IBM DB2 Universal Database (UDB) that takes a UTC timestamp and a locale name as input parameters, and returns the timestamp equivalent in the new locale. This is an especially useful function i

(Stephen Shankland and Martin LaMonica) In conjunction with the LinuxWorld Conference & Expo this week, Big Blue is expected to detail the open-source initiative, code-named Derby, according to a source familiar with IBM’s plans. The software will be governed by the open-source Apache Software Licen

IBM’s “Project Cinnamon,” still in beta but due to be released with IBM’s next DB2 release, will put XML at the heart of DB2 Content Manager and allow customers to create automatically the data model of a database based on the document type definitions or XML schemas they choose.