电信设备制造商
在win2008上安装db2,然后每隔几小时就报错重启服务。
我把db2diag.log贴出来DB2 版本7.2 FIXpak132013-03-21-12.31.42.733001 Instance:DB2 Node:000PID:4056(db2syscs.exe) TID:4976 Appid:nonebuffer_pool_services sqlbSMSOpenContainer ...显示全部
我把db2diag.log贴出来
DB2 版本7.2 FIXpak13
2013-03-21-12.31.42.733001 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSOpenContainer Probe:820
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.733002 Instance :DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSOpenContainer Probe:820
Obj={pool:2;obj:48;type:0} State=x27 Cont=0
F:DB2NODE0000SQL00013SQLT0002.0SQL00048.DAT
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748000 Instance :DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSGetOpenInfo Probe:810
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748001 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSGetOpenInfo Probe:810
Obj={pool:2;obj:48;type:0} State=x27 Cont=0
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748003 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbReadAndReleaseBuffers Probe:30
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748004 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbReadAndReleaseBuffers Probe:30
Obj={pool:2;obj:48;type:0} State=x27 Page=0 Cont=0 Offset=0 BlkSize=12
sqlbReadAndReleaseBuffers error: num-pages=7
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748006 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbErrorHandler Probe:0
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748007 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbErrorHandler Probe:0
Obj={pool:2;obj:48;type:0} State=x27
Prefetcher Error, in sqlbServiceListRequest
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=2, obj(FID)=315, indexid(IID)=0, class=0
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=1, obj(FID)=2, indexid(IID)=0, class=128
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=2, obj(FID)=48, indexid(IID)=0, class=0
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:<< End CURSOR dump: PID:4056 Node:000
CLOSED CURSORS: <<
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLI_CB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLE_ACB
2013-03-21-12.31.43.325013 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4524 Appid:*LOCAL.DB2.130321010451
data_protection sqlpgdmp Probe:111 Database:XINWANG1
Active Log Buffer is dumped to: F:DB2NODE0000SQL00013LOGBUFF.DMP
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_ACB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_DBCB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_TRTBL
String Title:locklist PID:4056 Node:000
Check F:PROGRA~1SQLLIBDB2l4684.000 for additional data.
2013-03-21-12.31.48.723000 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.31.48.723001 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.32.09.237001 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.32.46.631000 Instance:DB2 Node:000
PID:4764(db2syscs.exe) TID:1972 Appid:none
base_sys_utilities LicCheckProcessors Probe:11
SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Edition". The number of
processors on this machine is "4". You should purchase additional processor
entitlements from your IBM representative or authorized dealer and update your
license using the License Center or the db2licm command line utility. For more
information on updating processor licenses, refer to the Quick Beginnings
manual for your platform. For more information on the db2licm utility, refer
to the DB2 Command Reference.
2013-03-21-12.32.47.707000 Instance:DB2 Node:000
PID:4764(db2syscs.exe) TID:1972 Appid:none
base_sys_utilities startdbm Probe:911
Database manager is started.收起
DB2 版本7.2 FIXpak13
2013-03-21-12.31.42.733001 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSOpenContainer Probe:820
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.733002 Instance :DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSOpenContainer Probe:820
Obj={pool:2;obj:48;type:0} State=x27 Cont=0
F:DB2NODE0000SQL00013SQLT0002.0SQL00048.DAT
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748000 Instance :DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSGetOpenInfo Probe:810
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748001 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbSMSGetOpenInfo Probe:810
Obj={pool:2;obj:48;type:0} State=x27 Cont=0
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748003 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbReadAndReleaseBuffers Probe:30
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748004 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbReadAndReleaseBuffers Probe:30
Obj={pool:2;obj:48;type:0} State=x27 Page=0 Cont=0 Offset=0 BlkSize=12
sqlbReadAndReleaseBuffers error: num-pages=7
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
2013-03-21-12.31.42.748006 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbErrorHandler Probe:0
DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2013-03-21-12.31.42.748007 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4976 Appid:none
buffer_pool_services sqlbErrorHandler Probe:0
Obj={pool:2;obj:48;type:0} State=x27
Prefetcher Error, in sqlbServiceListRequest
Data Title:SQLB_OBJECT_DESC PID:4056 TID:4976 Node:000
0200 3000 0200 3000 0000 0000 0000 00e3 ..0...0.........
e8dc 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0010 0000 2000 0000 0100 0000 0200 3000 .... .........0.
48b7 b303 3080 1203 H...0...
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=2, obj(FID)=315, indexid(IID)=0, class=0
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=1, obj(FID)=2, indexid(IID)=0, class=128
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:4056 Node:000
pool(TID)=2, obj(FID)=48, indexid(IID)=0, class=0
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLD_CCB
String Title:<< End CURSOR dump: PID:4056 Node:000
CLOSED CURSORS: <<
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLI_CB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLE_ACB
2013-03-21-12.31.43.325013 Instance:DB2 Node:000
PID:4056(db2syscs.exe) TID:4524 Appid:*LOCAL.DB2.130321010451
data_protection sqlpgdmp Probe:111 Database:XINWANG1
Active Log Buffer is dumped to: F:DB2NODE0000SQL00013LOGBUFF.DMP
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_ACB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_DBCB
Dump File:F:PROGRA~1SQLLIBDB240564524.000 Data:SQLP_TRTBL
String Title:locklist PID:4056 Node:000
Check F:PROGRA~1SQLLIBDB2l4684.000 for additional data.
2013-03-21-12.31.48.723000 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.31.48.723001 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.32.09.237001 Instance:DB2 Node:000
PID:5732(dllhost.exe) TID:5344 Appid:*LOCAL.DB2.130321005332
oper_system_services sqlo_ssem_set_close Probe:1
0000 0000 ....
2013-03-21-12.32.46.631000 Instance:DB2 Node:000
PID:4764(db2syscs.exe) TID:1972 Appid:none
base_sys_utilities LicCheckProcessors Probe:11
SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Edition". The number of
processors on this machine is "4". You should purchase additional processor
entitlements from your IBM representative or authorized dealer and update your
license using the License Center or the db2licm command line utility. For more
information on updating processor licenses, refer to the Quick Beginnings
manual for your platform. For more information on the db2licm utility, refer
to the DB2 Command Reference.
2013-03-21-12.32.47.707000 Instance:DB2 Node:000
PID:4764(db2syscs.exe) TID:1972 Appid:none
base_sys_utilities startdbm Probe:911
Database manager is started.收起