DB2 - Problem description
Problem IC80312 | Status: Closed |
LONG COLUMN DATA CAN BE CORRUPTED ON HP PLATFORM IN DB2 V9.7 FP4, WHEN DATA IS WRITTEN AND READ IN PARALLEL | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Due to some product changes in DB2 V9.7 FP4, LONG column data can be corrupted on HP platform, when several agents do writes and reads on the same LONG column in parallel. db2dart and db2inspect will not detect such a kind of corruption. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL Users on HP Platform * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 6. * **************************************************************** | |
Local Fix: | |
Use LOB column type instead of LONG on HP platform, when possible. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.7 Fix Pack 6. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC80315 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.12.2011 14.12.2012 14.12.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP6 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.6 |