网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索

 
 
 
日一二三四五六
       
       
       
       
       
       

签到排名:今日本吧第个签到,

本吧因你更精彩,明天继续来努力!

本吧签到人数:0

一键签到
成为超级会员,使用一键签到
一键签到
本月漏签0次!
0
成为超级会员,赠送8张补签卡
如何使用?
点击日历上漏签日期,即可进行补签。
连续签到:天  累计签到:天
0
超级会员单次开通12个月以上,赠送连续签到卡3张
使用连续签到卡
11月25日漏签0天
db2吧 关注:1,099贴子:2,508
  • 看贴

  • 图片

  • 吧主推荐

  • 游戏

  • 1回复贴,共1页
<<返回db2吧
>0< 加载中...

db2一次插入过多数据未提交挂掉后,启不来了,求大神

  • 只看楼主
  • 收藏

  • 回复
  • 楼小没有小JJ
  • 初级粉丝
    1
该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
2017-11-27-16.36.09.882686-360 E85900A516 LEVEL: Warning (OS)
PID : 438500 TID : 1 PROC : db2spmrsy 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-6
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already exists"
DIA8722C A file already exists.
CALLED : OS, -, open
OSERR : EEXIST (17) "Do not specify an existing file."
DATA #1 : File name, 39 bytes
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF
2017-11-27-16.36.09.906857-360 E86417A302 LEVEL: Event
PID : 348190 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
2017-11-27-16.36.32.208751-360 I86720A365 LEVEL: Warning
PID : 463090 TID : 1 PROC : db2agent (UIBS) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-7 APPID: 10.17.0.252.34672.171127223632
AUTHID : EUSER
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2017-11-27-16.36.32.505286-360 I87086A448 LEVEL: Warning
PID : 463090 TID : 1 PROC : db2agent (UIBS) 0
INSTANCE: db2inst1 NODE : 000 DB : UIBS
APPHDL : 0-7 APPID: 10.17.0.252.34672.171127223632
AUTHID : EUSER
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000000420D3152F MinbuffLSN
00000004232BC9B6
2017-11-27-16.36.32.506457-360 I87535A442 LEVEL: Warning
PID : 463090 TID : 1 PROC : db2agent (UIBS) 0
INSTANCE: db2inst1 NODE : 000 DB : UIBS
APPHDL : 0-7 APPID: 10.17.0.252.34672.171127223632
AUTHID : EUSER
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
DATA #1 : <preformatted>
Using parallel recovery with 3 agents 8 QSets 24 queues and 6 chunks
2017-11-27-16.36.46.826414-360 E87978A839 LEVEL: Severe
PID : 466996 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : <preformatted>
An EDU with process id 303258 was terminated by a SIGKILL signal.
It is not possible to produce a trap file in this case.
CALLSTCK:
[0] 0x0900000001305674 @49@sqloEDUSIGCHLDHandler__FiP9siginfo_tPv + 0x218
[1] 0x0000000000000000 ?unknown + 0x0
[2] 0x0000000000000000 ?unknown + 0x0
[3] 0x0000000000000000 ?unknown + 0x0
[4] 0x0000000000000000 ?unknown + 0x0
[5] 0x0000000000000000 ?unknown + 0x0
[6] 0x0000000000000000 ?unknown + 0x0
[7] 0x0000000000000000 ?unknown + 0x0
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0
2017-11-27-16.36.47.298119-360 I88818A339 LEVEL: Event
PID : 466996 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
START : Invoking /home/db2inst1/sqllib/bin/db2cos from oper system services sqloEDUCodeTrapHandler
2017-11-27-16.36.53.321874-360 I89158A300 LEVEL: Event
PID : 466996 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
STOP : Completed invoking /home/db2inst1/sqllib/bin/db2cos
2017-11-27-16.36.53.323742-360 E89459A510 LEVEL: Severe
PID : 466996 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL
DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
Diagnostic information has been recorded. Contact IBM Support for
further assistance.
2017-11-27-16.36.53.323946-360 E89970A642 LEVEL: Severe
PID : 466996 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 64 bytes
0x0FFFFFFFFFFFD630 : 0000 0006 0000 0000 0000 0009 0000 0000 ................
0x0FFFFFFFFFFFD640 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFD650 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFFD660 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2017-11-27-16.36.53.336677-360 E90613A336 LEVEL: Error
PID : 487470 TID : 1 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
DATA #1 : <preformatted>
An EDU crashed. Process id: 466996, OSS term code: 0x101, signal: 6
2017-11-27-16.36.53.336990-360 I90950A334 LEVEL: Error
PID : 487470 TID : 1 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:20
MESSAGE : Return code from removing fmp from pool:
DATA #1 : signed integer, 4 bytes
-888
2017-11-27-16.36.53.337122-360 I91285A321 LEVEL: Error
PID : 487470 TID : 1 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleRunSysCtlr, probe:600
DATA #1 : <preformatted>
Reason code for abrupt termination of system controller: 0
2017-11-27-16.36.53.337315-360 I91607A330 LEVEL: Severe
PID : 487470 TID : 1 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleSysCtlr, probe:10
DATA #1 : Hexdump, 4 bytes
2017-11-27-16.36.53.346104-360 I92446A343 LEVEL: Severe
PID : 315636 TID : 1 PROC : db2wdog 0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloWatchDogMain, probe:20
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFFF220 : 0000 0102 0000 0009 ........
2017-11-27-16.36.53.346229-360 I92790A759 LEVEL: Error
PID : 315636 TID : 1 PROC : db2wdog 0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
MESSAGE : Sending SIGKILL to the following process id
DATA #1 : signed integer, 4 bytes
-487470
CALLSTCK:
[0] 0x0900000000DD17EC sqlossig + 0x194
[1] 0x0900000000E610B0 sqloWatchDogMain + 0x170
[2] 0x0900000001DD2044 sqloRunInstance + 0xD0
[3] 0x00000001000029F4 DB2main + 0x92C
[4] 0x0000000100003D50 main + 0x10
[5] 0x0000000100000318 __start + 0x90
[6] 0x0000000000000000 ?unknown + 0x0
[7] 0x0000000000000000 ?unknown + 0x0
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0
2017-11-27-16.36.53.346433-360 I93550A340 LEVEL: Severe
PID : 315636 TID : 1 PROC : db2wdog 0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFF1D0 : 0000 0102 ....
2017-11-27-16.36.53.347392-360 I93891A405 LEVEL: Warning
PID : 315636 TID : 1 PROC : db2wdog 0 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFEF70 : 0000 0000 ....
2017-11-27-16.36.53.509837-360 I94297A343 LEVEL: Severe
PID : 372746 TID : 1 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF30 : 870F 0042 ...B
2017-11-27-16.36.53.510785-360 I94641A343 LEVEL: Severe
PID : 483344 TID : 1 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF30 : 870F 0042 ...B
2017-11-27-16.36.53.511787-360 I94985A343 LEVEL: Severe
PID : 479392 TID : 1 PROC : db2ckpwd 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:110
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFFDF30 : 870F 0042 ...B


  • Iam_Singer
  • 知名人士
    10
该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
1)不太好说。v9.1?修订包什么版本?db2dump下2017-11-27-16.36之后又哪些文件生成?
2)第一次挂掉(插入过多数据)时的db2diag日志?相应时间在db2dump下的生成的文件?
第一次挂掉的时候,你知道db2在干嘛么?


登录百度账号

扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频!
  • 贴吧页面意见反馈
  • 违规贴吧举报反馈通道
  • 贴吧违规信息处理公示
  • 1回复贴,共1页
<<返回db2吧
分享到:
©2025 Baidu贴吧协议|隐私政策|吧主制度|意见反馈|网络谣言警示