DB2 - Problem description
Problem IT24665 | Status: Closed |
SCAN OF COLUMNAR TABLE WITH SYNOPSIS COULD PRODUCE DUPLICATE ROWS IF UNCOMMITTED INSERTS OR UPDATES WERE DONE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
IN V11 FP3 OR V11 FP2 ONLY SCAN OF COLUMNAR TABLE COULD PRODUCE DUPLICATE ROWS WHEN SYNOPSIS TABLE IS USED. THIS CAN HAPPEN ONLY IF UNCOMMITED INSERTS OR UPDATES HAPPENED AGAINST THIS TABLE AS WELL. ANOTHER POSSIBLE SYMPTOM IS SQL0788N WHEN TRYING TO DO UPDATE FROM SELECT. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * COLUMNAR TABLES ONLY * **************************************************************** * PROBLEM DESCRIPTION: * * Please, See Error Description and install Db2 Version 11.1 * * Fix Pack m3ifx001 * **************************************************************** * RECOMMENDATION: * * Please, See Error Description and install Db2 Version 11.1 * * Fix Pack m3ifx001 * **************************************************************** | |
Local Fix: | |
turn off Synopsis table use using db2set DB2_CDE_SYNOPSIS=0 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.04.2018 24.07.2018 24.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |