(Paul C. Zikopoulos) In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (“Rational AD”) product to create and work with IBM DB2 Universal Database (“DB2 UDB”) for Linux, UNIX, and Windows database connections.

(Jim Mason) Squirrel is a great tool for accessing any type of data anywhere using SQL! It’s great for developers, administrators, testers, even end-users needing to view, validate or update data anywhere. It works with every database I’ve tested ( MySQL, DB2/400, DB2, Oracle, SQL Server and more).

(Whei-Jen Chen, Hiromichi Shinozaki, Kevin Taylor, Marcia Miskimen and Yasir Warraich) IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creat

(Serge Rielau) The SQL language provides the concept of a schema to group SQL objects of all kinds together. Schemas can be understood as the SQL equivalent of directories in a file system. DB2 UDB for Linux, UNIX, and Windows traditionally has had strong support for the SQL schema concept, having s

(Anand Subramanian and Melody Ng) This paper discusses a low-cost high availability (HA) solution for the IBM DB2 Universal Database product (DB2 UDB) Version 8.2 on the Linux platform using the open source Linux-HA project (Heartbeat) and Distributed Replicated Block Device (DRBD) software packages

(Willie Favero) Over the last two weeks ( January 24, 2006, February 1, 2006, and February 9, 2006 ), I have posted a couple of entries about our System z9 Integrated Information Processor (zIIP) specialty engine. There is now a webcast scheduled to cover the zIIP along with some other items in a di

(C. M. Saracco) The new DB2 “Viper” release, now in beta, features a significant architectural departure from prior versions. For the first time since its debut, DB2 Universal Database for Linux, UNIX, and Windows is providing a new query language, new storage technology, new indexing technology, an

(Susan Lawson and Dan Luksetich) In today’s high performance computing environments we are bombarded with dynamic SQL more than we ever were in the past. Queries coming into our subsystems from products like DB2 Connect and Websphere are executed as dynamic SQL. This dynamic SQL creates problems suc

(Dan Scott) The stable release of the ibm_db2 PECL extension for IBM DB2, Cloudscape, and Apache Derby brought a high performing, highly functional database connectivity alternative to Unified ODBC for PHP 4 and 5 users. However, in and of itself a database extension does not enable you to use the m

(Nell Gawor and Lin Sun) IBM WebSphere Application Server Community Edition (Community Edition) includes Derby for its own use (see the sidebar for more information about the difference between Derby and IBM Cloudscape). Your Java 2 Platform, Enterprise Edition (J2EE) applications can also leverage