This document answers some of the more Frequently Asked Questions related to DB2 UDB Version 7 to Version 8 migration.

(John Stellrecht) DB2 was a leader in the paradigm shift to relational databases. Before this change occurred, data management was a growing problem in many organizations. Most departments within an organization had a set of master files resulting in multiple instances of some data elements. The cha

If a table space name has been changed since the backup operation you want to restore from, and you use the new name when you issue a table level restore operation, the required chain of backup images from the database history will not be generated correctly and an error will occur (SQL2571N).

(James Niccolai) IBM has released a big upgrade to its Informix database and plans to offer a new “Express” edition of the product, aimed at smaller businesses, by the middle of the year.

(Ron Turull) After all these years, journaling is still a seldom-used and rarely understood feature of OS/400-i5/OS and its integrated database, DB2 UDB for iSeries (formally DB2/400). Many sites simply don’t know how to set it up properly to perform its chief function of providing another level of

(Alicia Harvey, Travis Jeanneret, Thiam Cheng Lee, Rangarajan S Manavalan and Marty Trice) This IBM Redbook describes the major phases in a business integration project. First we discuss the planning and system design phase for a business integration infrastructure that should be able to support sev

(Roger Sanders) What exactly do the terms plan and package mean in a DB2 UDB for Linux, Unix, and Windows context? Is it possible to run an application with only a package?

(Ed Scannell) IBM bolstered its mainframe-based software strategy, rolling out an improved suite of Tivoli-based systems management tools to be part of an infrastructure management solution for its zSeries.

(Chris Peters) This month, we take up the Open Database Connectivity (ODBC) technology, the patriarch of Windows data communications.

(Dan Scott) Learn how to configure IBM Cloudscape 10.0 and IBM DB2 Universal Database (DB2 UDB) Version 8.2 servers for access from PHP 4.x and PHP 5.x. Write database applications using the Unified ODBC extension. Overcome common performance issues due to scrollable cursors and avoid functional lim