DB2 FOR LUW / DB2FORLUW / A10 - DB2

Issuing SET INTEGRITY IMMEDIATE CHECKED on a table that has 
indexes and XML columns may cause the DB2 server to terminate 
abnormally with the following error: 
 
SQL1034C  The database is damaged. All applications processing 
the 
      database have been stopped. 
 
Below is an example of the a db2diag.log entry from Linux: 
 
2017-01-20-12.24.48.079354-300 I120090E2091          LEVEL: Info 
PID     : 9297                 TID : 46912904358208  PROC : 
db2sysc 0 
INSTANCE: user                 NODE : 000            DB   : 
TESTDB 
APPHDL  : 0-52                 APPID: *N0.user.170120172423 
AUTHID  : USER                 HOSTNAME: hotel52 
EDUID   : 72                   EDUNAME: db2agntp (TESTDB) 0 
FUNCTION: DB2 UDB, base sys utilities, 
sqeLocalDatabase::ForceDBShutdown, probe:13769 
MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB 
shutdown agent ID 
          is: 
DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes 
0-52 
DATA #2 : sqeApplication_acbInfo, 
PD_TYPE_sqeApplication_acbInfo, 4 bytes 
x8000 
        - SQLEINDEX 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x00002AAAABC4C269 pdLog + 0x3B9 
  [1] 0x00002AAAAD7E777E 
_ZN16sqeLocalDatabase15ForceDBShutdownEi + 0x2BE 
  [2] 0x00002AAAAD660C08 
_Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 0x6F8 
  [3] 0x00002AAAAEE82319 
_Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP 
12SQLD_ID_LISTP9SQLP_LSN8 + 0x1159 
  [4] 0x00002AAAAF0665EE _Z10sqlriFetchP8sqlrr_cbP9sqlri_taol + 
0xAE 
  [5] 0x00002AAAAF0769E5 _Z7sqlritaP8sqlrr_cb + 0x515 
  [6] 0x00002AAAACCA908F _Z8sqlrievlP8sqlrr_cb + 0x12F 
  [7] 0x00002AAAACCA8552 _Z8sqlricseP8sqlrr_cb + 0xD2 
  [8] 0x00002AAAAF0702E9 _Z8sqlriftrP8sqlrr_cb + 0xB9 
  [9] 0x00002AAAAF0697BD 
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD 
  [10] 0x00002AAAAE401F5D _Z16sqlrr_dss_routerP8sqlrr_cb + 0x6CD 
  [11] 0x00002AAAACB92306 
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x4C6 
  [12] 0x00002AAAABF33576 /home/user/sqllib/lib64/libdb2e.so.1 + 
0x1252576 
  [13] 0x00002AAAABF327B4 _Z21sqleProcessSubRequestP8sqeAgent + 
0xE4 
  [14] 0x00002AAAABF4DA5D _ZN8sqeAgent6RunEDUEv + 0x71D 
  [15] 0x00002AAAACFE8F63 _ZN9sqzEDUObj9EDUDriverEv + 0xF3 
  [16] 0x00002AAAACFE8E69 _Z10sqlzRunEDUPcj + 0x9 
  [17] 0x00002AAAACA50071 sqloEDUEntry + 0x2A1 
  [18] 0x00002AAAAABCE2A3 /lib64/libpthread.so.0 + 0x62A3 
  [19] 0x00002AAAB30E514D __clone + 0x6D

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 Fix Pack 6                               * 
****************************************************************

First fixed in DB2 10.1 Fix Pack 6

not known / see Local fix

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

20.01.2017
02.03.2017
02.03.2017