DB2 FOR LUW / DB2FORLUW / A50 - DB2

1.  Problem description 
Error message "NON-FATAL ASSERTION FAILED!!!" keeps appearing in 
db2diag.log. 
 
2.  Operating system and level: 
DB2 10.1 + DB2 Spatial Extender 
 
3.  Diagnostic information 
2017-03-25-16.19.25.473000-240 I1408F1146           LEVEL: 
Severe 
PID     : 892                  TID : 3528           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
GISDB01 
APPHDL  : 0-3663               APPID: GA32C135.P396.170316024116 
AUTHID  : USER001              HOSTNAME: GISPRODSRV 
EDUID   : 3528                 EDUNAME: db2agent (GISDB01) 0 
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 
DATA #2 : String, 149 bytes 
NON-FATAL ASSERTION FAILED!!! 
ASSERTION EXPRESSION: Invalid block eye-catcher (0xF9C24ADC) 
found at: 
SOURCE FILENAME: db2/gseOss.cpp 
LINE NUMBER: 61 
CALLSTCK: 
  [0] 0x000007FEF81A028B pdLog + 0x3BB 
  [1] 0x000007FEF824D526 sqlzAssertFailedValist + 0x2A6 
  [2] 0x000007FEF9C1937C ossAssertFailureAction + 0xCC 
  [3] 0x000007FEF9C19725 ossAssertFailed + 0x35 
  [4] 0x000007FEF9C1AFCF ossMemAllocCheck + 0x72F 
  [5] 0x000007FEF9C1A7B5 ossMemFree + 0x55 
  [6] 0x000007FEE2089726 0x000007FEE2089726 + 0x0 
  [7] 0x0000000A8B752F50 0x0000000A8B752F50 + 0x0 
  [8] 0x000007FEE2185DB3 0x000007FEE2185DB3 + 0x0 
  [9] 0x0000000000000001 0x0000000000000001 + 0x0 
 
2017-03-25-16.19.26.081000-240 I2556F1130           LEVEL: 
Severe 
PID     : 892                  TID : 3528           PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000           DB   : 
GISDB01 
APPHDL  : 0-3663               APPID: GA32C135.P396.170316024116 
AUTHID  : USER001              HOSTNAME: GISPRODSRV 
EDUID   : 3528                 EDUNAME: db2agent (GISDB01) 0 
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 
DATA #2 : String, 133 bytes 
NON-FATAL ASSERTION FAILED!!! 
ASSERTION EXPRESSION: Invalid pad type (0x0) found at: 
SOURCE FILENAME: db2/gseOss.cpp 
LINE NUMBER: 61 
CALLSTCK: 
  [0] 0x000007FEF81A028B pdLog + 0x3BB 
  [1] 0x000007FEF824D526 sqlzAssertFailedValist + 0x2A6 
  [2] 0x000007FEF9C1937C ossAssertFailureAction + 0xCC 
  [3] 0x000007FEF9C19725 ossAssertFailed + 0x35 
  [4] 0x000007FEF9C1AF8D ossMemAllocCheck + 0x6ED 
  [5] 0x000007FEF9C1A7B5 ossMemFree + 0x55 
  [6] 0x000007FEE2089726 0x000007FEE2089726 + 0x0 
  [7] 0x0000000A8B752F50 0x0000000A8B752F50 + 0x0 
  [8] 0x000007FEE2185DB3 0x000007FEE2185DB3 + 0x0 
  [9] 0x0000000000000001 0x0000000000000001 + 0x0 
 
DB2 trace indicates the function gseBuildUnionAggr() is where 
the problem occurs. 
 
29610063    | | | | | | | | | | | | | | | gseBuildUnionAggr 
entry [eduid 3528 eduname db2agent] 
... 
29728837    | | | | | | | | | | | | | | | gseBuildUnionAggr data 
[probe 200] 
... 
29757641    | | | | | | | | | | | | | | | | GseOssFree entry 
[eduid 3528 eduname db2agent] 
29758263    | | | | | | | | | | | | | | | | GseOssFree exit 
29759263    | | | | | | | | | | | | | | | | GseOssFree entry 
[eduid 3528 eduname db2agent] 
29760391    | | | | | | | | | | | | | | | | | pdLog entry [eduid 
3528 eduname db2agent] 
29761373    | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk 
entry [eduid 3528 eduname db2agent] 
29762488    | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk 
data [probe 10] 
29763773    | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk 
data [probe 20] 
29764646    | | | | | | | | | | | | | | | | | | pdIsDiagLevelOk 
data [probe 500].. 
29809058    | | | | | | | | | | | | | | | | | | | 
sqlzAssertFailed data [probe 10]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

06.04.2017
27.09.2017
27.09.2017

9.0.