(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes queries that compare data in an IBM DB2 database. This is accomplished by using either CASE expressions or subqueries. This tutorial is Part 5 of the SQL & XQuery tutorial for IBM DB2 series. (R)

(Alex Osuna, Jeremy Brumer, Jawahar Lal and Roger Sanders) Database cloning is process by which you can create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore. Database cloning is performed frequently by database administr

(Kondal) In part 1 of this article I have discussed on how to improve DB2 Connect performance accessing databases residing on z/OS host server. In the part two of this article I would like to shows you to access databases residing on AIX (distributed side) as well as z/OS platform.

(Charles Babcock) An open source competitor is zeroing in on Oracle’s customer base—and it’s not the popular and well known MySQL open source database. It’s a relative newcomer called EnterpriseDB Advanced Server.

(Willie Favero) Over the years, I have been asked many times what the secondary allocation should be for a page set. In fact, does any one remember the old debates we used to have on the web about how a secondary extent is calculated? Ya, sizing a table space has always, since the very first days of

(Cynthia M. Saracco) DB2 9 offers significant new support for XML, which Java application developers can begin to use with minimal effort. That’s because DB2 9 enables programmers to query, insert, update, and delete XML data — as well as traditional SQL data — using familiar JDBC statements and ind

(Sean McCown) IBM’s newly released DB2 9.1 (previously code-named “Viper”) sheds many of the limitations of DB2 8, boosting performance, scalability, and security. But one feature in particular, the hybrid XML/relational engine, gives this Big Blue serpent its distinctive shape. For customers plungi

(Debra R. Eaton) The IBM DB2 Developer Workbench (DWB) gives DB2 9 database developers the ability to develop database application objects that access data. DWB is based on Eclipse technology, which replaces the Swing-based DB2 V8 Development Center. Get an introduction to the Eclipse User Interface

(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes how to write queries that require basic data analysis. Many of the queries contain sequential calculations, or calculations that operate on an ordered set of rows–queries frequently encountered during business analysis. On-Line

(Hai feng Li and Art Kaufmann) Many enterprises have a requirement to integrate heterogeneous data. Data may be stored in different brands of relational data management systems (RDBMSs), nonrelational servers, and specialized application systems.