DB2 Version 9.1 Fix Pack 2a - interim special build 2a

Downloadable files


Abstract

DB2® Version 9.1 interim special build 2a is available for download for AIX®, Linux®, Linux AMD 64-bit, Windows® 32 and 64-bit environments.

Download Description

DB2 Version 9.1 interim special build 2a contains 15 important APARs that could potentially affect you. If you are encountering any of the problems described in the APARs, below, it is recommended that you install interim special build 2a. The special build is not an official fix pack but it does go through testing like an official fix pack.

Along with the 15 APARs below, interim 2a also includes the APARs from Fix Pack 2.


APAR fixes included in interim 2a
APAR No. Abstract
IZ07497 SMP GRANULARITY OF 1 CAN DEGRADE PERFORMANCE.
IY92819 DEGRADED PERFORMANCE IN DB2 V9 WHEN CALLING SQL PROCEDURES THAT USE LOB PARAMETERS OR VARIABLES.
IY93078 DB2TAPEMGR FAILS WITH ERROR SQL1031N THE DATABASE DIRECTORY CANNOT BE FOUND ON THE INDICATED FILE SYSTEM.
IY95034 CREATE DECLARE GLOBAL TEMP TABLE STATEMENT CAUSES DATABASE CRASH
IY95759 A DB2 32bit CLIENT PROCESS CAN HANG IN SQLCCTCPSEND IN DB2 V9 FIXPAK 2 ON AIX
IY96297 DURING QUERY COMPILE, A DIFFERENT OPTIMIZATION LEVEL THAN THE ONE INTENDED MAY BE USED.
JR25879 TABLES ASSOCIATED WITH WRONG DATABASE IN GLOBAL TABLE SNAPSHOT
JR25882 WRONG RESULTS FROM OUTER JOIN OR MERGE WHEN ON CLAUSE CONTAINS ONLY CORRELATED COLUMNS; CONSTANTS; HOST OR REGISTER VARIABLES
JR26019 REPLICATION CENTER - CHAR (255) ZOS COLUMN DOES NOT MAP TO A CHAR(254) COLUMN IN LUW
JR26235 SQL0926N FOLLOWED BY SQL0998N RC=16, SUBCODE=4 WHEN ENLISTING A TRANSACTION WITH DB2 .NET DATA PROVIDER
LI71612 DB2PDBC MAY CAUSE A NODE HANG IN A PARTITIONED ENVIRONMENT
LI71828 APPLICATION TRAPS DUE TO A RACE CONDITION BETWEEN THE DISCONNECTING APPLICATION AND THE EVENT MONITOR EDU.
LI71846 DB2 hang due to agent looping inside the sqliTryToCleanup, sqliTestDeletedMDCRidLock functions.
LI71988 DBT2036W OR SQL2036N ENCOUNTERED WHILE ATTEMPTING TO USE A TAPE DEVICE.

Prerequisites

System requirements for DB2 Version 9.1 database products.

Download package


Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
What is Fix Central (FC)?
2a for AIX DB2 (32 & 64-bit) 5/9/2007 English 1 FTP
2a for Linux (32-bit Intel & AMD) 5/9/2007 English 1 FTP
2a for Linux (64-bit AMD64 & EM64T) 5/9/2007 English 1 FTP
2a for Windows (32-bit Intel & AMD) 5/9/2007 English 1 FTP
2a for Windows (AMD- 64 bit) 5/9/2007 English 1 FTP

Technical support

In the United States and Canada dial 1-800-IBM-SERV
Contacts for other countries
Open a Service Request with DB2 support.


More Information
DB2 9.1 product, feature and packaging information for;
     » DB2 Database products
     » DB2 Connect products

DB2 Express-C -- Fix Packs are NOT available for DB2 Express-C from this page. To download the free to develop, deploy, and distribute DB2 Express-C product, and any of its fixes, go to DB2 Express-C Homepage.

