DB2 FOR LUW / DB2FORLUW / B10 - DB2

Db2dart takes a very long time (hours) to complete on a 
column-organized table whereas it completes in a short time 
(minutes) on a row-organized table with same data size. 
 
In db2dart processing, while accesing pages, the integrity 
checks made on column-organized tables are different than on 
row-organized tables. 
This integrity check referred to as cross data-index check is 
not done for row organized tables. 
 
In this cross data-index check function, we access data pages 
based on an index map created for column-organized tables. Due 
to a problem in the sequence of some sub-functions in it, we 
require to do some extra processing to reach next page. This 
extra processing is causing the delays in the db2dart 
performance as it needs to be done for each page find. So the 
time required for db2dart scales up depending on the size 
(number of pages) of the column-organized table.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               * 
****************************************************************

Run INSPECT command instead of db2dart to inspect the 
column-organized tables.

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in Db2 11.1 Mod 3 Fix Pack 3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

09.08.2017
19.03.2018
19.03.2018