- 论坛徽章:
- 0
|
只要执行log里面的语句肯定stop
2004-03-11-13.42.07.960035 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
oss_2 sqloEDUCodeTrapHandler Probe:10 Database:FMISDB
********************************************************************
* *
* DB2 USERS : *
* ----------- *
* An internal processing error occurred on this DB2 instance. *
* *
* A stack trace-back for the process in which the error was *
* detected may be written to a trap file in the directory *
* containing this log. The name of the file will be 'tppppp.nnn' *
* where ppppp is the process id, and nnn is the node number. *
* *
* *
* ALL DB2 PROCESSES ASSOCIATED WITH *
* THIS INSTANCE HAVE BEEN SHUTDOWN. *
* *
* Contact your technical service representative with the *
* information from this log and from the auxiliary trace and dump *
* files in the same directory. *
********************************************************************
2004-03-11-13.42.08.069571 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
oss_2 sqloEDUCodeTrapHandler Probe:20 Database:FMISDB
Signal number received
0000 000b ....
2004-03-11-13.42.08.361618 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:FMISDB
DIA3816C A severe internal processing error has occurred.
2004-03-11-13.42.08.464597 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:FMISDB
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF707".
Data Title:SQLCA PID:40780 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL05020
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) ( (9) (10) (11)
sqlstate: 00000
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLCA
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data B2RA
Data Title:CREATOR PID:40780 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title ACKAGE PID:40780 Node:000
5351 4c4c 3138 4e35 SQLL18N5
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:CREATOR
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 DataACKAGE
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:REQUEST TYPE
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:Recursive dump_sect
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 DataACKAGE ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SECTION NUMBER
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SECTION DIR ENTRY
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:cursor name
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:cache cb
Data Title:section stmt PID:40780 Node:000
7365 6c65 6374 2064 6973 7469 6e63 7420 select distinct
2873 656c 6563 7420 4f70 6572 6174 696f (select Operatio
6e20 6672 6f6d 2073 7966 6d73 3236 2e4f n from syfms26.O
5052 404f 7065 7261 7469 6f6e 2020 5768 PR@Operation Wh
6572 6520 496e 666f 2e4f 7072 4b69 6e64 ere Info.OprKind
203d 204f 7072 4b69 6e64 2029 2061 7320 = OprKind ) as
4f70 6572 6174 696f 6e2c 496e 2e4f 7072 Operation,In.Opr
4e6f 2c49 6e66 6f2e 4f70 7259 6561 722c No,Info.OprYear,
496e 666f 2e4f 7072 4d6f 6e74 682c 496e Info.OprMonth,In
666f 2e4f 7072 4461 792c 6469 6769 7473 fo.OprDay,digits
2849 6e66 6f2e 4f70 7259 6561 7229 7c7c (Info.OprYear)||
272d 277c 7c64 6967 6974 7328 496e 666f '-'||digits(Info
2e4f 7072 4d6f 6e74 6829 7c7c 272d 277c .OprMonth)||'-'|
7c64 6967 6974 7328 496e 666f 2e4f 7072 |digits(Info.Opr
4461 7929 2061 7320 4f70 7244 6174 652c Day) as OprDate,
496e 2e41 6d6f 756e 742c 2873 656c 6563 In.Amount,(selec
7420 4465 706f 744e 616d 6520 6672 6f6d t DepotName from
2073 7966 6d73 3236 2e53 5452 4044 6570 syfms26.STR@Dep
6f74 2020 7768 6572 6520 496e 2e44 6570 ot where In.Dep
6f74 436f 6465 203d 2044 6570 6f74 436f otCode = DepotCo
6465 2029 2061 7320 4465 706f 744e 616d de ) as DepotNam
652c 496e 2e50 726f 7669 6465 724e 616d e,In.ProviderNam
652c 496e 2e43 6f6e 7472 6163 7443 6f64 e,In.ContractCod
652c 496e 2e49 6e76 6f69 6365 436f 6465 e,In.InvoiceCode
2c49 6e2e 4f70 724b 696e 642c 496e 2e41 ,In.OprKind,In.A
6363 6f72 6459 6561 722c 496e 2e41 6363 ccordYear,In.Acc
6f72 644b 696e 642c 496e 2e41 6363 6f72 ordKind,In.Accor
644e 6f2c 496e 666f 2e41 7070 4465 7061 dNo,Info.AppDepa
7274 2c20 2727 2061 7320 4465 7061 7274 rt, '' as Depart
4e61 6d65 2c28 7365 6c65 6374 204d 696e Name,(select Min
2855 7365 724e 616d 6529 2066 726f 6d20 (UserName) from
666d 7379 732e 5669 6577 4055 7365 7220 fmsys.View@User
2057 6865 7265 2049 6e66 6f2e 4170 7055 Where Info.AppU
7365 7220 3d20 5573 6572 4e6f 2029 2061 ser = UserNo ) a
7320 5573 6572 4e61 6d65 2c41 6363 2e41 s UserName,Acc.A
6363 5965 6172 2c41 6363 2e41 6363 4d6f ccYear,Acc.AccMo
6e74 682c 4163 632e 4163 6344 6179 2c64 nth,Acc.AccDay,d
6967 6974 7328 4163 632e 4163 6359 6561 igits(Acc.AccYea
7229 7c7c 272d 277c 7c64 6967 6974 7328 r)||'-'||digits(
4163 632e 4163 634d 6f6e 7468 297c 7c27 Acc.AccMonth)||'
2d27 7c7c 6469 6769 7473 2841 6363 2e41 -'||digits(Acc.A
6363 4461 7929 2061 7320 4163 6344 6174 ccDay) as AccDat
652c 496e 2e41 6363 466c 6167 2c49 6e46 e,In.AccFlag,InF
6f2e 456e 6446 6c61 672c 496e 2e53 6572 o.EndFlag,In.Ser
6961 6c4e 6f20 6672 6f6d 2073 7966 6d73 ialNo from syfms
3236 2e4f 5052 404f 7072 496e 666f 726d 26.OPR@OprInform
6174 696f 6e20 496e 666f 2c73 7966 6d73 ation Info,syfms
3236 2e53 5452 4053 746f 7265 496e 2049 26.STR@StoreIn I
6e20 206c 6566 7420 6a6f 696e 2073 7966 n left join syf
6d73 3236 2e53 5452 4053 746f 7265 4163 ms26.STR@StoreAc
636f 756e 7420 4163 6320 6f6e 2041 6363 count Acc on Acc
2e4f 7072 5965 6172 203d 2049 6e2e 4f70 .OprYear = In.Op
7259 6561 7220 616e 6420 4163 632e 4f70 rYear and Acc.Op
724b 696e 6420 3d20 496e 2e4f 7072 4b69 rKind = In.OprKi
6e64 2061 6e64 2041 6363 2e4f 7072 4e6f nd and Acc.OprNo
203d 2049 6e2e 4f70 724e 6f20 2057 6865 = In.OprNo Whe
7265 2028 496e 666f 2e4f 7072 5965 6172 re (Info.OprYear
203d 2049 6e2e 4f70 7259 6561 7229 2061 = In.OprYear) a
6e64 2028 496e 666f 2e4f 7072 4b69 6e64 nd (Info.OprKind
203d 2049 6e2e 4f70 724b 696e 6429 2061 = In.OprKind) a
6e64 2028 496e 666f 2e4f 7072 4e6f 203d nd (Info.OprNo =
2049 6e2e 4f70 724e 6f29 2020 616e 6420 In.OprNo) and
496e 2e53 6572 6961 6c4e 6f20 3d20 2873 In.SerialNo = (s
656c 6563 7420 6d61 7828 5365 7269 616c elect max(Serial
4e6f 2920 2066 726f 6d20 7379 666d 7332 No) from syfms2
362e 5374 7240 5374 6f72 6549 6e20 7768 6.Str@StoreIn wh
6572 6520 4f70 7259 6561 7220 3d20 496e ere OprYear = In
2e4f 7072 5965 6172 2061 6e64 204f 7072 .OprYear and Opr
4b69 6e64 203d 2049 6e2e 4f70 724b 696e Kind = In.OprKin
6420 616e 6420 4f70 724e 6f20 3d20 496e d and OprNo = In
2e4f 7072 4e6f 2029 2061 6e64 2028 496e .OprNo ) and (In
666f 2e4f 7072 4b69 6e64 203d 2033 3230 fo.OprKind = 320
2061 6e64 2049 6e66 6f2e 4f70 724d 6f6e and Info.OprMon
7468 203d 2032 2920 6f72 6465 7220 6279 th = 2) order by
204f 7065 7261 7469 6f6e 2041 5343 202c Operation ASC ,
4f70 724e 6f20 4153 43 OprNo ASC
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:section stmt
2004-03-11-13.42.11.143693 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:FMISDB
DIA3816C A severe internal processing error has occurred.
ZRC=FFFFF707
2004-03-11-13.42.11.248737 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:FMISDB
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_AGENT_CB
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_TRAN_CB
Data Title:SQLD_AGENT_CB Pointer: PID:40780 Node:000
200b 3038 .08
Data Title:SQLD_AGENT_CB PID:40780 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 1000 200c 44d8 0000 0000 ........ .D?...
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 8000 2010 ede8 0000 1000 ........ .龛....
200c 31b8 0000 0000 .1?...
Data Title:SQLD_TRAN_CB Pointer PID:40780 Node:000
a000 80d0 ?.?
Data Title:SQLD_TRAN_CB PID:40780 Node:000
4000 8160 0000 0001 0000 0000 0000 0000 @..`............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0001 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 a000 d420 a000 8af0 0000 000b ....???.?...
0000 0007 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
String Title:Begin CURSOR dump: PID:40780 Node:000
OPEN PERM CURSORS:
String Title:End CURSOR dump: PID:40780 Node:000
OPEN PERM CURSORS:
String Title:Begin CURSOR dump: PID:40780 Node:000
OPEN TEMP CURSORS:
String Title:End CURSOR dump: PID:40780 Node:000
OPEN TEMP CURSORS:
String Title:Begin CURSOR dump: PID:40780 Node:000
CLOSED CURSORS:
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2712, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2446, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2450, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2919, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2919, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2882, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2851, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2740, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2920, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2856, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:40780 Node:000
pool(TID)=2, obj(FID)=2853, indexid(IID)=0, class=0
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLD_CCB
String Title:End CURSOR dump: PID:40780 Node:000
CLOSED CURSORS:
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLE_ACB
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLP_ACB
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLP_DBCB
Dump File:/home/db2inst1/sqllib/db2dump/40780.000 Data:SQLP_TRTBL
String Title:locklist PID:40780 Node:000
Check /home/db2inst1/sqllib/db2dump/l82985.000 for additional data.
2004-03-11-13.42.14.548749 Instance:db2inst1 Node:000
PID:40780(db2agent (FMISDB)) Appid:AC150074.091D.040309235854
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:FMISDB
snum 11, app handle 0:243
2004-03-11-13.43.30.958524 Instance:db2inst1 Node:000
PID:46208(db2tcpcm) Appid:none
oss_2 sqloEDUCodeTrapHandler Probe:155
DiagData
0000 9f4c ...L
2004-03-11-13.43.31.110342 Instance:db2inst1 Node:000
PID:46208(db2tcpcm) Appid:none
oss_2 sqloEDUCodeTrapHandler Probe:156
DiagData
0000 000b ....
2004-03-11-13.43.31.354139 Instance:db2inst1 Node:000
PID:27354(db2sysc) Appid:none
base_sys_utilities sqleRunSysCtlr Probe:10
DiagData
416e 2045 4455 2063 7261 7368 6564 2e00 An EDU crashed..
2004-03-11-13.43.31.530167 Instance:db2inst1 Node:000
PID:27354(db2sysc) Appid:none
base_sys_utilities sqleRunSysCtlr Probe:11
DiagData
0000 b480 ..?
2004-03-11-13.43.31.661881 Instance:db2inst1 Node:000
PID:27354(db2sysc) Appid:none
base_sys_utilities sqleRunSysCtlr Probe:12
DiagData
0000 0101 ....
2004-03-11-13.43.31.802274 Instance:db2inst1 Node:000
PID:27354(db2sysc)
2004-03-17-14.05.42.521920 Instance:db2inst1 Node:000
PID:25140(db2bp_s) Appid:
oss_2 sqlo_access_listenq Probe:1
0000 0002 ....
2004-03-17-14.08.02.402889 Instance:db2inst1 Node:000
PID:49932(db2bp_s) Appid:
oss_2 sqlo_access_listenq Probe:1
0000 0002 ....
2004-03-17-14.08.12.263178 Instance:db2inst1 Node:000
PID:90982(db2agent (FMISDB)) Appid:AC1504E9.0489.040317052528
base_sys_utilities sqledint Probe:0 Database:FMISDB
Crash Recovery is needed.
2004-03-17-14.08.14.595180 Instance:db2inst1 Node:000
PID:90982(db2agent (FMISDB)) Appid:AC1504E9.0489.040317052528
data_protection sqlpresr Probe:0 Database:FMISDB
DIA3908W Crash recovery has been initiated.
2004-03-17-14.08.14.633132 Instance:db2inst1 Node:000
PID:90982(db2agent (FMISDB)) Appid:AC1504E9.0489.040317052528
data_protection sqlpresr Probe:0 Database:FMISDB
Low transaction lsn: 0016 62f5 000c ..b?.
2004-03-17-14.08.14.723633 Instance:db2inst1 Node:000
PID:90982(db2agent (FMISDB)) Appid:AC1504E9.0489.040317052528
data_protection sqlpresr Probe:0 Database:FMISDB
Minimum buffer lsn: 0016 62f5 000c ..b?.
2004-03-17-14.08.35.898077 Instance:db2inst1 Node:000
PID:90982(db2agent (FMISDB)) Appid:AC1504E9.0489.040317052528
data_protection sqlpresr Probe:0 Database:FMISDB
DIA3909W Crash recovery completed.
几个主要参数（前几天刚调过）
dhheap 10000
catalogcache_sz 512
logbufsz 512
sortheap 512
stmtheap 2048
applheapsz 1024
app_ctl_heap_sz 1024
maxappls 200
avg_appls 20
locktimeout -1
logfilsiz 5000
logprimary 10
logsecond 20
buffpage 100000
dft_degree
locklist 1024
RS6000/M80, 2G内存, db2 V5.2
数据库目前有表大约2000个
dialog.log中的sql语句涉及的表记录数还不到10000，这个语句写的不好，但我想还不至于回把db2搞崩
请不吝赐教 |
|
免费注册
发表于 2004-03-17 17:23