环境
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的数据,也没报错。
为啥这个就报错了?请各位大虾指点。