(Peggy Rader) Stored procedures are a convenient option for connecting applications to the database. However, the task of manually creating stored procedures is anything but convenient—it can in fact be a labor-intensive and sometimes error-prone process. That’s why the recent availability of IBM’s

(Paul Zikopolous, George Baklarz, Dirk Deroos and Roman Melnyk) DB2 UDB v8 has the capability of reorganizing both tables while users have full read or write access to these objects. Along with an enhanced REORG TABLE command, there is a new REORG INDEXES command. (pdf)

(Mary Lovelace) DFSMShsm Fast Replication provides DFSMShsm management for the use of volume-level fast replication. Fast replication is made possible by exploiting the FlashCopy capability of the IBM Enterprise Storage Server. With this capability, a set of storage groups can be defined as a copy p

Mike Devlin, general manager of IBM’s Rational division, will be top dog at the Rational Software Development User Conference this week in Dallas. When IBM finalized its $2.1 billion acquisition of Rational Corp. in February 2003, Devlin traded his CEO position for that of general manager of IBM Rat

(Walter Mayer and Stephan Bolten) This article explains the solution architecture, main concepts, objects and features of IBM Lotus Workplace Web Content Management (LWWCM), Java Edition and the advantages of using IBM DB2 Content Manager as a repository. In addition this paper describes the impleme

(Susan Lawson) Trying to achieve a true 24×7 environment is almost impossible. Welcome to the “World Without Windows”. This is the reality of today’s high availability computing environments thrust upon us with the advent of e-business. 24×7 is really a test of how clever we are at hiding outages fr

(Craig Mullins) What is the difference between DB2 and Oracle in the OS/390 environment? And which one is better? I couldn’t find a clear and fair answer to this question. (R)

This installation was done on Red Hat Enterprise Linux AS with IBM DB2 Ver.8.1. The installation was across four nodes.

(Helmut K. C. Tessarek) This article shows you step by step how to compile and configure mod_auth_ibmdb2 (an Apache authentication module) using IBM DB2 Universal Database (UDB) as the database for storing user and group information. It explains the creation and use of the User Defined Functions

IBM announced breakthrough online transaction processing benchmark results for IBM’s DB2 Universal Database software running on the new IBM eServer p5-570.