在一次正常关机后再开机,发现数据库开始不正常。启动数据库服务发现成功,但是进入数据库进行select 语句查询发现报错,我不太懂这个,请求哪位高手能够解释下,日志如下:
2013-03-09-20.30.54.320868+480 I54567093E614 LEVEL: Event
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 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/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.46.264919_0000/ for diagnostic information.
2013-03-09-20.30.54.321647+480 I54567708E497 LEVEL: Error
PID : 32171 TID : 140682339686144PROC : db2bp
INSTANCE: gjywinst NODE : 000
APPID : *LOCAL.gjywinst.130309123003
FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca, probe:2136
MESSAGE : SQL1655C The operation could not be completed due to an error
accessing data on disk.
DATA #1 : String, 12 bytes
sqluexpm.SQC
DATA #2 : String, 44 bytes
Error from Import/Export or Load Processing.
2013-03-09-20.30.54.403860+480 I54568206E3824 LEVEL: Severe
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 95 bytes
CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
3
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:4;obj:52;type:0} Parent={4;52}
lifeLSN: 000000060DB964F5
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 101
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 2
partialHash: 3407876
bufferPool: 0x00007fc93db243c0
pdef: 0x00007fc964a130a0
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:4;obj:52;type:0} PPNum:3 OPNum:3
begoff: 48
datlen: 32720
pagebinx: 10178
revnum: 1280
pagelsn: 000000061A468412 flag: e
future32: 0
cbits1to31: 301400
cbits32to63: 12402605
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1256 bytes
dbcb: 0x0000000200cc8960
bpcb: 0x00007fc93601cd20
ptbl: 0x00007fc93601cea0
eduType: SQLB_EDU_PREFETCHER
eduCB: 0x00007fc964a5c860
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 0
dbmon_cb: 0x00007fc964a6de60
eduId: 92
curPfQ: 1
curRemHateListCounter: 6026
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 0
agentPriorityWeight: 00
staticStr: CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
numPFRequestsHeld: 1
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x00007FCA2726BF52 pdLog + 0x398
[1] 0x00007FCA27F46BF8 _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BE
[2] 0x00007FCA29A22A6F /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x34F5A6F
[3] 0x00007FCA29A1F55D _Z16sqlb_verify_pageP9SQLB_PAGEP16SQLB_OBJECT_DESCjjP12SQLB_GLOBALSPm + 0x169
[4] 0x00007FCA272A492D _Z25sqlbReadAndReleaseBuffersP16SQLB_OBJECT_DESCjmmmP11SQLB_pfMisc + 0xA21
[5] 0x00007FCA272A2D62 _Z16sqlbProcessRangeP16SQLB_OBJECT_DESCjjP11SQLB_pfMisc + 0x146
[6] 0x00007FCA272A1FD9 _Z26sqlbPFPrefetcherEntryPointP16sqbPrefetcherEdu + 0x3C7
[7] 0x00007FCA272A1BD1 _ZN16sqbPrefetcherEdu6RunEDUEv + 0x2F
[8] 0x00007FCA27A7091C _ZN9sqzEDUObj9EDUDriverEv + 0xA6
[9] 0x00007FCA27A70873 _Z10sqlzRunEDUPcj + 0x9
2013-03-09-20.30.54.410593+480 I54572031E630 LEVEL: Severe
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 33 bytes
Page verification error occurred.
DATA #2 : Dumped object of size 32768 bytes at offset 3619440, 50 bytes
/home/gjywinst/sqllib/db2dump/6518.92.000.dump.bin
2013-03-09-20.30.54.410837+480 I54572662E180 LEVEL: Severe
PID:6518 TID:140506004711168 NODE:000 Title: SQLB_PAGE
Dump File:/home/gjywinst/sqllib/db2dump/6518.92.000.dump.bin
2013-03-09-20.30.54.420187+480 I54572843E803 LEVEL: Severe
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 46 bytes
Container information : path, contID, mapInfo.
DATA #2 : File name, 46 bytes
/home/gjywinst/tablespaces/SMS32K/SQL00052.DAT
DATA #3 : Container ID, PD_TYPE_SQLB_CONTAINER_ID, 4 bytes
0
DATA #4 : SQLB_MAP_INFO, PD_TYPE_SQLB_MAP_INFO, 16 bytes
offset: 3 length: 444584864 blkSize: 15
2013-03-09-20.30.54.420441+480 I54573647E412 LEVEL: Event
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking /home/gjywinst/sqllib/bin/db2cos_datacorruption from buffer pool services sqlbVerifyCBITS
2013-03-09-20.30.57.425132+480 I54574060E433 LEVEL: Warning
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:110
MESSAGE : Detected end of execution of call-out script
DATA #1 : Process ID, 4 bytes
521
DATA #2 : unsigned integer, 4 bytes
3
2013-03-09-20.30.57.425397+480 I54574494E380 LEVEL: Event
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP : Completed invoking /home/gjywinst/sqllib/bin/db2cos_datacorruption
2013-03-09-20.30.57.425521+480 I54574875E610 LEVEL: Error
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadAndReleaseBuffers, probe:310
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 :
Tablespace 4 (SMS32K) flags=101 HighWaterMark=0 ConOffset=1 startppg=1 diskPageNumber=1 lowestindex=0 highextindex=15 num-pages 16
2013-03-09-20.30.57.425768+480 I54575486E443 LEVEL: Error
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbErrorHandler, probe:0
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
2013-03-09-20.30.57.425909+480 I54575930E406 LEVEL: Error
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbErrorHandler, probe:0
DATA #1 : String, 75 bytes
Obj={pool:4;obj:52;type:0} State=x27
Prefetcher Error, in sqlbProcessRange
2013-03-09-20.30.57.426007+480 I54576337E903 LEVEL: Error
PID : 6518 TID : 140506004711168PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000
EDUID : 92 EDUNAME: db2pfchr (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbErrorHandler, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:4;obj:52;type:0} Parent={4;52}
lifeLSN: 000000060DB964F5
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 101
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 2
partialHash: 3407876
bufferPool: 0x00007fc93db243c0
pdef: 0x00007fc964a130a0
2013-03-09-20.30.57.447266+480 I54577241E3887 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 95 bytes
CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
15
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:4;obj:52;type:0} Parent={4;52}
lifeLSN: 000000060DB964F5
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 101
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 2
partialHash: 3407876
bufferPool: 0x00007fc93db243c0
pdef: 0x00007fc964a130a0
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:4;obj:52;type:0} PPNum:15 OPNum:15
begoff: 48
datlen: 32720
pagebinx: 10054
revnum: 1280
pagelsn: 000000061A572B5C flag: e
future32: 0
cbits1to31: 9860a8
cbits32to63: 1a
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1256 bytes
dbcb: 0x0000000200cc8960
bpcb: 0x00007fc93601cd20
ptbl: 0x00007fc93601cea0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000200fe0080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 200
dbmon_cb: 0x0000000000000000
eduId: 62
curPfQ: 1
curRemHateListCounter: 173
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr: CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x00007FCA2726BF52 pdLog + 0x398
[1] 0x00007FCA27F46BF8 _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BE
[2] 0x00007FCA29A22A6F /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x34F5A6F
[3] 0x00007FCA29A201C1 sqlbReadPage + 0x25F
[4] 0x00007FCA29A1743E _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x4F2
[5] 0x00007FCA29A0A3A7 _Z7sqlbfixP11SQLB_FIX_CB + 0x1059
[6] 0x00007FCA29A37512 /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x350A512
[7] 0x00007FCA29A35922 _Z7sqldfrdP13SQLD_DFM_WORK + 0xAA
[8] 0x00007FCA29A2B17A _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP12SQLD_ID_LISTP9SQLP_LSN8 + 0xFC0
[9] 0x00007FCA29ACD271 _Z17sqlritaSimplePermP8sqlrr_cb + 0xCD
2013-03-09-20.30.57.454263+480 E54581129E967 LEVEL: Critical
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 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/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.45416
3_0000/". Please look in this directory for detailed evidence about
what happened and contact IBM support if necessary to diagnose the
problem.
2013-03-09-20.30.57.454686+480 I54582097E778 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 33 bytes
Page verification error occurred.
DATA #2 : Dumped object of size 32768 bytes at offset 0, 95 bytes
/home/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_0000/6518.62.000.dump.bin
2013-03-09-20.30.57.454984+480 I54582876E225 LEVEL: Severe
PID:6518 TID:140505950185216 NODE:000 Title: SQLB_PAGE
Dump File:/home/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_0000/6518.62.000.dump.bin
2013-03-09-20.30.57.479482+480 I54583102E499 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2013-03-09-20.30.57.479978+480 I54583602E512 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2013-03-09-20.30.57.480144+480 I54584115E497 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:100
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2013-03-09-20.30.57.480309+480 I54584613E634 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:125
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00007FC964A88AD8 : 49E7 3951 0000 0000 A502 0000 0258 0A00 I.9Q.........X..
0x00007FC964A88AE8 : 0358 0A00 49E7 3951 0000 0000 0000 0000 .X..I.9Q........
2013-03-09-20.30.57.480622+480 I54585248E654 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbname =
DATA #1 : Hexdump, 18 bytes
0x00007FC935040F18 : 474A 5957 4442 2020 2020 2020 2020 2020 GJYWDB
0x00007FC935040F28 : 2020
2013-03-09-20.30.57.480743+480 I54585903E576 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->rdbcolidLen =
DATA #1 : Hexdump, 2 bytes
0x00007FC935040EE8 : 0800 ..
2013-03-09-20.30.57.480862+480 I54586480E589 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
DATA #1 : Hexdump, 8 bytes
0x00007FC935040F2A : 4E55 4C4C 4944 2020 NULLID
2013-03-09-20.30.57.480977+480 I54587070E575 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnameLen =
DATA #1 : Hexdump, 2 bytes
0x00007FC935040EF8 : 0800 ..
2013-03-09-20.30.57.481105+480 I54587646E587 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgnamcsn.pkgname=
DATA #1 : Hexdump, 8 bytes
0x00007FC935040F3C : 5351 4C55 4248 3035 SQLUBH05
2013-03-09-20.30.57.481226+480 I54588234E580 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgcnstkn =
DATA #1 : Hexdump, 8 bytes
0x00007FC935040F4E : 4141 4141 4153 4857 AAAAASHW
2013-03-09-20.30.57.481341+480 I54588815E570 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : RDS UCINTFC: pCurrentPID->pkgsn =
DATA #1 : Hexdump, 2 bytes
0x00007FC935040F56 : 0100 ..
2013-03-09-20.30.57.482232+480 I54589386E4348 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, probe:140
MESSAGE : section stmt
DATA #1 : Hexdump, 761 bytes
0x00007FC9A57A2560 : 7365 6C65 6374 2054 5241 4E53 5F52 4546 select TRANS_REF
0x00007FC9A57A2570 : 2C54 5241 4E53 5F4B 4559 2C54 5241 4E53 ,TRANS_KEY,TRANS
0x00007FC9A57A2580 : 5F53 5441 5455 532C 434F 4C4C 5F54 5950 _STATUS,COLL_TYP
0x00007FC9A57A2590 : 452C 434F 4C4C 5F4E 4F2C 5452 414E 535F E,COLL_NO,TRANS_
0x00007FC9A57A25A0 : 4441 5445 2C43 4F4C 4C5F 4441 5445 2C43 DATE,COLL_DATE,C
0x00007FC9A57A25B0 : 4F4C 4C5F 4343 592C 434F 4C4C 5F41 4D54 OLL_CCY,COLL_AMT
0x00007FC9A57A25C0 : 2C54 454E 4F52 5F54 5950 452C 494E 565F ,TENOR_TYPE,INV_
0x00007FC9A57A25D0 : 4E4F 2C44 5241 5745 525F 4944 2C44 5241 NO,DRAWER_ID,DRA
0x00007FC9A57A25E0 : 5745 452C 5445 4E4F 525F 4441 5953 2C53 WEE,TENOR_DAYS,S
0x00007FC9A57A25F0 : 5441 5254 5F44 4154 452C 4D41 5455 5249 TART_DATE,MATURI
0x00007FC9A57A2600 : 5459 5F44 4154 452C 4249 4C4C 5F44 4154 TY_DATE,BILL_DAT
0x00007FC9A57A2610 : 452C 434F 4C4C 5F42 4B5F 4944 2C45 5645 E,COLL_BK_ID,EVE
0x00007FC9A57A2620 : 4E54 5F4E 4F2C 4143 4345 5054 5F44 4154 NT_NO,ACCEPT_DAT
0x00007FC9A57A2630 : 452C 5245 435F 414D 542C 5345 5454 4C45 E,REC_AMT,SETTLE
0x00007FC9A57A2640 : 5F43 4359 2C53 4554 544C 455F 414D 542C _CCY,SETTLE_AMT,
0x00007FC9A57A2650 : 4452 4157 4552 5F42 4B5F 4944 2C43 4C41 DRAWER_BK_ID,CLA
0x00007FC9A57A2660 : 494D 5F41 4D54 2C53 4554 544C 455F 4441 IM_AMT,SETTLE_DA
0x00007FC9A57A2670 : 5445 2C4C 4F4E 475F 414D 542C 4355 5354 TE,LONG_AMT,CUST
0x00007FC9A57A2680 : 5F4D 414E 4147 4552 2C43 4E54 595F 4E4F _MANAGER,CNTY_NO
0x00007FC9A57A2690 : 2C43 4E54 595F 434F 4445 2C43 4E54 595F ,CNTY_CODE,CNTY_
0x00007FC9A57A26A0 : 4E41 4D45 2C53 454E 445F 424B 5F49 442C NAME,SEND_BK_ID,
0x00007FC9A57A26B0 : 5345 4E44 5F42 4B2C 4558 5052 4553 535F SEND_BK,EXPRESS_
0x00007FC9A57A26C0 : 5459 5045 2C45 5850 5245 5353 5F4E 4F2C TYPE,EXPRESS_NO,
0x00007FC9A57A26D0 : 4143 4345 5054 5F41 4D54 2C52 4543 5F44 ACCEPT_AMT,REC_D
0x00007FC9A57A26E0 : 4154 452C 4F54 4845 522C 4D41 5455 4952 ATE,OTHER,MATUIR
0x00007FC9A57A26F0 : 5459 5F44 4154 452C 4953 424C 4143 4B4C TY_DATE,ISBLACKL
0x00007FC9A57A2700 : 4953 542C 5245 5449 5245 5F44 4154 452C IST,RETIRE_DATE,
0x00007FC9A57A2710 : 5452 414E 535F 4F52 475F 434F 4445 2C43 TRANS_ORG_CODE,C
0x00007FC9A57A2720 : 525F 4143 434E 4F2C 5245 5455 524E 5F44 R_ACCNO,RETURN_D
0x00007FC9A57A2730 : 4154 452C 5055 5252 4550 4159 5F41 4343 ATE,PURREPAY_ACC
0x00007FC9A57A2740 : 4E4F 2C47 4F4F 4453 5F44 4553 432C 4C41 NO,GOODS_DESC,LA
0x00007FC9A57A2750 : 5354 5F46 4C41 472C 4858 5F44 4F43 2C4D ST_FLAG,HX_DOC,M
0x00007FC9A57A2760 : 4958 5F50 4159 5F44 4554 4149 4C2C 4F54 IX_PAY_DETAIL,OT
0x00007FC9A57A2770 : 4845 525F 4D53 472C 5245 5449 5245 5F41 HER_MSG,RETIRE_A
0x00007FC9A57A2780 : 4D54 2C41 4354 4956 455F 414D 542C 5348 MT,ACTIVE_AMT,SH
0x00007FC9A57A2790 : 4950 5F46 524F 4D2C 5348 4950 5F54 4F2C IP_FROM,SHIP_TO,
0x00007FC9A57A27A0 : 4F56 4552 5345 415F 4348 472C 434C 4149 OVERSEA_CHG,CLAI
0x00007FC9A57A27B0 : 4D5F 4241 4C2C 5245 435F 414D 5432 2C50 M_BAL,REC_AMT2,P
0x00007FC9A57A27C0 : 5552 4348 4153 455F 4441 5445 2C53 4849 URCHASE_DATE,SHI
0x00007FC9A57A27D0 : 504D 454E 545F 4441 5445 2C43 4E54 595F PMENT_DATE,CNTY_
0x00007FC9A57A27E0 : 454E 474E 414D 452C 434F 554E 5459 5F43 ENGNAME,COUNTY_C
0x00007FC9A57A27F0 : 4F44 452C 5043 542C 4C45 5353 414D 4F55 ODE,PCT,LESSAMOU
0x00007FC9A57A2800 : 4E54 2C41 4444 414D 4F55 4E54 2C41 4444 NT,ADDAMOUNT,ADD
0x00007FC9A57A2810 : 5F41 4D54 2C4C 4553 535F 414D 542C 277C _AMT,LESS_AMT,'|
0x00007FC9A57A2820 : 247C 2720 6672 6F6D 2045 5843 4C45 5645 $|' from EXCLEVE
0x00007FC9A57A2830 : 4E54 2077 6865 7265 2074 7261 6E73 5F64 NT where trans_d
0x00007FC9A57A2840 : 6174 653C 3D63 7572 7265 6E74 2064 6174 ate<=current dat
0x00007FC9A57A2850 : 6520 7769 7468 2075 72 e with ur
2013-03-09-20.30.57.482696+480 I54593735E631 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_section, probe:25
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00007FC964A88AD8 : 49E7 3951 0000 0000 A502 0000 0258 0A00 I.9Q.........X..
0x00007FC964A88AE8 : 0358 0A00 49E7 3951 0000 0000 0000 0000 .X..I.9Q........
2013-03-09-20.30.57.483459+480 I54594367E464 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:250
DATA #1 : String, 19 bytes
XML components dump
2013-03-09-20.30.57.484064+480 I54594832E592 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:150
MESSAGE : Context info dumped! Check
/home/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_
0000/6518.62.000.apm.bin for additional data.
2013-03-09-20.30.57.484203+480 I54595425E634 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlC_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00007FC964A88AD8 : 49E7 3951 0000 0000 A502 0000 0258 0A00 I.9Q.........X..
0x00007FC964A88AE8 : 0358 0A00 49E7 3951 0000 0000 0000 0000 .X..I.9Q........
2013-03-09-20.30.57.484491+480 I54596060E594 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:150
MESSAGE : Workspace info dumped! Check
/home/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_
0000/6518.62.000.apm.bin for additional data.
2013-03-09-20.30.57.484633+480 I54596655E634 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, probe:175
MESSAGE : MASTER TIME INFO
DATA #1 : Hexdump, 32 bytes
0x00007FC964A88AD8 : 49E7 3951 0000 0000 A502 0000 0258 0A00 I.9Q.........X..
0x00007FC964A88AE8 : 0358 0A00 49E7 3951 0000 0000 0000 0000 .X..I.9Q........
2013-03-09-20.30.57.484886+480 I54597290E599 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_full_dump, probe:25
MESSAGE : Package Cache info dumped! Check
/home/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_
0000/6518.62.000.apm.bin for additional data.
2013-03-09-20.30.57.485115+480 I54597890E510 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler, probe:350
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.
2013-03-09-20.30.57.485697+480 I54598401E912 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 46 bytes
Container information : path, contID, mapInfo.
DATA #2 : File name, 46 bytes
/home/gjywinst/tablespaces/SMS32K/SQL00052.DAT
DATA #3 : Container ID, PD_TYPE_SQLB_CONTAINER_ID, 4 bytes
0
DATA #4 : SQLB_MAP_INFO, PD_TYPE_SQLB_MAP_INFO, 16 bytes
offset: 15 length: 390032512 blkSize: 15
2013-03-09-20.30.57.485976+480 I54599314E521 LEVEL: Event
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking /home/gjywinst/sqllib/bin/db2cos_datacorruption from buffer pool services sqlbVerifyCBITS
2013-03-09-20.31.00.509747+480 I54599836E542 LEVEL: Warning
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:110
MESSAGE : Detected end of execution of call-out script
DATA #1 : Process ID, 4 bytes
612
DATA #2 : unsigned integer, 4 bytes
3
2013-03-09-20.31.00.510050+480 I54600379E489 LEVEL: Event
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP : Completed invoking /home/gjywinst/sqllib/bin/db2cos_datacorruption
2013-03-09-20.31.00.510220+480 I54600869E689 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 :
Failed to read page from disk on attempt number 1.
Retrying operation. Only subsequent failures will be logged.
2013-03-09-20.31.00.511175+480 I54601559E3887 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 95 bytes
CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
15
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:4;obj:52;type:0} Parent={4;52}
lifeLSN: 000000060DB964F5
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 101
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 2
partialHash: 3407876
bufferPool: 0x00007fc93db243c0
pdef: 0x00007fc964a130a0
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:4;obj:52;type:0} PPNum:15 OPNum:15
begoff: 48
datlen: 32720
pagebinx: 10054
revnum: 1280
pagelsn: 000000061A572B5C flag: e
future32: 0
cbits1to31: 9860a8
cbits32to63: 1a
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1256 bytes
dbcb: 0x0000000200cc8960
bpcb: 0x00007fc93601cd20
ptbl: 0x00007fc93601cea0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000200fe0080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 600
dbmon_cb: 0x0000000000000000
eduId: 62
curPfQ: 1
curRemHateListCounter: 173
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr: CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x00007FCA2726BF52 pdLog + 0x398
[1] 0x00007FCA27F46BF8 _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BE
[2] 0x00007FCA29A22A6F /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x34F5A6F
[3] 0x00007FCA29A201C1 sqlbReadPage + 0x25F
[4] 0x00007FCA29A1743E _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x4F2
[5] 0x00007FCA29A0A3A7 _Z7sqlbfixP11SQLB_FIX_CB + 0x1059
[6] 0x00007FCA29A37512 /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x350A512
[7] 0x00007FCA29A35922 _Z7sqldfrdP13SQLD_DFM_WORK + 0xAA
[8] 0x00007FCA29A2B17A _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP12SQLD_ID_LISTP9SQLP_LSN8 + 0xFC0
[9] 0x00007FCA29ACD271 _Z17sqlritaSimplePermP8sqlrr_cb + 0xCD
2013-03-09-20.31.00.517903+480 I54605447E689 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1150
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 :
Failed to read page from disk on attempt number 2.
Retrying operation. Only subsequent failures will be logged.
2013-03-09-20.31.05.519351+480 I54606137E3887 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbVerifyCBITS, probe:1110
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 95 bytes
CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
15
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:4;obj:52;type:0} Parent={4;52}
lifeLSN: 000000060DB964F5
tid: 0 0 0
extentAnchor: 0
initEmpPages: 0
poolPage0: 0
poolflags: 101
objectState: 27
lastSMP: 0
pageSize: 32768
extentSize: 32
bufferPoolID: 2
partialHash: 3407876
bufferPool: 0x00007fc93db243c0
pdef: 0x00007fc964a130a0
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:4;obj:52;type:0} PPNum:15 OPNum:15
begoff: 48
datlen: 32720
pagebinx: 10054
revnum: 1280
pagelsn: 000000061A572B5C flag: e
future32: 0
cbits1to31: 9860a8
cbits32to63: 1a
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1256 bytes
dbcb: 0x0000000200cc8960
bpcb: 0x00007fc93601cd20
ptbl: 0x00007fc93601cea0
eduType: SQLB_EDU_AGENT
eduCB: 0x0000000200fe0080
qryData: 0x0000000000000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x0000000000000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 600
dbmon_cb: 0x0000000000000000
eduId: 62
curPfQ: 1
curRemHateListCounter: 173
debugInfo: 0x0000000000000000
pCurRecLsn: 0x0000000000000000
clnrCB: 0x0000000000000000
prefetchPriority: 1
agentPriorityWeight: 00
staticStr: CBIT verification error
bitExpected is 1, userByte is 0, sector 63 (from head of page, 0 based)
numPFRequestsHeld: 0
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x00007FCA2726BF52 pdLog + 0x398
[1] 0x00007FCA27F46BF8 _Z25sqlbLogReadAttemptFailurejP16SQLB_OBJECT_DESCjP9SQLB_PAGEibmjPcP12SQLB_GLOBALS + 0x1BE
[2] 0x00007FCA29A22A6F /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x34F5A6F
[3] 0x00007FCA29A201C1 sqlbReadPage + 0x25F
[4] 0x00007FCA29A1743E _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi + 0x4F2
[5] 0x00007FCA29A0A3A7 _Z7sqlbfixP11SQLB_FIX_CB + 0x1059
[6] 0x00007FCA29A37512 /home/gjywinst/sqllib/lib64/libdb2e.so.1 + 0x350A512
[7] 0x00007FCA29A35922 _Z7sqldfrdP13SQLD_DFM_WORK + 0xAA
[8] 0x00007FCA29A2B17A _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP12SQLD_ID_LISTP9SQLP_LSN8 + 0xFC0
[9] 0x00007FCA29ACD271 _Z17sqlritaSimplePermP8sqlrr_cb + 0xCD
2013-03-09-20.31.05.526225+480 I54610025E615 LEVEL: Severe
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1199
MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
DIA8426C A invalid page checksum was found for page "".
DATA #1 :
Converting to non-critical read error
2013-03-09-20.31.05.526448+480 E54610641E629 LEVEL: Warning
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage, probe:1199
MESSAGE : ADM6006E DB2 encountered an error while reading page "15" from table
space "4" for object "52" (located at offset "15" of container
"/home/gjywinst/tablespaces/SMS32K/SQL00052.DAT").
2013-03-09-20.31.05.526971+480 I54611271E614 LEVEL: Event
PID : 6518 TID : 140505950185216PROC : db2sysc 0
INSTANCE: gjywinst NODE : 000 DB : GJYWDB
APPHDL : 0-2557 APPID: *LOCAL.gjywinst.130309123003
AUTHID : GJYW
EDUID : 62 EDUNAME: db2agent (GJYWDB) 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/gjywinst/sqllib/db2dump/FODC_BadPage_2013-03-09-20.30.57.454163_0000/ for diagnostic information.
2013-03-09-20.31.05.530688+480 I54611886E497 LEVEL: Error
PID : 32171 TID : 140682339686144PROC : db2bp
INSTANCE: gjywinst NODE : 000
APPID : *LOCAL.gjywinst.130309123003
FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca, probe:2136
MESSAGE : SQL1655C The operation could not be completed due to an error
accessing data on disk.
DATA #1 : String, 12 bytes
sqluexpm.SQC
DATA #2 : String, 44 bytes
Error from Import/Export or Load Processing.
早上关闭这个系统后中午再开启来后,发现一切又都正常了。囧~~~收起