IBM introduced new software that allows businesses to better manage the growth of information by integrating data warehousing and archiving capabilities.

(Willie Favero) Even though DB2 V1.1 had only been GA for 10 months, Database 2 (DB2) Version 1 Release 2 was announced on February 4, 1986. Just one month later on March 7, V1.2 went GA. Since DB2 had now been in use by the general database community for a whole year almost (not counting the time i

(Mark Baldridge) This installment of the UniVerse performance series, investigates the effects of field-level caching in dynamic array access and suggests improvements for dynamic array access. (R)

(Patrick Bossman and Gene Fuh) DB2 9 for z/OS includes new tools to improve the productivity of application developers and DBAs in tuning SQL workloads and individual SQL statements. Optimization Service Center (OSC) is a workstation tool for monitoring and tuning SQL workloads and individual SQL s

(Troy Coleman) Last week I discussed a quick way to create a list of system parameter changes by comparing the source macros found in SDSNMACS library. Some of these parameters impact your application developers while others impact your database programmers and how DB2 manages memory and resources.

(Chris Eaton) So far we have discussed backup syntax including targets and backup types and some options for backup. In this posting let’s look at a few other options on the backup command.

(Paul Read) IBM DB2 9.5 provides new options for tighter security, and allows for more granularity and flexibility in administration of the database. This tutorial is the second of two tutorials that cover roles and trusted contexts. Follow the exercises in this tutorial, and learn how to take advan

(Robert Catterall) This is a debate that has interested me for years. I’ve heard very good arguments on both sides, but before I get into that I’ll state that what I don’t like to see is the use of both DB2-based and application-based methods used to define and enforce the same referential integrity

(Willie Favero) So why the nostalgia? As I mentioned Friday, a few post on the DB2-L list started me thinking about how much history there is with DB2. Couple that with the fact that this year we will be celebrating the 25th anniversary of the announcement of DB2. I not prepared to through a birthda

(Brian Byrne, David McCarty, Dr. Guenter Sauter, Peter Worcester and John Kling) This article is written for architects and practitioners designing a Service Oriented Architecture (SOA). It introduces a set of patterns and capabilities representing the information perspective in the design of an SOA