|
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) |
