https://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0The latest updates about DB2 for Linux UNIX and Windowsen-USCopyright 2007 IBM Corporation. All rights reservedcssadmin@us.ibm.com (CSN Administrator)Wed, 25 Nov 2009 17:41:28 GMTThu, 26 Nov 2009 02:07:38 GMThttp://www.ibm.com/i/ibm_logo_120x60.gifhttps://www-947.ibm.com/systems/support/myview/subscription/css.wss/folders?methodName=listMyFolders&navBar=0&tabInd=0http://www.ibm.com/support/docview.wss?uid=swg24025208&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPDU&mync=RFix 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, WindowUpdatesDownloads and driversswgimgmt.swg24025208Wed, 25 Nov 2009 17:41:28 GMThttp://www.ibm.com/support/docview.wss?uid=swg21412439&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPDU&mync=RSearch 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®.Problem solving informationTechnotes(FAQs)swgimgmt.swg21412439Wed, 25 Nov 2009 17:34:47 GMThttp://www.ibm.com/support/docview.wss?uid=swg21412438&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPDU&mync=RContains 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.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21412438Wed, 25 Nov 2009 17:31:01 GMThttp://www.ibm.com/support/docview.wss?uid=swg24023357&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPDU&mync=RThis 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.UpdatesDownloads and driversswgimgmt.swg24023357Wed, 25 Nov 2009 17:23:38 GMThttp://www.ibm.com/support/docview.wss?uid=swg21412182&myns=swgimgmt&mynp=OCSSEPGG&mync=RFix Pack 1 for DB2 V9.7 is now available which includes fixes for some security vulnerabilities and HIPER APARs. These fixes, where applicable, are also available in Fix Pack 18 for DB2 Version 8, Fix Pack 8 for DB2 Version 9.1 and Fix Pack 4 for DB2 Version 9.5 IBM® recommends that you review the APAR descriptions and deploy one of the above fix packs to correct them on your affected DB2 installations.Flashesswgimgmt.swg21412182Wed, 25 Nov 2009 16:22:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27009474&myns=swgimgmt&mynp=OCSSEPGG&mync=RDB2® database product documentation by product version is available by accessing the DB2 Information Center online, downloading the DB2 Information Center, or downloading documentation in Portable Document Format (PDF).ManualsProduct information and publicationsswgimgmt.swg27009474Wed, 25 Nov 2009 10:07:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21411738&myns=swgimgmt&mynp=OCSSEPGG&mync=RThe Korean version of the Information Center for IBM DB2 9.7 for Linux, UNIX and Windows Version 9.7 Fixpack 1 contains documentation for Version 9.7 and does not contain additions or updates applicable to Version 9.7 Fixpack 1, whether you access the on-line Information or from a locally installed Information Center.Flashesswgimgmt.swg21411738Tue, 24 Nov 2009 13:25:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27015149&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPGA&mynp=OCSSEPFH&mynp=OCSSEPDU&mynp=OCSSYUVL&mync=RThis 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.ManualsProduct information and publicationsswgimgmt.swg27015149Tue, 24 Nov 2009 09:33:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg27015148&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPGA&mynp=OCSSEPFH&mynp=OCSSEPDU&mync=RThis page contains a list of English documentation in Portable Document Format (PDF) files for DB2 Version 9.7 and additional components such as DB2 Connect™ and InfoSphere Federation Server.ManualsProduct information and publicationsswgimgmt.swg27015148Mon, 23 Nov 2009 14:40:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21407663&myns=swgimgmt&mynp=OCSSEPGG&mync=RWhy have unfenced external routines been converted to FENCED and NOT THREADSAFE after upgrading to DB2 9.7?Problem solving informationTechnotes(FAQs)swgimgmt.swg21407663Thu, 19 Nov 2009 08:13:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg24024133&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPFH&mync=RDownload location of DB2® Net Search Extender V9.1 Fix Pack 8 ( NSE V9.1.08)Downloads and driversUpdatesswgimgmt.swg24024133Wed, 18 Nov 2009 22:48:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21410940&myns=swgimgmt&mynp=OCSSEPGG&mync=RSome 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.Problem solving informationTechnotes(Troubleshooting)swgimgmt.swg21410940Fri, 13 Nov 2009 15:11:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21297335&myns=swgimgmt&mynp=OCSSEPGG&mync=RHow can my application written in Perl access my DB2 UDB Version 8, 9 and above database for LUW?Problem solving informationTechnotes(FAQs)swgimgmt.swg21297335Tue, 10 Nov 2009 09:23:00 GMThttp://www.redbooks.ibm.com/abstracts/SG247736.html?Open&myns=swgimgmt&mynp=OCSSEPGG&mync=RIn 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 RedbooksProduct information and publicationsswgimgmt.rdb1SG247736Fri, 06 Nov 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21409498&myns=swgimgmt&mynp=OCSSEPGG&mync=RHow do you remove a DB2 license from a Linux, Unix, or Windows machine?Problem solving informationTechnotes(FAQs)swgimgmt.swg21409498Thu, 05 Nov 2009 12:53:15 GMThttp://www.ibm.com/support/docview.wss?uid=swg21409407&myns=swgimgmt&mynp=OCSSEPGG&mync=RWhen performing restore in which you are redefining tablespace containers (called a redirected restore) you may get "SQL1350N Reason code="3". This can happen if you try to issue a command other than a "SET TABLESPACES" command or if you have not provided a syntactically correct command "SET TABLESPACES" commandProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21409407Thu, 05 Nov 2009 01:49:08 GMThttp://www.ibm.com/support/docview.wss?uid=swg21386486&myns=swgimgmt&mynp=OCSSEPGG&mync=RYou receive the following error message when setting up an XA connection using JDBC and Websphere: SQL OPEN for a held cursor was issued on a XA connection ERRORCODE=-4496, SQLSTATE=nullProblem solving informationTechnotes(Troubleshooting)swgimgmt.swg21386486Tue, 03 Nov 2009 11:21:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21223978&myns=swgimgmt&mynp=OCSSEPGG&mync=RThis document covers the changes and conversions that happen when you install DB2 UDB Version 8.2 (DB2 UDB Version 8.1 FixPak 7) or a higher level on a server that already has DB2 UDB Version 8.1 (up to FixPak 6 level) installed.Problem solving informationPreventative Service Planningswgimgmt.swg21223978Tue, 03 Nov 2009 09:20:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21313253&myns=swgimgmt&mynp=OCSSEPGG&mync=RUpgrading to DB2® Version 9.7 might require upgrading your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Upgrading these components requires an understanding of the DB2 database product upgrade concepts and the DB2 database products. This roadmap will help you navigate through the available information and resources related to upgrading from DB2 Universal Database (DB2 UDB®) Version 8, DB2 LUW Version 9.1, or DB2 LUW Version 9.5 to DB2 VersionProblem solving informationPreventative Service Planningswgimgmt.swg21313253Tue, 03 Nov 2009 09:14:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21227459&myns=swgimgmt&mynp=OCSSEPGG&mync=RThis document will help you navigate through the available information and resources related to upgrading from DB2 Universal Database (UDB) Version 7 to DB2 UDB Version 8.Problem solving informationTechnotes(FAQs)swgimgmt.swg21227459Tue, 03 Nov 2009 09:12:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21227461&myns=swgimgmt&mynp=OCSSEPGG&mync=RUpgrading to DB2® Version 9 might require migration of your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Migrating these components requires an understanding of the DB2 database product migration concepts and the DB2 database products. This roadmap will help you navigate through the available information and resources related to upgrade from DB2 UDB Version 8 to DB2 Version 9 .Problem solving informationTechnotes(FAQs)swgimgmt.swg21227461Mon, 02 Nov 2009 19:25:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21254493&myns=swgimgmt&mynp=OCSSEPGG&mync=RUpgrading to DB2® Version 9.5 might require migration of your environment components. These components are DB2 servers, clients, database applications, and routines. Migrating these components requires an understanding of the DB2 database product migration concepts and the DB2 database products. This roadmap will help you navigate through the available information and resources related to upgrading from DB2 Universal Database (DB2 UDB®) Version 8 or DB2 LUW Version 9.1 to DB2 Version 9.5Problem solving informationPreventative Service Planningswgimgmt.swg21254493Mon, 02 Nov 2009 19:15:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21295194&myns=swgimgmt&mynp=OCSSFVXC&mynp=OCSSEPGG&mync=RThis document describes the current software and firmware stack validated for the InfoSphere Balanced Warehouse D5100 for Linux.Flashesswgimgmt.swg21295194Mon, 02 Nov 2009 12:40:00 GMThttp://www.redbooks.ibm.com/redpieces/abstracts/SG247736.html?Open&myns=swgimgmt&mynp=OCSSEPGG&mync=RIn 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 RedbooksProduct information and publicationsswgimgmt.rdb1SG24773600Tue, 27 Oct 2009 04:00:00 GMThttp://www.ibm.com/support/docview.wss?uid=swg21165448&myns=swgimgmt&mynp=OCSSEPGG&mynp=OCSSEPDU&mync=RThis document describes known AIX® issues and APARs related to DB2®. Fixes for the AIX APARs described below can be obtained from Fix Central at http://www.ibm.com/eserver/support/fixes/fixcentral/main/pseries/aixFlashesswgimgmt.swg21165448Mon, 26 Oct 2009 16:24:00 GMThttp://www.ibm.com/legal/us/Terms of UseTerms and conditionshttp://www.ibm.com/legal/us/