Problems (APARS) fixed
GG04712, GG04713, GG04715, GG04717, GG04718, GG04719, GG04724, IY80872, IY83500, IY86019, IY86711, IY89502, IY91690, IY92494, IY93082, IY94275, JR22767, JR25306, JR25496, JR25864, IY87035, IY89605, IY91712, IY92505, IY93366, IY94276, JR24512, JR25308, JR25505, JR25869, IY87157, IY89894, IY92017, IY92517, IY93592, IY94290, JR24535, JR25321, JR25520, JR25886, IY87184, IY90025, IY92058, IY92521, IY93622, IY94291, JR24620, JR25370, JR25529, JR25972, IY87305, IY90252, IY92124, IY92525, IY93645, IY94339, JR24683, JR25372, JR25560, LI71369, IY87492, IY90516, IY92125, IY92577, IY93648, IY94419, JR24729, JR25376, JR25624, LI71377, IY87908, IY90549, IY92167, IY92578, IY93728, IY94431, JR24739, JR25386, JR25635, LI71435, IY88816, IY90663, IY92178, IY92579, IY93741, IY94505, JR24809, JR25411, JR25658, LI71485, IY88823, IY90491, IY92184, IY92581, IY93834, IY94512, JR24989, JR25412, JR25703, LI71571, IY88862, IY91099, IY92252, IY92729, IY93908, IY94812, JR24996, JR25414, JR25725, LI71605, IY88939, IY91199, IY92264, IY92794, IY94113, IY94817, JR25074, JR25417, JR25800, LI71612, IY89024, IY91240, IY92272, IY92890, IY94187, IY94827, JR25109, JR25424, JR25839, LI71681, IY89110, IY91411, IY92432, IY92954, IY94204, IY94833, JR25128, JR25445, JR25854, LI71716, IY89135, IY91553, IY92435, IY93033, IY94240, IY95088, JR25203, JR25450, JR25859, LI71775, IY89312, IY91622, IY92464, IY93055, IY94259, IY95135, JR25219, JR25456, JR25860, LI71791, JR25861, LI71802, LI71814, LI71821, LI71836, LI72046, GG04667, IY78939, IY79907, IY82103, IY83826, IY83840, IY84009, IY84169, IY84906, IY86014, IY86072, IY87226, IY87631, IY87846, IY88126, IY88965, IY89975, IY91859, JR24389, JR24840, IY86139, IY87244, IY87644, IY87880, IY88137, IY89097, IY89977, IY92040, JR24436, JR24873, IY86380, IY87286, IY87649, IY87914, IY88143, IY89182, IY90141, IY92057, JR24444, JR24878, IY86397, IY87289, IY87661, IY87918, IY88158, IY89198, IY90155, IY92119, JR24461, JR24880, IY86481, IY87294, IY87739, IY87923, IY88174, IY89210, IY90156, IY92153, JR24486, JR24905, IY86508, IY87295, IY87740, IY87924, IY88260, IY89233, IY90195, JR23668, JR24523, JR24907, IY86605, IY87313, IY87754, IY87925, IY88336, IY89345, IY90196, JR23770, JR24524, JR25001, IY86656, IY87346, IY87786, IY87959, IY88507, IY89354, IY90532, JR23805, JR24533, JR25023, IY86809, IY87409, IY87808, IY87960, IY88518, IY89364, IY90586, JR23820, JR24554, JR25132, IY86815, IY87490, IY87822, IY87965, IY88529, IY89653, IY90984, JR23973, JR24572, JR25229, IY86856, IY87498, IY87824, IY87969, IY88531, IY89735, IY91011, JR23999, JR24581, JR25314, IY86922, IY87518, IY87825, IY87974, IY88550, IY89744, IY91403, JR24109, JR24698, JR25332, IY86943, IY87551, IY87826, IY87990, IY88554, IY89789, IY91715, JR24139, JR24701, JR25333, IY87047, IY87605, IY87829, IY87995, IY88589, IY89812, IY91788, JR24152, JR24703, JR25415, IY87212, IY87611, IY87831, IY88025, IY88702, IY89813, IY91807, JR24163, JR24723, LI70947, IY88124, IY87625, IY87845, IY88087, IY88714, IY89864, IY91845, JR24289, JR24726, LI71015, IY88107, IY88124, IY88832, IY89968, IY91858, JR24375, JR24799, LI71190, LI71351, LI71368, LI71370, LI71374, LI71385, LI71388, LI71392, LI71396, LI71410, LI71490, LI71492, GG04709, IY89768, IY92819, IY93078, IY95034, IY95759, IY96297, JR25879, JR25882, JR26019, JR26235, LI71612, LI71828, LI71846, LI71988

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Installation - Fix Pack

Software version:

9.1

Operating system(s):

AIX, Linux, Windows

Reference #:

4015789

Modified date:

2009-05-29

Translate my page

Machine Translation

Content navigation