Best DB2 Articles and News

This document contains links to download DB2® Version 9.7 Fix Pack 1 (FP1) from Fix Central for AIX, HP-UX, Linux, Solaris, and Windows operating system platforms.

Fix Pack 1 for IBM Data Server Client Packages V9.7 is now available for download from Fix Central for the following operating system platforms: AIX, HP-UX, Linux, Solaris, Window

Search for High-Impact PERvasive (HIPER) APARs, Special Attention APARs, Shipped APARs, Open APARs, and APARs fix packs for DB2® Version 9.7 for Linux, UNIX® and Windows®.

Contains list of shipped APARs for DB2 Version 9.7 for Linux, UNIX and Windows products, sorted as APARs by fix pack in the following listing.

This page contains a list of manuals in Portable Document Format (PDF) files that have been translated for DB2 V9.7 and additional components such as DB2 Connect™ and InfoSphere Federation Server.

Why have unfenced external routines been converted to FENCED and NOT THREADSAFE after upgrading to DB2 9.7?

Download location of DB2® Net Search Extender V9.1 Fix Pack 8 ( NSE V9.1.08)

Some DB2 operations fail when domain userid is used. This fails if the workstation is running Windows 2008R2 or Windows 7 and the Domain controller is a Windows 2000 machine.

We discuss the latest news about DB2 for z/OS, including the changes in disks, IBM System z9 and z10 Integrated Information Processor or zIIP and new z10 processors. Then the discussion will move DB2 9 for z/OS, with XML and SQL that is more consistent across the DB2 family. Utility enhancements help with new function, more LOB and XML support, better performance and improved availability, removing the BUILD2 step from online reorg. DB2 9 enhances DB2’s ability to handle new web and enterprise applications.

In this IBM® Redbooks® publication, we describe the new DB2 Oracle Database compatibility features. The latest version of DB2® includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features dramatically improve the ease of developing applications that run on both DB2 and Oracle, and simplify the process of moving from Oracle to DB2. In addition, IBM now provides rich tooling to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by way of the Optim™ Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, best practices for moving to DB2, and how to handle some common scenarios. It is now dramatically easier than ever to move to DB2 and experience the benefits of the IBM industry leading database, which offers a lower cost of ownership, ease of use, storage savings, industry leading performance, and superior customer support. Within six weeks of DB2 9.7 becoming generally available, scores of companies had already reported very high compatibility between the code they developed for Oracle and what they were experiencing with DB2 9.7. These companies reported out-of-the-box compatibility rates between 90%-100% (measured by the percentage of statements that required modification), with typical compatibility in the high 90s. These statistics come