请专家看看什么原因,提供点思路,遇到数据库执行跑批(DELETE /INSERT操作时),不定期定时出现报错,当我重建这个表加载重新加载完数据后这个语句又能正常跑过,然后另外的表又坏了,每次报错的表不固定且出现非常频繁,请专家帮忙看看什么原因。
环境:LINUX +DB2 v10.1(之前用DB2 9.7的试过也报错),而同样的程序和数据搭在另外的机器上无问题
但是这台问题的服务器,找人检测过硬件也没问题。
如果是操作系统层面的参数问题,请问需要关注一些什么参数?
下面时报错前后的db2dialog日志。
报错后,会产生一个FODC_BadPage_2016-12-15-18.24.39.777492_0000 目录出来,里面一堆文件,但看不懂,看看是否需要贴出来帮忙分析一下?
2016-12-15-18.40.10.827015+480 I6918628E643 LEVEL: Warning
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:865
DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
LOADID: 96.2016-12-15-18.40.10.826992.0 (-1;-1)
DATA #2 : String, 58 bytes
Starting LOAD operation (Q) (5) (I) [PAS .LSB_DKFCYE].
2016-12-15-18.40.11.021952+480 I6919272E552 LEVEL: Warning
PID : 4557 TID : 46938703522112 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 136 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 77 bytes
LOADID: 96.2016-12-15-18.40.10.826992.0 (4;112)
Load CPU parallelism is: 7, 0
2016-12-15-18.40.11.186797+480 I6919825E613 LEVEL: Warning
PID : 4557 TID : 46938665773376 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 128 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 126 bytes
LOADID: 96.2016-12-15-18.40.10.826992.0 (4;112)
Starting LOAD phase at 2016-12-15 18:40:11.183121. Table PAS .LSB_DKFCYE
2016-12-15-18.42.14.255635+480 I6920439E587 LEVEL: Warning
PID : 4557 TID : 46938703522112 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 136 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 101 bytes
LOADID: 96.2016-12-15-18.40.10.826992.0 (4;112)
Completed LOAD phase at 2016-12-15 18:42:14.244531.
2016-12-15-18.42.14.579514+480 I6921027E611 LEVEL: Warning
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:1331
DATA #1 : LOADID, PD_TYPE_LOADID, 47 bytes
LOADID: 96.2016-12-15-18.40.10.826992.0 (4;112)
DATA #2 : String, 25 bytes
Completed LOAD operation.
2016-12-15-18.42.31.396195+480 I6921639E549 LEVEL: Event
PID : 4557 TID : 46912879192384 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-9 APPID: *LOCAL.DB2.161215102419
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 46 EDUNAME: db2stmm (AJPAS) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB AJPAS : "Sortheap" From: "201589"
2016-12-15-18.42.49.034800+480 E6922189E681 LEVEL: Warning
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, data management, sqldEndNoLogList, probe:1
MESSAGE : ADM5530W The COMMIT processing of table "PAS .LSB_DKZHMXZ" that
used NOT LOGGED INITIALLY has been initiated. It is recommended that
you take a backup of this table's table space(s).
2016-12-15-18.42.58.000805+480 I6922871E6546 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 23 bytes
Page verification error
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
50270483
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 96 bytes
Obj: {pool:8;obj:24;type:0} Parent={8;24}
lifeLSN: 000000001C40789C
tid: 0 0 0
extentAnchor: 9408
initEmpPages: 0
poolPage0: 0
poolflags: 122
objectState: 27
lastSMP: 0
pageSize: 8192
extentSize: 64
bufferPoolID: 2
partialHash: 1572872
objDescAttributes: 0
bufferPool: 0x00002aaadb93c280
pdef: 0x00002aab22751120
DATA #5 : Bitmask, 4 bytes
0x00000003
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:0;obj:0;type:0} PPNum:0 OPNum:0
begoff: 0
datlen: 0
pagebinx: 0
revnum: 0
pagelsn: 0000000000000000
flag: 0
future32: 0
cbits1to31: 0
cbits32to63: 0
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1248 bytes
dbcb: 0x000000020696a080
bpcb: 0x00002aaadb8afa20
ptbl: 0x00002aaadb8afda0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000208040080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 200
eduId: 96
curPfQ: 1
curRemHateListCounter: 204712
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr:
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002AAAAB9F9BEE pdLog + 0x38E
[1] 0x00002AAAAD25C72F _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BF
[2] 0x00002AAAAEAE6B17 sqlbReadPage + 0xE27
[3] 0x00002AAAAEADC4D3 _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x5C3
[4] 0x00002AAAAEABC96C _Z7sqlbfixP11SQLB_FIX_CB + 0x115C
[5] 0x00002AAAABBB684C _Z13sqldDeleteRowP13SQLD_DFM_WORKim + 0x17C
[6] 0x00002AAAABBE3FAF _Z13sqldRowDeleteP8sqeAgentP8SQLD_CCBm + 0x37F
[7] 0x00002AAAAC993C55 _Z8sqlridelP8sqlrr_cb + 0x105
[8] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[9] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[10] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[11] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[12] 0x00002AAAABA7B258 pvm_entry + 0x198
[13] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[14] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[15] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[16] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[17] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[18] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[19] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[20] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[21] 0x00002AAAABA7B258 pvm_entry + 0x198
[22] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[23] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[24] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[25] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[26] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[27] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[28] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[29] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[30] 0x00002AAAABA7B258 pvm_entry + 0x198
[31] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[32] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[33] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[34] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[35] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[36] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[37] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[38] 0x00002AAAAEB52C5E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x4EE
[39] 0x00002AAAAEB5055E _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x7E
[40] 0x00002AAAAEB50C93 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x3A3
[41] 0x00002AAAABF2AB2B /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144DB2B
[42] 0x00002AAAABF2977F /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144C77F
[43] 0x00002AAAABF276E3 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144A6E3
[44] 0x00002AAAABF27473 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xF3
[45] 0x00002AAAABCCE811 _ZN8sqeAgent6RunEDUEv + 0x821
[46] 0x00002AAAACCBDF63 _ZN9sqzEDUObj9EDUDriverEv + 0xF3
[47] 0x00002AAAACCBDE69 _Z10sqlzRunEDUPcj + 0x9
[48] 0x00002AAAAC751501 sqloEDUEntry + 0x2A1
[49] 0x000000375DE0673D /lib64/libpthread.so.0 + 0x673D
2016-12-15-18.42.58.064518+480 E6929418E1018 LEVEL: Critical
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbLogReadAttemptFailure, probe:10
MESSAGE : ADM14001C An unexpected and critical error has occurred: "BadPage".
The instance may have been shutdown as a result. "Automatic" FODC
(First Occurrence Data Capture) has been invoked and diagnostic
information has been recorded in directory
"/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.77749
2_0000/". Please look in this directory for detailed evidence about
what happened and contact IBM support if necessary to diagnose the
problem.
2016-12-15-18.42.58.065043+480 I6930437E633 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 33 bytes
Page verification error occurred.
2016-12-15-18.42.58.065406+480 I6931071E224 LEVEL: Severe
PID:4557 TID:46938695133504 NODE:000 Title: SQLB_PAGE
Dump File:/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_0000/4557.96.000.dump.bin
2016-12-15-18.42.58.110447+480 I6931296E548 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:100
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2016-12-15-18.42.58.110799+480 I6931845E685 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:125
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00002AAAEAD1E818 : 4A6F 5258 0000 0000 8603 0000 E7C6 0D00 JoRX............
0x00002AAAEAD1E828 : E8C6 0D00 4A6F 5258 0000 0000 0000 0000 ....JoRX........
2016-12-15-18.42.58.111077+480 I6932531E711 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
DATA #1 : Hexdump, 18 bytes
0x00002AAAD16D49B0 : 414A 5041 5320 2020 2020 2020 2020 2020 AJPAS
0x00002AAAD16D49C0 : 2020
2016-12-15-18.42.58.111250+480 I6933243E633 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =
DATA #1 : Hexdump, 2 bytes
0x00002AAAD16D4980 : 0800 ..
2016-12-15-18.42.58.111418+480 I6933877E646 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
DATA #1 : Hexdump, 8 bytes
0x00002AAAD16D49C2 : 5041 5320 2020 2020 PAS
2016-12-15-18.42.58.111640+480 I6934524E632 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnameLen =
DATA #1 : Hexdump, 2 bytes
0x00002AAAD16D4990 : 0B00 ..
2016-12-15-18.42.58.111820+480 I6935157E648 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.pkgname=
DATA #1 : Hexdump, 11 bytes
0x00002AAAD16D49D4 : 5031 3536 3138 3930 3633 35 P1561890635
2016-12-15-18.42.58.111990+480 I6935806E637 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->pkgcnstkn =
DATA #1 : Hexdump, 8 bytes
0x00002AAAD16D49E6 : 6542 496F 5350 4D67 eBIoSPMg
2016-12-15-18.42.58.112157+480 I6936444E627 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: pCurrentPID->pkgsn =
DATA #1 : Hexdump, 2 bytes
0x00002AAAD16D49EE : 0F00 ..
2016-12-15-18.42.58.112323+480 I6937072E621 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: nestingLevel =
DATA #1 : Hexdump, 2 bytes
0x00002AB0B6C851DE : 0300 ..
2016-12-15-18.42.58.112742+480 I6937694E621 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: nestingLevel =
DATA #1 : Hexdump, 2 bytes
0x00002AB0C79998A6 : 0200 ..
2016-12-15-18.42.58.113151+480 I6938316E621 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging function), probe:50
MESSAGE : RDS UCINTFC: nestingLevel =
DATA #1 : Hexdump, 2 bytes
0x00002AB0C798E006 : 0100 ..
2016-12-15-18.42.58.113974+480 I6938938E829 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:140
MESSAGE : section stmt
DATA #1 : Hexdump, 52 bytes
0x00002AAE4495FAE0 : 6465 6C65 7465 2066 726F 6D20 5041 532E delete from PAS.
0x00002AAE4495FAF0 : 4E42 5A5A 5F44 4B4D 585F 3230 3136 3132 NBZZ_DKMX_201612
0x00002AAE4495FB00 : 2077 6865 7265 2074 6A72 713D 3230 3136 where tjrq=2016
0x00002AAE4495FB10 : 3132 3132 1212
2016-12-15-18.42.58.114256+480 I6939768E682 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_section, probe:25
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00002AAAEAD1E818 : 4A6F 5258 0000 0000 8603 0000 E7C6 0D00 JoRX............
0x00002AAAEAD1E828 : E8C6 0D00 4A6F 5258 0000 0000 0000 0000 ....JoRX........
2016-12-15-18.42.58.114902+480 I6940451E662 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, catalog services, sqlrl_dump_userTemps, probe:25
MESSAGE : User temp table info dumped. Check
/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_
0000/4557.46938695133504.000.dgtt.txt for additional data.
2016-12-15-18.42.58.134012+480 I6941114E515 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:250
DATA #1 : String, 19 bytes
XML components dump
2016-12-15-18.42.58.134527+480 I6941630E643 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:150
MESSAGE : Context info dumped! Check
/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_
0000/4557.96.000.apm.bin for additional data.
2016-12-15-18.42.58.134742+480 I6942274E685 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00002AAAEAD1E818 : 4A6F 5258 0000 0000 8603 0000 E7C6 0D00 JoRX............
0x00002AAAEAD1E828 : E8C6 0D00 4A6F 5258 0000 0000 0000 0000 ....JoRX........
2016-12-15-18.42.58.135241+480 I6942960E645 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:150
MESSAGE : Workspace info dumped! Check
/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_
0000/4557.96.000.apm.bin for additional data.
2016-12-15-18.42.58.135456+480 I6943606E685 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00002AAAEAD1E818 : 4A6F 5258 0000 0000 8603 0000 E7C6 0D00 JoRX............
0x00002AAAEAD1E828 : E8C6 0D00 4A6F 5258 0000 0000 0000 0000 ....JoRX........
2016-12-15-18.42.58.135956+480 I6944292E650 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_full_dump, probe:25
MESSAGE : Package Cache info dumped! Check
/home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_
0000/4557.96.000.apm.bin for additional data.
2016-12-15-18.42.58.144243+480 I6944943E561 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:350
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2016-12-15-18.42.58.144547+480 I6945505E550 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2016-12-15-18.42.58.144823+480 I6946056E573 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:911
DATA #1 : String, 38 bytes
Source Type not DRDA AS. SourceType =
DATA #2 : signed integer, 4 bytes
7
2016-12-15-18.42.58.145113+480 I6946630E563 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2016-12-15-18.42.58.145686+480 I6947194E936 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 46 bytes
Container information : path, contID, mapInfo.
DATA #2 : File name, 53 bytes
/home/db2inst1/AJPAS/PAS_DATA/PAS_SPACE_DATA/TBS_MXZ9
DATA #3 : Container ID, PD_TYPE_SQLB_CONTAINER_ID, 4 bytes
8
DATA #4 : SQLB_MAP_INFO, PD_TYPE_SQLB_MAP_INFO, 16 bytes
offset: 2957139 length: 3292474860 blkSize: 13
2016-12-15-18.42.58.278621+480 I6948131E416 LEVEL: Event
PID : 5033 TID : 46912755780256 PROC : db2vend (PD Vendor Process - 96)
INSTANCE: db2inst1 NODE : 000
HOSTNAME: localhost.localdomain
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptDirect, probe:10
START : Invoking /home/db2inst1/sqllib/bin/db2cos_datacorruption from buffer pool services sqlb_verify_page
2016-12-15-18.43.01.282960+480 I6948548E437 LEVEL: Warning
PID : 5033 TID : 46912755780256 PROC : db2vend (PD Vendor Process - 96)
INSTANCE: db2inst1 NODE : 000
HOSTNAME: localhost.localdomain
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptDirect, probe:130
MESSAGE : Detected end of execution of call-out script
DATA #1 : Process ID, 4 bytes
5035
DATA #2 : unsigned integer, 4 bytes
3
2016-12-15-18.43.01.284677+480 I6948986E384 LEVEL: Event
PID : 5033 TID : 46912755780256 PROC : db2vend (PD Vendor Process - 96)
INSTANCE: db2inst1 NODE : 000
HOSTNAME: localhost.localdomain
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptDirect, probe:150
STOP : Completed invoking /home/db2inst1/sqllib/bin/db2cos_datacorruption
2016-12-15-18.43.01.285180+480 I6949371E527 LEVEL: Warning
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScriptViaVendorAPI, probe:16
DATA #1 :
PD Vendor Return Code: 0
2016-12-15-18.43.01.285477+480 I6949899E708 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 :
Failed to read page from disk on attempt number 1.
Retrying operation. Only subsequent failures will be logged.
2016-12-15-18.43.01.285990+480 I6950608E6546 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 23 bytes
Page verification error
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
50270483
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 96 bytes
Obj: {pool:8;obj:24;type:0} Parent={8;24}
lifeLSN: 000000001C40789C
tid: 0 0 0
extentAnchor: 9408
initEmpPages: 0
poolPage0: 0
poolflags: 122
objectState: 27
lastSMP: 0
pageSize: 8192
extentSize: 64
bufferPoolID: 2
partialHash: 1572872
objDescAttributes: 0
bufferPool: 0x00002aaadb93c280
pdef: 0x00002aab22751120
DATA #5 : Bitmask, 4 bytes
0x00000003
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:0;obj:0;type:0} PPNum:0 OPNum:0
begoff: 0
datlen: 0
pagebinx: 0
revnum: 0
pagelsn: 0000000000000000
flag: 0
future32: 0
cbits1to31: 0
cbits32to63: 0
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1248 bytes
dbcb: 0x000000020696a080
bpcb: 0x00002aaadb8afa20
ptbl: 0x00002aaadb8afda0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000208040080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 600
eduId: 96
curPfQ: 1
curRemHateListCounter: 204712
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr:
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002AAAAB9F9BEE pdLog + 0x38E
[1] 0x00002AAAAD25C72F _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BF
[2] 0x00002AAAAEAE6B17 sqlbReadPage + 0xE27
[3] 0x00002AAAAEADC4D3 _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x5C3
[4] 0x00002AAAAEABC96C _Z7sqlbfixP11SQLB_FIX_CB + 0x115C
[5] 0x00002AAAABBB684C _Z13sqldDeleteRowP13SQLD_DFM_WORKim + 0x17C
[6] 0x00002AAAABBE3FAF _Z13sqldRowDeleteP8sqeAgentP8SQLD_CCBm + 0x37F
[7] 0x00002AAAAC993C55 _Z8sqlridelP8sqlrr_cb + 0x105
[8] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[9] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[10] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[11] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[12] 0x00002AAAABA7B258 pvm_entry + 0x198
[13] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[14] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[15] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[16] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[17] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[18] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[19] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[20] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[21] 0x00002AAAABA7B258 pvm_entry + 0x198
[22] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[23] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[24] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[25] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[26] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[27] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[28] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[29] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[30] 0x00002AAAABA7B258 pvm_entry + 0x198
[31] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[32] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[33] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[34] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[35] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[36] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[37] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[38] 0x00002AAAAEB52C5E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x4EE
[39] 0x00002AAAAEB5055E _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x7E
[40] 0x00002AAAAEB50C93 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x3A3
[41] 0x00002AAAABF2AB2B /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144DB2B
[42] 0x00002AAAABF2977F /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144C77F
[43] 0x00002AAAABF276E3 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144A6E3
[44] 0x00002AAAABF27473 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xF3
[45] 0x00002AAAABCCE811 _ZN8sqeAgent6RunEDUEv + 0x821
[46] 0x00002AAAACCBDF63 _ZN9sqzEDUObj9EDUDriverEv + 0xF3
[47] 0x00002AAAACCBDE69 _Z10sqlzRunEDUPcj + 0x9
[48] 0x00002AAAAC751501 sqloEDUEntry + 0x2A1
[49] 0x000000375DE0673D /lib64/libpthread.so.0 + 0x673D
2016-12-15-18.43.01.310549+480 I6957155E708 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 :
Failed to read page from disk on attempt number 2.
Retrying operation. Only subsequent failures will be logged.
2016-12-15-18.43.06.313043+480 I6957864E6546 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 23 bytes
Page verification error
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
50270483
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 96 bytes
Obj: {pool:8;obj:24;type:0} Parent={8;24}
lifeLSN: 000000001C40789C
tid: 0 0 0
extentAnchor: 9408
initEmpPages: 0
poolPage0: 0
poolflags: 122
objectState: 27
lastSMP: 0
pageSize: 8192
extentSize: 64
bufferPoolID: 2
partialHash: 1572872
objDescAttributes: 0
bufferPool: 0x00002aaadb93c280
pdef: 0x00002aab22751120
DATA #5 : Bitmask, 4 bytes
0x00000003
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:0;obj:0;type:0} PPNum:0 OPNum:0
begoff: 0
datlen: 0
pagebinx: 0
revnum: 0
pagelsn: 0000000000000000
flag: 0
future32: 0
cbits1to31: 0
cbits32to63: 0
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1248 bytes
dbcb: 0x000000020696a080
bpcb: 0x00002aaadb8afa20
ptbl: 0x00002aaadb8afda0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000208040080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 600
eduId: 96
curPfQ: 1
curRemHateListCounter: 204712
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr:
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002AAAAB9F9BEE pdLog + 0x38E
[1] 0x00002AAAAD25C72F _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BF
[2] 0x00002AAAAEAE6B17 sqlbReadPage + 0xE27
[3] 0x00002AAAAEADC4D3 _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x5C3
[4] 0x00002AAAAEABC96C _Z7sqlbfixP11SQLB_FIX_CB + 0x115C
[5] 0x00002AAAABBB684C _Z13sqldDeleteRowP13SQLD_DFM_WORKim + 0x17C
[6] 0x00002AAAABBE3FAF _Z13sqldRowDeleteP8sqeAgentP8SQLD_CCBm + 0x37F
[7] 0x00002AAAAC993C55 _Z8sqlridelP8sqlrr_cb + 0x105
[8] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[9] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[10] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[11] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[12] 0x00002AAAABA7B258 pvm_entry + 0x198
[13] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[14] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[15] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[16] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[17] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[18] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[19] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[20] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[21] 0x00002AAAABA7B258 pvm_entry + 0x198
[22] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[23] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[24] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[25] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[26] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[27] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[28] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[29] 0x00002AAAABA6E9E3 _ZN3PVM3runEv + 0xF93
[30] 0x00002AAAABA7B258 pvm_entry + 0x198
[31] 0x00002AAAAC6F629A sqloInvokeFnArgs + 0xBA
[32] 0x00002AAAAC9C8914 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x784
[33] 0x00002AAAAC9C4B34 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0xA44
[34] 0x00002AAAAC9C3656 _Z9sqlricallP8sqlrr_cb + 0x116
[35] 0x00002AAAAECB60CD _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1AD
[36] 0x00002AAAAEC8C1A6 _Z29sqlrr_process_execute_requestP8sqlrr_cbi + 0x836
[37] 0x00002AAAAEC8A478 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x288
[38] 0x00002AAAAEB52C5E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x4EE
[39] 0x00002AAAAEB5055E _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x7E
[40] 0x00002AAAAEB50C93 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x3A3
[41] 0x00002AAAABF2AB2B /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144DB2B
[42] 0x00002AAAABF2977F /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144C77F
[43] 0x00002AAAABF276E3 /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x144A6E3
[44] 0x00002AAAABF27473 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xF3
[45] 0x00002AAAABCCE811 _ZN8sqeAgent6RunEDUEv + 0x821
[46] 0x00002AAAACCBDF63 _ZN9sqzEDUObj9EDUDriverEv + 0xF3
[47] 0x00002AAAACCBDE69 _Z10sqlzRunEDUPcj + 0x9
[48] 0x00002AAAAC751501 sqloEDUEntry + 0x2A1
[49] 0x000000375DE0673D /lib64/libpthread.so.0 + 0x673D
2016-12-15-18.43.06.337350+480 I6964411E634 LEVEL: Severe
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1199
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 :
Converting to non-critical read error
2016-12-15-18.43.06.337741+480 E6965046E698 LEVEL: Warning
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1199
MESSAGE : ADM6006E DB2 encountered an error while reading page "50270483" from
table space "8" for object "24" (located at offset "2957139" of
container "/home/db2inst1/AJPAS/PAS_DATA/PAS_SPACE_DATA/TBS_MXZ9").
2016-12-15-18.43.06.346917+480 I6965745E665 LEVEL: Event
PID : 4557 TID : 46938695133504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-42 APPID: 154.84.100.173.47185.161215103158
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 96 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:10
STOP : AUTOMATIC FODC : BadPage : success
IMPACT : None
DATA #1 : String, 109 bytes
Check /home/db2inst1/sqllib/db2dump/FODC_BadPage_2016-12-15-18.24.39.777492_0000/ for diagnostic information.
2016-12-15-19.13.15.803267+480 I6966411E645 LEVEL: Warning
PID : 4557 TID : 46938669967680 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 126 EDUNAME: db2agent (AJPAS) 0
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:865
DATA #1 : LOADID, PD_TYPE_LOADID, 48 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (-1;-1)
DATA #2 : String, 64 bytes
Starting LOAD operation (S) (1) (I) [PAS .NBZZ_DKMX_201612].
2016-12-15-19.13.15.925367+480 I6967057E547 LEVEL: Warning
PID : 4557 TID : 46912770140480 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 147 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 77 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (8;23)
Load CPU parallelism is: 7, 0
2016-12-15-19.13.15.943945+480 I6967605E614 LEVEL: Warning
PID : 4557 TID : 46938477029696 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 139 EDUNAME: db2lfrm0 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 132 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (8;23)
Starting LOAD phase at 2016-12-15 19:13:15.938935. Table PAS .NBZZ_DKMX_201612
2016-12-15-19.13.15.990609+480 I6968220E582 LEVEL: Warning
PID : 4557 TID : 46912770140480 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 147 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 101 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (8;23)
Completed LOAD phase at 2016-12-15 19:13:15.988114.
2016-12-15-19.13.15.995903+480 I6968803E582 LEVEL: Warning
PID : 4557 TID : 46912770140480 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 147 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 101 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (8;23)
Starting BUILD phase at 2016-12-15 19:13:15.991046.
2016-12-15-19.13.16.228105+480 I6969386E583 LEVEL: Warning
PID : 4557 TID : 46912770140480 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : AJPAS
APPHDL : 0-97 APPID: *LOCAL.db2inst1.161215111312
AUTHID : PAS HOSTNAME: localhost.localdomain
EDUID : 147 EDUNAME: db2lrid 0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 102 bytes
LOADID: 126.2016-12-15-19.13.15.803240.0 (8;23)
Completed BUILD phase at 2016-12-15 19:13:16.225552.
MESSAGE : ADM6006E DB2 encountered an error while reading page \"50270483\" from table space \"8\" for object \"24\" (located at offset \"2957139\" of
container \"/home/db2inst1/AJPAS/PAS_DATA/PAS_SPACE_DATA/TBS_MXZ9\").
这里已经说了 表空间为8,表id为24的这张表下这个容器存在坏页,每次读到这个容器的 \"50270483\" 这个页就会报错。然后shutdown掉。后面看每次读这里也是差不多的报错。
要么把有问题的表rename保留,然后重建新的。要么把表drop掉重建,但不用这个有问题的容器。
收起