(Robert Catterall) Statistics reports can reveal surprising facts about the subsystem you thought you knew well. I wrote a column last year about the wealth of performance and tuning information available in DB2 monitor accounting reports. I promised to similarly cover statistics reports, which

(Paul C. Zikopoulos and Roman B. Melnyk) If you are an experienced database administrator (DBA) you likely use a mix of graphical user interface (GUI) tools and the IBM DB2 Universal Database (DB2 UDB) command line processor (DB2 CLP) to accomplish your day-to-day tasks. In some cases, the differenc

(Knut Stolze) This article describes an approach for using the existing replication facilities in DB2 UDB to replicate spatial data by transforming it to an external representation based on LOBs, and replicating those LOBs. Sample setup program included.

(Kim Moutsos) After three years under construction – and a year of pre-ship buzz – DB2 UDB for z/OS v.8 is ready for the big “reveal.” DB2 Magazine talks to the product’s lead architect for a preview of the changes.

(Punit Shah) This article discusses the dynamic behavior of DB2 v8.1 and when AIX 5L memory and CPU resources change, and how changes in a few DBM and DB configuration parameters are handled using a Dynamic Reconfiguration script (DR script).

(Maria Almeida) This IBM Redbook documents a residency project conducted at the IBM International Technical Support Organization, San Jose Center. The project tested and implemented stored procedures executing in DB2 for OS/390, DB2 for Windows NT, DB2 UDB for AIX, and DB2 for AS/400 servers. Thi

(Serge Rielau) Partitioning UNION ALL views are commonly used to simplify data maintenance and to overcome scalability limits of single tables. This article describes how DB2 Universal Database Version 8 for Linux, UNIX and Windows enables you to insert, update, and delete through views defined with

(Guojian Cai and Terry Sych) TPC-H is a well-known decision-support database benchmark that stresses database, platform, and I/O performance. Optimal performance of this workload requires that the hardware and software systems be fully tuned and optimized. This white paper describes the database set

(C. M. Saracco) Using Enterprise Information Integration (EII) technology with Web portals can extend the reach of pre-built components and make it easier to develop custom components. In this article, we’ll explain why as well as show you how to get off to a quick start.

(Paolo Bruni) Databases are growing tremendously. Because of legal requirements, or trend analysis, or need for historical data, terabytes of data are kept on-line causing performance and operational problems. Not all data is frequently accessed though, nor needs to be kept on fast media. Here archi