2013-11-15-11.25.01.601514-360 I2836087A3525 LEVEL:
Severe
(Origin)
PID : 22282280 TID : 186047 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
SAMPLE
APPHDL : 1-15873 APPID:
AUTHID : db2inst1 HOSTNAME: test Page 36 of 57
EDUID : 186047 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, lob manager, sqldxDirectReadAllocMap,
probe:888
DATA #1 : Buddy Segment Address, PD_TYPE_BSEG_ADDR, 4 bytes
61184
DATA #2 : Hex integer, 1 bytes
0x22
CALLSTCK: (Static functions may not be resolved correctly, as
they are
resolved to the nearest symbol)
[0] 0x0900000002EA0C20
sqldx_dumpBadPage__FP9SQLDX_LWAP17SQLDX_CACHE_ENTRYUiiT4CUle +
0xA84
[1] 0x0900000002EA00F8
sqldx_dumpBadPage__FP9SQLDX_LWAP17SQLDX_CACHE_ENTRYUiiT4CUle@glu
e403 + 0xA8
[2] 0x09000000042FA834
sqldxDirectReadAllocMap__FP9SQLDX_LWAP17SQLDX_CACHE_ENTRYUiT3PiP
Us + 0x1F0 Page 37 of 57
[3] 0x09000000042FA500
sqldxReadAllocMap__FP9SQLDX_LWAP17SQLDX_CACHE_ENTRYUiT3PiPUs +
0x60
[4] 0x0900000006A32DC4
sqldxOuterRbsHunt__FP9SQLDX_LWARP17SQLDX_CACHE_ENTRYUibN23iPP17S
QLDX_CAC HE_ENTRYPUiT9 + 0xD64
[5] 0x0900000006A31B48 sqldxGetBseg__FP9SQLDX_LWAiPUi + 0x1298
[6] 0x0900000006A38468
sqldx_ld_alloc_bsegs__FP9SQLDX_LWAP8SQLDX_LDiUi + 0x190
[7] 0x0900000006A2D324
sqldx_ld_extend__FP9SQLDX_LWAP8SQLDX_LDiUi + 0x2E4
[8] 0x0900000005AA90E8
sqldxBuildDescriptor__FP9SQLDX_LWAP8SQLDX_LDiT3b + 0x9C
[9] 0x0900000006A2CEFC
sqldxCreateLob__FP9SQLDX_LWAUcUsiT4PcT4P8SQLDX_LD + 0x268
[10] 0x090000000672DFF8
sqldxLobCreate__FP8sqeAgentP8SQLD_TCBUcUsiT5PcT5P8SQLDX_LD +
0xE4
[11] 0x0900000006A2C754
sqldmadx__FP8sqeAgentP8SQLD_TCBUcUsP9sqllf_csoiT6P8SQLD_LFDPUl +
0x840
[12] 0x0900000006A5B5D0
@113@sqldFormatLobLongCol__FP8sqeAgentP13SQLD_TDATARECT2P8SQLD_T
CBiT5PUl PiT5T8P10sqlz_value + 0xB48
[13] 0x0900000004AEF244
sqldFullFormatFixedVar__FP8sqeAgentP13SQLD_TDATARECT2PP10SQLD_VA
LUEUlP8S SQL_TCBPiPUcP15SQLD_XOR_UPDATEP8SQLD_CCB + 0x46C
[14] 0x0900000003E1BB5C
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP13SQLD_TDATARE
CP8SQLZ_ RID + 0x9C0
[15] 0x0900000003BB33EC
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
oFlags17 t_iudoFlagsKernelP8SQLZ_RID + 0xAC
[16] 0x0900000003BB320C sqlriisr__FP8sqlrr_cb + 0x198
[17] 0x0900000003B31DC8
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +0x24
[18] 0x0900000003B785D0
.sqlrr_process_execute_request.fdpr.clone.1588__FP8sqlrr_cbib +
0xC30
[19] 0x0900000003AC3324
sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x6E8
[20] 0x0900000003AAC16C
.sqljs_ddm_excsqlstt.fdpr.clone.1784__FP14db2UCinterfaceP13sqljD
DMObject + 0xCE8
[21] 0x0900000003AAC484
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interfac e + 0x94
[22] 0x0900000003AAA774
.sqljsParse.fdpr.clone.102__FP13sqljsDrdaAsCbP14db2UCinterfaceP8
sqeAgent b + 0x13A4
[23] 0x0900000003AA72B0
@73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x280 Page 40
of 57
[24] 0x090000000403E564
@73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
[25] 0x090000000403EF4C
@73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x4E8
[26] 0x090000000403E230
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x21C
[27] 0x09000000037FAC80 RunEDU__8sqeAgentFv + 0x584
[28] 0x09000000037F6858 EDUDriver__9sqzEDUObjFv + 0x13C
[29] 0x09000000037F66E0 sqlzRunEDU__FPcUi + 0x10
[30] 0x0900000003809558 sqloEDUEntry + 0x264
[31] 0x09000000007A2D30 _pthread_body + 0xF0
[32] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2013-11-15-11.25.01.605756-360 I2839613A2291 LEVEL:
Severe
PID : 22282280 TID : 186047 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
SAMPLE
APPHDL : 1-15873 APPID:
AUTHID : db2inst1 HOSTNAME: test
EDUID : 186047 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, lob manager, sqldxDirectReadAllocMap,
probe:888
DATA #1 : SQLDX_CACHE_ENTRY, PD_TYPE_SQDX_CE, 280 bytes
SQLDX_CACHE_ENTRY: Size:280
x0000 pageNumber 257
x0050 fix_cb
accessMethod: SQLB_OBJ_RELATIVE
fixMode: 42 SQLBOLD | SQLBCOND
buffptr: 0x07000004c5aa0000
bpdPtr: 0x07000003ffce67a0
pageLsnOnXLatch: 0000000000000000
dmDebugHdl: 0
objectPageNum: 257
empDiskPageNum: 4294967295
unfixFlags: 0
dirtyState: SQLBCLEAN
fixInfoFlags: 0
regEDUid: 0
Pagekey: {pool:36;obj:14;type:4} PPNum:257
Obj: {pool:36;obj:14;type:4} Parent={36;14}
lifeLSN: 00000000077DF736
tid: 0 0 0
extentAnchor: 216
initEmpPages: 0
poolPage0: 0
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 8 Page 43 of 57
bufferPoolID: 3
partialHash: 68026404
objDescAttributes: 0
bufferPool: 0x07000003f8ff8ec0
pdef: 0x07000004f8794b20
glob: 0x000000015bfb13c0
x0004 version 1010
x0008 fixMode 66
x000C bsType SBS (2)
x000D logWritten 0
x0010 bsNumber 238
x0018 pBspStatus 0x07000004c5aa6668
x0020 hintArray 0x07000004c5aa666c
x0028 countArray 0x07000004c5aa668e
x0030 sizeArray 0x07000004c5aa66b0
x0038 stateArray 0x07000004c5aa66d0
* * * POSSIBLE INSERT SQL THAT FAILED ON THIS BLOB TABLE
* * * POSSIBLE INSERT SQL THAT FAILED ON THIS BLOB TABLE
2013-11-15-11.25.10.303876-360 I3116002A2357 LEVEL:
Severe
PID : 22282280 TID : 186047 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
SAMPLE
APPHDL : 1-15873 APPID:
AUTHID : db2inst1 HOSTNAME: test
EDUID : 186047 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling,
probe:140
MESSAGE : section stmt
DATA #1 : Hexdump, 359 bytes
0x07000005353B56C0 : 494E 5345 5254 2049 4E54 4F20 444D 5F53
INSERT
INTO DM_S
0x07000005353B56D0 : 5441 4749 4E47 5F44 4F43 5F55 504C 4F41
TAGING_DOC_UPLOA Page 45 of 57
0x07000005353B56E0 : 4420 2853 4554 5F44 5545 5F44 542C 4352
D
(SET_DUE_DT,CR
0x07000005353B56F0 : 4541 5445 5F55 5345 525F 4944 2C43 4F4E
EATE_USER_ID,CON
0x07000005353B5700 : 5445 4E54 5F54 4147 5F43 442C 454D 505F
TENT_TAG_CD,EMP_
0x07000005353B5710 : 4944 2C46 494C 455F 4558 542C 4150 505F
ID,FILE_EXT,APP_
0x07000005353B5720 : 4E55 4D2C 444F 435F 494D 472C 444F 435F
NUM,DOC_IMG,DOC_
0x07000005353B5730 : 434F 4D4D 454E 5453 2C43 5245 4154 455F
COMMENTS,CREATE_
0x07000005353B5740 : 4454 2C53 5447 5F44 4F43 5F49 442C 5550
DT,STG_DOC_ID,UP
0x07000005353B5750 : 4441 5445 5F55 5345 525F 4944 2C55 504C
DATE_USER_ID,UPL Page 46 of 57
0x07000005353B5760 : 4F41 445F 5354 532C 554E 4951 5545 5F54
OAD_STS,UNIQUE_T
0x07000005353B5770 : 5241 4E53 5F49 442C 494E 4456 5F49 442C
RANS_ID,INDV_ID,
0x07000005353B5780 : 4152 4348 4956 455F 4454 2C53 505F 494E
ARCHIVE_DT,SP_IN
0x07000005353B5790 : 4449 4341 544F 522C 5243 565F 4454 2C43
DICATOR,RCV_DT,C
0x07000005353B57A0 : 4153 455F 4E55 4D2C 444F 435F 5245 465F
ASE_NUM,DOC_REF_
0x07000005353B57B0 : 4944 2C55 5044 4154 455F 4454 2C53 5447
ID,UPDATE_DT,STG
0x07000005353B57C0 : 5F47 5250 5F49 442C 444F 435F 5550 4C4F
_GRP_ID,DOC_UPLO
0x07000005353B57D0 : 4144 5F53 572C 454E 5449 5459 5F54 5950
AD_SW,ENTITY_TYP Page 47 of 57
0x07000005353B57E0 : 455F 4344 2920 5641 4C55 4553 283F 2C3F
E_CD)
VALUES(?,?
0x07000005353B57F0 : 2C3F 2C3F 2C3F 2C3F 2C3F 2C3F 2C53 5953
,?,?,?,?,?,?,SYS
0x07000005353B5800 : 4441 5445 2C3F 2C6E 756C 6C2C 3F2C 3F2C
+KROLL, DOUG -DB2FORLUW
-L78Z/-------P1S1-13/11/15-14:58--AT
DATE,?,null,?,?,
0x07000005353B5810 : 3F2C 3F2C 3F2C 3F2C 3F2C 3F2C 6E75 6C6C
* * * UPDATE THAT IS FAILING TOO, MANY OF THEM BUT COULD BE THE
VICTIM
SINCE IT'S WELL AFTER THE CRASH |
