home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99041 Status: Closed

DIVIDE BY ZERO TRAP IN PAGE_AGE CODE IN SQLPCHECKFORBAFLSH

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
The trap occurs with this call stack: 
 
2014-01-12-08.30.06.156758-300 I289911E3230          LEVEL: 
Event 
PID     : 3076                 TID : 46912833055040  PROC : 
db2sysc 2 
INSTANCE: abdce30             NODE : 002            DB   : DBABC 
APPHDL  : 1-68                 APPID: *N1.DB2.140112125247 
AUTHID  : MYUSER                HOSTNAME: hostabc 
EDUID   : 188                  EDUNAME: db2evmtp (WLM_STATS_MON) 
2 
FUNCTION: DB2 UDB, oper system services, 
sqloPGRPRegisterOneCrash, probe:2154 
MESSAGE : lastCrashCount 
DATA #1 : unsigned integer, 8 bytes 
0 
DATA #2 : String, 10 bytes 
inRecovery 
DATA #3 : Boolean, 1 bytes 
false 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x00002AAAABE316AE pdLog + 0x38E 
  [1] 0x00002AAAAE28EAFD sqloPGRPRegisterOneCrash + 0x17D 
  [2] 0x00002AAAAE2D53B1 sqloEDUCodeTrapHandler + 0x871 
  [3] 0x00002AAAAACD7CA0 /lib64/libpthread.so.0 + 0xECA0 
  [4] 0x00002AAAACBC0482 
_Z18sqlpCheckForBaflshP14sqlpMasterDbcbmm + 0x162 
  [5] 0x00002AAAAF118631 
_Z14sqlpWriteToLogP8sqeAgentmmmP14SQLP_LREC_PARTP9SQLP_LSN8Pm + 
0xCF1 
  [6] 0x00002AAAAF11ACB4 
_Z11sqlpWriteLRP8sqeAgentmmmmmP14SQLP_LREC_PARTmP9SQLP_LSN8Pm + 
0x304 
  [7] 0x00002AAAABDCFA17 
_Z11sqlpWriteLRP8sqeAgentmmmmmP14SQLP_LREC_PARTmP9SQLP_LSN8 + 
0x17 
  [8] 0x00002AAAAD82E690 
_Z15sqldxLogLobDataP9SQLDX_LWAhhtPK12SQLDX_IOPARMPc + 0x280 
  [9] 0x00002AAAAC0B28C5 
_Z17sqldxWriteLobDataP9SQLDX_LWAhtPK12SQLDX_IOPARMPc + 0x415 
  [10] 0x00002AAAAC0B8846 
_Z15sqldxReplaceLobP9SQLDX_LWAhtP8SQLDX_LDjiPcj + 0x136 
  [11] 0x00002AAAAC0B8519 
_Z14sqldxCreateLobP9SQLDX_LWAhtiiPciP8SQLDX_LD + 0xE9 
  [12] 0x00002AAAAC0AEBA2 
_Z14sqldxLobCreateP8sqeAgentP8SQLD_TCBhtiiPciP8SQLDX_LD + 0x92 
  [13] 0x00002AAAABFE6892 
_Z8sqldmadxP8sqeAgentP8SQLD_TCBhtP9sqllf_csoiiP8SQLD_LFDPm + 
0x252 
  [14] 0x00002AAAABFE5B68 
/var/ibmdb2/nypxt430/sqllib/lib64/libdb2e.so.1 + 0x10FFB68 
  [15] 0x00002AAAAEFB036A 
 
_Z22sqldFullFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_ 
VALUEmP8SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB + 
 
0xDCA 
  [16] 0x00002AAAAEFC9417 
_Z13sqldRowInsertP8sqeAgenttthmiPP10SQLD_VALUEP13SQLD_TDATARECP8 
SQLZ_RID + 0x19F7 
  [17] 0x00002AAAAF171AA9 
 
_Z8sqlrinsrP8sqlrr_cbttitPP10SQLD_VALUEN10sqlri_iudo11t_iudoFlag 
s17t_iudoFlagsKernelEP8SQLZ_RID + 0x79 
  [18] 0x00002AAAADB89504 
_ZN17sqm_evmon_ttarget10write_dataEPcjP17sqmRequestMetrics + 
0x14E4 
  [19] 0x00002AAAADB81FE5 
_ZN16sqm_evmon_target16prepAndWriteDataEPcj + 0xF5 
  [20] 0x00002AAAADB9403A 
_ZN14sqmEvmonBuffer10write_dataEP16sqm_evmon_target + 0x7A 
  [21] 0x00002AAAAC410308 _ZN14sqmEvmonWriter11evmonWriterEv + 
0x7F8 
  [22] 0x00002AAAAC41489D 
_ZN14sqmEvmonWriter9startMeUpEP12sqzDataChainI9sqmTarget16sqzCha 
inNodeBaseIS1_EERbb + 
 
