DB2 - Problem description
Problem IT36654 | Status: Closed |
LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~2-5 GB) DATA, AFTER LOADCOPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Running with large number of LOADs with large amount of LOB data(about or more than 2-5 GB), then in a HADR standby (or analogous rollforward scenario), after the load copy image file is replayed/processed, some LOBA page may be written into wrong location in the tablespace, thus leading to data corruption. "large amount" is typically a few GBs, but unfortunately we cannot describe it more precisely, as it depends on tablespace extent size, and also whether we have lots of smaller LOBs vs fewer number of larger LOBs. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.04.2021 21.11.2021 21.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |