(Allan W. Tham) A backup and recovery strategy is essential to prevent data loss, regardless of your database management system. Designed for the DBA who may be coming to IBM DB2 Universal Database (UDB) with Oracle skills, this article explains how backup and restore functions work on DB2 UDB f

(Kevin Van Winkle) This article describes the steps needed to configure IBM® DB2® Content Manager OnDemand to run under a HACMP environment. It assumes familiarity with HACMP concepts and terms, and that the hardware involved is set up to support HACMP. Because there are such a large number of possi

(Craig Mullins) If I run the following Runstats command: Runstats Database.tablespace Index(all) will it update ALL columns of a multi-column index or just the first column? (R)

(Philipp K. Janert) What are the best choices when designing the schema for a relational database? What is the rationale in deciding in favor of one and against some other alternative? Given the amount of vendor-specific recommendations, it is all too easy to overlook basic relational database funda

(Bob Swart) This article demonstrates how to build a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.

(Craig Mullins) In Oracle DECODE can be used in a where clause. For example: WHERE DECODE (deptno,10,’HR’, 20,’Sales’) = ‘Sales’ How can this be achieved in a DB2 query with the CASE statement? (R)

The new International Business Machines (IBM) DB2 ODBC driver fully supports Microsoft Transaction Server (MTS), including connection pooling and automatic transaction enlistment. The update, known as MTS Hotfix 0722 for MTS 2.0, allows MTS applications to update IBM’s DB2 databases on a wide va

(Pat Selinger, Curt Cotner, Maryela Weihrauch and Heather Lamb) Many of IBM’s customers are at least piloting, if not wholeheartedly committed to writing, their new applications in Java. These applications are often mission-critical which means that having high performance, security, and consistency

(Nick Nur) You can use SMS on the mainframe to consolidate dataset extents easily and quickly without recovering the tablespace. (R)

(Tony Lau) SPEC provides a generic user guide on how to set up the SPECjAppServer2004 application. The technology coverage of the benchmark has been significantly extended from the benchmark released in 2002 in order to cover more aspects in a J2EE 1.3 environment. Vendor-specific information is not