0x149D 
  [23] 0x00002AAAADB712F2 
_Z26sqlm_bds_start_monitor_hdlP8sqeAgentb + 0x552 
  [24] 0x00002AAAAC0FE291 
/var/ibmdb2/nypxt430/sqllib/lib64/libdb2e.so.1 + 0x1218291 
  [25] 0x00002AAAAC0FD8F3 _Z21sqleProcessSubRequestP8sqeAgent + 
0xE3 
  [26] 0x00002AAAAC117FB4 _ZN8sqeAgent6RunEDUEv + 0x604 
  [27] 0x00002AAAAD0FDAB3 _ZN9sqzEDUObj9EDUDriverEv + 0xF3 
  [28] 0x00002AAAAD0FD9B9 _Z10sqlzRunEDUPcj + 0x9 
  [29] 0x00002AAAACB8A861 sqloEDUEntry + 0x2A1 
  [30] 0x00002AAAAACCF83D /lib64/libpthread.so.0 + 0x683D 
  [31] 0x00002AAAB349BF8D clone + 0x6D 
 
2014-01-12-08.31.52.705833-300 I293142E505           LEVEL: 
Error 
PID     : 3117                 TID : 46912781500384  PROC : 
db2vend (PD Vendor Process - 29) 
INSTANCE: abdce30             NODE : 000 
HOSTNAME: hostabc 
FUNCTION: DB2 UDB, oper system services, DB2VEND_main, 
probe:1040 
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not 
exist" 
          DIA8506C Unexpected end of file was reached. 
DATA #1 : String, 63 bytes 
Fenced vendor process pipe failure, terminating vendor process. 
 
2014-01-12-08.31.52.786604-300 E293648E594           LEVEL: 
Severe 
PID     : 3073                 TID : 46912791112000  PROC : 
db2wdog 2 [abdce30] 
INSTANCE: abdce30             NODE : 002 
HOSTNAME: hostabc 
EDUID   : 2                    EDUNAME: db2wdog 2 [abdce30] 
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 
MESSAGE : ADM0503C  An unexpected internal processing error has 
occurred. All 
          DB2 processes associated with this instance have been 
shutdown. 
          Diagnostic information has been recorded. Contact IBM 
Support for 
          further assistance. 
 
 
From the trap file we can see the trap with signal #8: 
 
</Siginfo_t> 
Signal #8 (SIGFPE): si_addr is 0x00002AAAACBC0482, si_code is 
0x00000001 (FPE_INTDIV:Integer divide by zero.) 
</SignalDetails> 
 
<StackTrace> 
Raw stack dump. Stack top is at 0x00002AAABEBFFF20. 
0x00002AAABEBF2D50 : B4B5 4447 253F 0000 6C95 4447 253F 0000 
..DG%?..l.DG%?.. 
0x00002AAABEBF2D60 : 0000 0000 0000 0000 00D1 47E8 AA2A 0000 
..........G..*.. 
0x00002AAABEBF2D70 : 80AB 17D9 AA2A 0000 003B 17D9 AA2A 0000 
.....*...;...*.. 
0x00002AAABEBF2D80 : 0100 0000 0000 0000 3186 11AF AA2A 0000 
........1....*.. 
0x00002AAABEBF2D90 : 0200 0000 0000 0000 ED2C 45B3 AA2A 0000 
.........,E..*.. 
0x00002AAABEBF2DA0 : E07E 8CD5 AC2A 0000 128D FAAB AA2A 0000 
.~...*.......*.. 
0x00002AAABEBF2DB0 : 00E0 D189 AD2A 0000 0000 0000 0000 0000 
.....*.......... 
0x00002AAABEBF2DC0 : E0BC 50B2 AA2A 0000 0000 0000 0000 0000 
..P..*.......... 
0x00002AAABEBF2DD0 : 0000 0000 0000 0000 4CC8 F9AE AA2A 0000 
........L....*.. 
0x00002AAABEBF2DE0 : 80E0 D189 AD2A 0000 6091 55E8 AA2A 0000 
.....*..`.U..*.. 
0x00002AAABEBF2DF0 : 0000 0000 AA2A 0000 00F0 52E9 AA2A 0000 
.....*....R..*.. 
0x00002AAABEBF2E00 : E00A 1CE9 AA2A 0000 E034 BFBE AA2A 0000 
.....*...4...*.. 
0x00002AAABEBF2E10 : 0000 0000 0000 0000 F036 BFBE AA2A 0000 
.........6...*.. 
. 
. 
. 
0x00002AAABEBFAD20 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002AAABEBFAD30 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002AAABEBFAD40 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002AAABEBFAD50 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002AAABEBFAD60 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002AAABEBFAD70 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Linux, AIX                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.1 FP4                                      * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
See error description
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.01.2014
12.05.2014
12.05.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList