IBM Support

DB2 9.5 FP6 and DB2 9.7 FP3 fix pack images have been replaced.

Flashes (Alerts)


Abstract

The fix pack images for DB2 9.7 FP3 and DB2 9.5 FP6 have been replaced with images containing fixes for two Hiper APARs.

Content

DB2 9.7 FP3 and DB2 9.5 FP6
Replaced with
DB2 9.7 FP3_special and DB2 9.5 FP6a
Audience:  All users who requesting the following fix packs:
  • DB2 Version 9.7 fix pack 3
  • DB2 Version 9.5 fix pack 6
What changed?
The fix packs (9.7 FP3 and 9.5 FP6) were removed from Fix Central due to two Hiper APARs that could effect all users. These APARs may cause serious issue with the Query Rewrite component if installed. Fixes for the two Hiper APARs were created and delivered in the following replacement fix packs:
DB2 9.7 FP3_special and DB2 9.5 FP6a.
.
APARs: The two Hiper APARs that were discovered are:
.
V9.5
FP6
V9.7
FP3
ABSTRACT
Executing a query with left outer join and an IS NULL predicate may cause a reverse column output or produce a SQL0901N error
Possible incorrect result on recursive views which joins to a table on a unique column
.
When did this happen?The fix packs were removed on September 17, 2010.
The replacements were uploaded on September 30, 2010.
Action required:Please use the updated fix packs to obtain the fixes for the Hiper APARs.

There are two build numbers for DB2 9.7 FP3_special;
    UNIX platforms _25384
    Windows platforms _25387

Contact DB2 Technical Support if you require a special build on top of DB2 9.7 FP3_special or DB2 9.5 FP6a
.
Support:In the United States and Canada dial 1-800-IBM-SERV
View support a contacts for other countries
Open a Service Request with DB2 Technical Support
.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Fixpak","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 September 2022

UID

swg21447191