查询数据时报SQL1655C
环境
OS:WIN7 DB2 : V9.7.6
DX_AJ_REL_DSP_SCH_BRK_BAK这表总共有1044720条记录，查询到410407条的时候就hang住了，然后过一会儿提示：
SQL1655C
由于访问磁盘数据错误，该操作无法完成。
db2diag.log日志内容如下：
2013-12-03-11.42.42.560000+480 E63345630H567 LEVEL: Info (OS)
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
2013-12-03-11.42.42.560000+480 I63346199H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
2013-12-03-11.42.52.856000+480 E63346701H567 LEVEL: Info (OS)
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.52.856000+480 I63347270H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.52.856000+480 E63347772H605 LEVEL: Severe
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLFH, probe:750
MESSAGE : ADM1713C The DB2 database manager cannot start the database on
database partition "0" because the database manager can open neither
the primary log control file
"C:DB2NODE0000SQL00001SQLOGCTL.LFH.1" nor the secondary log
control file "C:DB2NODE0000SQL00001SQLOGCTL.LFH.2".
2013-12-03-11.42.52.856000+480 I63348379H569 LEVEL: Severe
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLFH, probe:750
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 :
There was an error opening log control files:
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.53.324000+480 I63348950H538 LEVEL: Warning
PID : 7968 TID : 5512 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SLDD
APPHDL : 0-7 APPID: fe80::54dc:15ec:ac66:5461%16.52595.131203034014
AUTHID : DB2ADMIN
EDUID : 5512 EDUNAME: db2agent (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDumpOnDisk, probe:75
DATA #1 :
Using db2dart /DEMP to dump the EMP of read in object on disk to EMP.obj1289.
2013-12-03-11.42.54.057000+480 I63349490H398 LEVEL: Info
PID : 7400 TID : 3764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 3764
FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAuthPlugin, probe:10
DATA #1 : String, 91 bytes
Loaded plugin library C:PROGRA~2IBMSQLLIBsecuritypluginIBMclientIBMOSauthclient.dll
从提示看，说SQLOGCTL.LFH.1和SQLOGCTL.LFH.2日志控制文件打不开，这两个文件存在的，而且我全部查询另外一个表210W的数据，也没报错。
为啥这个就报错了？请各位大虾指点。
OS:WIN7 DB2 : V9.7.6
DX_AJ_REL_DSP_SCH_BRK_BAK这表总共有1044720条记录，查询到410407条的时候就hang住了，然后过一会儿提示：
SQL1655C
由于访问磁盘数据错误，该操作无法完成。
db2diag.log日志内容如下：
2013-12-03-11.42.42.560000+480 E63345630H567 LEVEL: Info (OS)
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
2013-12-03-11.42.42.560000+480 I63346199H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
2013-12-03-11.42.52.856000+480 E63346701H567 LEVEL: Info (OS)
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.52.856000+480 I63347270H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.52.856000+480 E63347772H605 LEVEL: Severe
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLFH, probe:750
MESSAGE : ADM1713C The DB2 database manager cannot start the database on
database partition "0" because the database manager can open neither
the primary log control file
"C:DB2NODE0000SQL00001SQLOGCTL.LFH.1" nor the secondary log
control file "C:DB2NODE0000SQL00001SQLOGCTL.LFH.2".
2013-12-03-11.42.52.856000+480 I63348379H569 LEVEL: Severe
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLFH, probe:750
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 :
There was an error opening log control files:
C:DB2NODE0000SQL00001SQLOGCTL.LFH.1
C:DB2NODE0000SQL00001SQLOGCTL.LFH.2
2013-12-03-11.42.53.324000+480 I63348950H538 LEVEL: Warning
PID : 7968 TID : 5512 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SLDD
APPHDL : 0-7 APPID: fe80::54dc:15ec:ac66:5461%16.52595.131203034014
AUTHID : DB2ADMIN
EDUID : 5512 EDUNAME: db2agent (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDumpOnDisk, probe:75
DATA #1 :
Using db2dart /DEMP to dump the EMP of read in object on disk to EMP.obj1289.
2013-12-03-11.42.54.057000+480 I63349490H398 LEVEL: Info
PID : 7400 TID : 3764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 3764
FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAuthPlugin, probe:10
DATA #1 : String, 91 bytes
Loaded plugin library C:PROGRA~2IBMSQLLIBsecuritypluginIBMclientIBMOSauthclient.dll
从提示看，说SQLOGCTL.LFH.1和SQLOGCTL.LFH.2日志控制文件打不开，这两个文件存在的，而且我全部查询另外一个表210W的数据，也没报错。
为啥这个就报错了？请各位大虾指点。
19同行回答
浏览1841
回复 12# weiruan85
我刚才把360关了，试了一下，还是报错，错误如下：
2013-12-04-08.50.30.034000+480 I28697H3124 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
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
14717
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 80 bytes
Obj: {pool:3;obj:275;type:0} Parent={3;275}
lifeLSN: 000000013BF4EC50
tid: 0 0 0
extentAnchor: 2432
initEmpPages: 0
poolPage0: 0
poolflags: 102
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 16
bufferPoolID: 1
partialHash: 18022403
bufferPool: 0xfbb583c0
pdef: 0xfbbc7950
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:3;obj:1289;type:0} PPNum:14717 OPNum:205
begoff: 48
datlen: 4048
pagebinx: 7428
revnum: 1280
pagelsn: 00000000B39E0411 flag: 2
future32: 0
cbits1to31: 9
cbits32to63: 0
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1176 bytes
dbcb: 0xfe260060
bpcb: 0xfd24ba20
ptbl: 0xfd24bb30
eduType: SQLB_EDU_PREFETCHER
eduCB: 0xfaba0060
qryData: 0x00000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x00000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 200000
dbmon_cb: 0xfbc0b1a0
eduId: 5548
curPfQ: 4
curRemHateListCounter: 66858
debugInfo: 0x00000000
pCurRecLsn: 0x00000000
clnrCB: 0x00000000
prefetchPriority: 0
agentPriorityWeight: 00
staticStr:
numPFRequestsHeld: 1
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x6CD8B40A pdLog + 0x2EC
[1] 0x6D63B9BF sqlbLogReadAttemptFailure + 0x177
[2] 0x6D63E219 sqlb_verify_page + 0x361
[3] 0x6D6C37BB sqlbReadAndReleaseBuffers + 0x9A9
[4] 0x6D6C2287 sqlbProcessRange + 0xE9
[5] 0x6D6C2150 ?sqlbServiceRangeRequest.@@YAHPAUSQLB_pfMisc@@@Z + 0x9E
[6] 0x6D6C1C1D ?sqlbPFPrefetcherEntryPoint.@@YAXPAVsqbPrefetcherEdu@@@Z + 0x1D3
[7] 0x6D6C19D9 sqbPrefetcherEdu::RunEDU + 0x27
[8] 0x6E9335A1 sqzEDUObj::EDUDriver + 0xFF
[9] 0x6E93349D sqlzRunEDU + 0xD
2013-12-04-08.50.30.221000+480 E31823H839 LEVEL: Critical
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 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
"F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\". Please
look in this directory for detailed evidence about what happened and
contact IBM support if necessary to diagnose the problem.
2013-12-04-08.50.30.221000+480 I32664H650 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
DATA #1 : String, 33 bytes
Page verification error occurred.
DATA #2 : Dumped object of size 4096 bytes at offset 0, 80 bytes
F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\5840.5548.000.dump.bin
2013-12-04-08.50.30.252000+480 I33316H203 LEVEL: Severe
PID:5840 TID:5548 NODE:000 Title: SQLB_PAGE
Dump File: F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\5840.5548.000.dump.bin
2013-12-04-08.50.30.346000+480 I33521H768 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
DATA #1 : String, 46 bytes
Container information : path, contID, mapInfo.
DATA #2 : File name, 34 bytes
E:\DB2\data\db2data\userdata01.dbf
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: 14733 length: 0 blkSize: 12
2013-12-04-08.50.30.346000+480 I34291H421 LEVEL: Event
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking C:\PROGRA~2\IBM\SQLLIB\bin\db2cos_datacorruption.bat from buffer pool services sqlb_verify_page
提示校验页的时候，发现page header损坏。收起
我刚才把360关了，试了一下，还是报错，错误如下：
2013-12-04-08.50.30.034000+480 I28697H3124 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
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
14717
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 80 bytes
Obj: {pool:3;obj:275;type:0} Parent={3;275}
lifeLSN: 000000013BF4EC50
tid: 0 0 0
extentAnchor: 2432
initEmpPages: 0
poolPage0: 0
poolflags: 102
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 16
bufferPoolID: 1
partialHash: 18022403
bufferPool: 0xfbb583c0
pdef: 0xfbbc7950
DATA #5 : Bitmask, 4 bytes
0x00000002
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {tbspSeed:3;obj:1289;type:0} PPNum:14717 OPNum:205
begoff: 48
datlen: 4048
pagebinx: 7428
revnum: 1280
pagelsn: 00000000B39E0411 flag: 2
future32: 0
cbits1to31: 9
cbits32to63: 0
DATA #7 : Bufferpool globals, PD_TYPE_SQLB_GLOBALS, 1176 bytes
dbcb: 0xfe260060
bpcb: 0xfd24ba20
ptbl: 0xfd24bb30
eduType: SQLB_EDU_PREFETCHER
eduCB: 0xfaba0060
qryData: 0x00000000
qryDataSz: 0
qryDataPos: 0
contQryData: 0x00000000
contQryDataSz: 0
contQryDataPos: 0
bglobals_flags: 200000
dbmon_cb: 0xfbc0b1a0
eduId: 5548
curPfQ: 4
curRemHateListCounter: 66858
debugInfo: 0x00000000
pCurRecLsn: 0x00000000
clnrCB: 0x00000000
prefetchPriority: 0
agentPriorityWeight: 00
staticStr:
numPFRequestsHeld: 1
memAccessCount:
m_bIsInitialized: false
m_iDisabled: 0
m_iAccessCount: 0
CALLSTCK:
[0] 0x6CD8B40A pdLog + 0x2EC
[1] 0x6D63B9BF sqlbLogReadAttemptFailure + 0x177
[2] 0x6D63E219 sqlb_verify_page + 0x361
[3] 0x6D6C37BB sqlbReadAndReleaseBuffers + 0x9A9
[4] 0x6D6C2287 sqlbProcessRange + 0xE9
[5] 0x6D6C2150 ?sqlbServiceRangeRequest.@@YAHPAUSQLB_pfMisc@@@Z + 0x9E
[6] 0x6D6C1C1D ?sqlbPFPrefetcherEntryPoint.@@YAXPAVsqbPrefetcherEdu@@@Z + 0x1D3
[7] 0x6D6C19D9 sqbPrefetcherEdu::RunEDU + 0x27
[8] 0x6E9335A1 sqzEDUObj::EDUDriver + 0xFF
[9] 0x6E93349D sqlzRunEDU + 0xD
2013-12-04-08.50.30.221000+480 E31823H839 LEVEL: Critical
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 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
"F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\". Please
look in this directory for detailed evidence about what happened and
contact IBM support if necessary to diagnose the problem.
2013-12-04-08.50.30.221000+480 I32664H650 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
DATA #1 : String, 33 bytes
Page verification error occurred.
DATA #2 : Dumped object of size 4096 bytes at offset 0, 80 bytes
F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\5840.5548.000.dump.bin
2013-12-04-08.50.30.252000+480 I33316H203 LEVEL: Severe
PID:5840 TID:5548 NODE:000 Title: SQLB_PAGE
Dump File: F:\diag_path\FODC_BadPage_2013-12-04-08.50.30.221000_0000\5840.5548.000.dump.bin
2013-12-04-08.50.30.346000+480 I33521H768 LEVEL: Severe
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page, probe:6
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page Header"
DIA8547C An error occurred in a database page header.
DATA #1 : String, 46 bytes
Container information : path, contID, mapInfo.
DATA #2 : File name, 34 bytes
E:\DB2\data\db2data\userdata01.dbf
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: 14733 length: 0 blkSize: 12
2013-12-04-08.50.30.346000+480 I34291H421 LEVEL: Event
PID : 5840 TID : 5548 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 5548 EDUNAME: db2pfchr (SLDD) 0
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking C:\PROGRA~2\IBM\SQLLIB\bin\db2cos_datacorruption.bat from buffer pool services sqlb_verify_page
提示校验页的时候，发现page header损坏。收起
浏览2406
2013-12-03-11.42.42.560000+480 E63345630H567 LEVEL: Info (OS)
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:\DB2\NODE0000\SQL00001\SQLOGCTL.LFH.1
2013-12-03-11.42.42.560000+480 I63346199H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
windows 是不是有杀毒软件之类的在访问数据库文件，不行重启一下操作系统。收起
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:90
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
CALLED : OS, -, CreateFile
OSERR : 32 "另一个程序正在使用此文件，进程无法访问。"
DATA #1 : File name, 39 bytes
C:\DB2\NODE0000\SQL00001\SQLOGCTL.LFH.1
2013-12-03-11.42.42.560000+480 I63346199H500 LEVEL: Warning
PID : 7088 TID : 5764 PROC : db2dart.exe
INSTANCE: DB2 NODE : 000
EDUID : 5764
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLatestLFHRecord, probe:420
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
DIA8519C A file sharing violation has occurred, filename was "".
DATA #1 : String, 39 bytes
windows 是不是有杀毒软件之类的在访问数据库文件，不行重启一下操作系统。收起
浏览1925