(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 diffe

(Seth Grimes) Data mining as an analytic discipline is neither as obvious as query and reporting nor as carefully positioned, marketing wise, as online analytic processing (OLAP). It encompasses several disparate techniques, and, although it has achieved noteworthy results in applications such as cr

(Clara Liu) Learn the benefits of the latest version of DB2 and how easy it is to migrate to. This article summarizes the new features and enhancements of the V8.1.4 update. It then discusses the complete migration process including the preparation, the actual migration, and the post-migration tasks

IDC has reported that the market for relational and object-relational databases was $13.6bn in 2003. Coming in first was Oracle, which had 39.8% market share with $5.4bn, followed by IBM with 31.3% share, at $4.25bn. Microsoft followed with 12.1% of revenues, at $1.65bn. However, Gartner pegged

(Robert Westervelt) IBM is embarking on a widespread testing program for its DB2 Information Integrator software, Masala, which drills into disparate data sources to return unified reports to users. (R)

(Chris Fierros) This article is the third in a series of articles covering the topic of IBM DB2 Universal Database (UDB) and Windows scripting. In this article we continue to explore in detail more scripting options including Object REXX and PerlScript with Windows Script Host (WSH) and DB2 UDB V8 f

(Marin Komadina) The time problem occupied my attention, during a recent recovery situation. On the SUN Solaris machine, the system time jumped forward unexpectedly. This situation raised questions about system and database time interaction, the time drift influence on the backup and recovery and ma

(Robert Catterall) I inherited a reasonably large DB2 subsystem that exclusively uses user defined/user managed storage. As you know, once you start managing hundreds of DASD volumes manually, even with homegrown reports, the situation gets out of hand quickly. I want to lead the way to more eff

(Philip Howard) I have no idea of whether IBM had Cassius Clay (or even Mohammed Ali) in mind when it nicknamed the forthcoming release of DB2 UDB “Stinger” but the product certainly looks likely to pack a punch when it is released later this year.

(Sundip Pradhan and Serge Rielau) Complex applications or batch processing can execute hundreds of SQL procedures and potentially thousands of SQL statements, difficult to tune using traditional monitoring methods. This article introduces a Java-based GUI tool for use with DB2® Universal Databas