My DB2 V8 SP5 WSE crash on Windows 2003 with the following msg in db2diag.log.
Any idea?
Looks like I need set stackreserver, what is the suggested value for that?
2004-03-05-12.20.46.299000 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
oper system services sqloEDUExceptionFilter Probe:55 Database:TDV8
ADM0501C A stack overflow exception has occurred. The DB2 instance has
terminated abnormally. To remedy this problem, you may increase the default
stack size for db2syscs.exe using the db2hdr utility as follows: db2hdr
\sqllib\bin\db2syscs.exe /s:<stackreserve>[,<stackcommit>] Note that increasing
the default stack size will consume virtual memory space and may reduce the
maximum number of concurrent connections. Contact IBM Support for further
assistance.
2004-03-05-12.20.46.299001 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:1 Database:TDV8
Error in agent servicing application with coor_node:
0x0364296E : 0x0000 ..
2004-03-05-12.20.46.299002 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:2 Database:TDV8
Error in agent servicing application with coor_agent_index:
0x0364296C : 0x0009 .
2004-03-05-12.20.46.299003 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:3 Database:TDV8
Error in agent servicing application with CLIENT PID:
0x0364294C : 0x38383933 3988
2004-03-05-12.20.46.314000 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:4 Database:TDV8
Error in agent servicing application with INBOUND APPLICATION ID:
0x031B3F43 : 2A4C 4F43 414C 2E44 4232 2E30 3146 3243 *LOCAL.DB2.01F2C
0x031B3F53 : 3531 3731 3930 38 5171908
2004-03-05-12.20.46.314001 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:5 Database:TDV8
Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x031B3F64 : 0x000C ..
2004-03-05-12.20.46.314002 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:6 Database:TDV8
Error in agent servicing application with OUTBOUND APPLICATION ID:
2004-03-05-12.20.46.314003 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:7 Database:TDV8
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2004-03-05-12.20.46.314004 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:8 Database:TDV8
Error in agent servicing application with AUTHORIZATION ID:
0x031D26B9 : 4442 3241 444D 494E 0000 0000 0000 0000 DB2ADMIN........
0x031D26C9 : 0000 0000 0000 0000 0000 0000 0000 00 ...............
2004-03-05-12.20.46.314005 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:9 Database:TDV8
Error in agent servicing application with PRODUCT SIGNATURE:
0x031D2888 : 0x35313038304C5153 SQL08015
2004-03-05-12.20.46.314006 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
base sys utilities sqleagnt_sigsegvh Probe:10 Database:TDV8
Error in agent servicing application with APPLICATION NAME:
0x031D285E : 6462 3262 702E 6578 65 db2bp.exe
2004-03-05-12.20.46.330000 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
DRDA Application Server sqljsSignalHandler Probe:10 Database:TDV8
DIA0505I Execution of a component signal handling function has begun.
PID:3800 TID:3864 Node:000 Title: **** DRDA ASCB ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: **** SEND BUFFERS ****
PID:3800 TID:3864 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: **** AS UCINTERFACE ****
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
2004-03-05-12.20.46.346001 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
DRDA Application Server sqljsSignalHandler Probe:20 Database:TDV8
DIA0506I Execution of a component signal handling function is complete.
2004-03-05-12.20.46.346002 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
relation data serv sqlrr_signal_handler Probe:50 Database:TDV8
DIA0505I Execution of a component signal handling function has begun.
PID:3800 TID:3864 Node:000 Title: RDS AGENT CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLCA
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID =
0x03642734 : 0x031B3ED0 Ð>..
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
0x031B3EF2 : 0x202044494C4C554E NULLID
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbcolidLen =
0x031B3ED4 : 0x0008 ..
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
0x031B3EE0 : 5444 5638 2020 2020 2020 2020 2020 2020 TDV8
0x031B3EF0 : 2020
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
0x031B3F04 : 5351 4C43 3245 3033 2020 2020 2020 2020 SQLC2E03
0x031B3F14 : 2020
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn =
0x031B3F16 : 0x52484A4141414141 AAAAAJHR
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0x031B3F1E : 0x00CB Ë.
PID:3800 TID:3864 Node:000 Title: RDS UCINTFC: pStatementText =
0x03D83860 : 494E 5345 5254 2049 4E54 4F20 4576 656E INSERT INTO Even
0x03D83870 : 7473 2820 4E4F 5445 5344 422C 204E 4F54 ts( NOTESDB, NOT
0x03D83880 : 4553 444F 4349 442C 2020 5155 4F54 4543 ESDOCID, QUOTEC
0x03D83890 : 4944 2C20 4352 4541 5445 4442 592C 2043 ID, CREATEDBY, C
0x03D838A0 : 5553 544F 4D45 5243 4944 2C20 4150 504C USTOMERCID, APPL
0x03D838B0 : 4943 4154 494F 4E43 4944 2C20 4345 5254 ICATIONCID, CERT
0x03D838C0 : 4349 442C 2050 4C41 4E43 4944 2C20 4556 CID, PLANCID, EV
0x03D838D0 : 454E 5443 4F44 452C 204B 4559 574F 5244 ENTCODE, KEYWORD
0x03D838E0 : 2C20 5354 494D 554C 5553 2C20 5072 6F63 , STIMULUS, Proc
0x03D838F0 : 6573 7365 6444 6174 6529 2056 414C 5545 essedDate) VALUE
0x03D83900 : 5320 2820 2774 6469 5F71 756F 7465 5F73 S ( 'tdi_quote_s
0x03D83910 : 7461 6765 2E6E 7366 272C 2027 3835 3235 tage.nsf', '8525
0x03D83920 : 3645 3445 3030 3533 3236 4630 3835 3235 6E4E005326F08525
0x03D83930 : 3645 3445 3030 3542 4532 4634 272C 2020 6E4E005BE2F4',
0x03D83940 : 3234 3334 2C20 2752 6963 6861 7264 2053 2434, 'Richard S
0x03D83950 : 6865 6E27 2C20 3232 3032 3935 2C20 3135 hen', 220295, 15
0x03D83960 : 3039 362C 2031 3536 3737 2C20 3239 3639 096, 15677, 2969
0x03D83970 : 312C 2027 5155 4F54 4549 4E46 4F27 2C20 1, 'QUOTEINFO',
0x03D83980 : 2727 2C20 2753 6572 7669 6365 2043 616C '', 'Service Cal
0x03D83990 : 6C2F 4578 6973 7469 6E67 2043 7573 746F l/Existing Custo
0x03D839A0 : 6D65 7227 2C20 2730 332F 3035 2F32 3030 mer', '03/05/200
0x03D839B0 : 3427 29 4')
PID:3800 TID:3864 Node:000 Title: RDS APPL CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS NESTED APPL CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS SP REGISTERS CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS TRAN CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS NESTED TRAN CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS COORD CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS NESTED CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: RDS INVOCATION CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
2004-03-05-12.20.46.361003 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
relation data serv sqlrr_dump_ffdc Probe:20 Database:TDV8
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007ÿ
PID:3800 TID:3864 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08015
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000010
(4) 0x00000BF7 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:3800 TID:3864 Node:000 Title: SQLCA
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: CREATOR
0x0411C5B2 : 0x202044494C4C554E NULLID
PID:3800 TID:3864 Node:000 Title: PACKAGE
0x0411C5D0 : 0x33304532434C5153 SQLC2E03
PID:3800 TID:3864 Node:000 Title: CREATOR
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: PACKAGE
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: REQUEST TYPE
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: APM COMMON INFO
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: CONTEXT MCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: CONTEXT MEM CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: PACKAGE ENTRY
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: CACHED PACKAGE ENTRY
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: Recursive dump_sect
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SECTION NUMBER
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SECTION ENTRY
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SIBLING ENTRY
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: section stmt
0x0A829D50 : 494E 5345 5254 2049 4E54 4F20 4576 656E INSERT INTO Even
0x0A829D60 : 7473 2820 4E4F 5445 5344 422C 204E 4F54 ts( NOTESDB, NOT
0x0A829D70 : 4553 444F 4349 442C 2020 5155 4F54 4543 ESDOCID, QUOTEC
0x0A829D80 : 4944 2C20 4352 4541 5445 4442 592C 2043 ID, CREATEDBY, C
0x0A829D90 : 5553 544F 4D45 5243 4944 2C20 4150 504C USTOMERCID, APPL
0x0A829DA0 : 4943 4154 494F 4E43 4944 2C20 4345 5254 ICATIONCID, CERT
0x0A829DB0 : 4349 442C 2050 4C41 4E43 4944 2C20 4556 CID, PLANCID, EV
0x0A829DC0 : 454E 5443 4F44 452C 204B 4559 574F 5244 ENTCODE, KEYWORD
0x0A829DD0 : 2C20 5354 494D 554C 5553 2C20 5072 6F63 , STIMULUS, Proc
0x0A829DE0 : 6573 7365 6444 6174 6529 2056 414C 5545 essedDate) VALUE
0x0A829DF0 : 5320 2820 2774 6469 5F71 756F 7465 5F73 S ( 'tdi_quote_s
0x0A829E00 : 7461 6765 2E6E 7366 272C 2027 3835 3235 tage.nsf', '8525
0x0A829E10 : 3645 3445 3030 3533 3236 4630 3835 3235 6E4E005326F08525
0x0A829E20 : 3645 3445 3030 3542 4532 4634 272C 2020 6E4E005BE2F4',
0x0A829E30 : 3234 3334 2C20 2752 6963 6861 7264 2053 2434, 'Richard S
0x0A829E40 : 6865 6E27 2C20 3232 3032 3935 2C20 3135 hen', 220295, 15
0x0A829E50 : 3039 362C 2031 3536 3737 2C20 3239 3639 096, 15677, 2969
0x0A829E60 : 312C 2027 5155 4F54 4549 4E46 4F27 2C20 1, 'QUOTEINFO',
0x0A829E70 : 2727 2C20 2753 6572 7669 6365 2043 616C '', 'Service Cal
0x0A829E80 : 6C2F 4578 6973 7469 6E67 2043 7573 746F l/Existing Custo
0x0A829E90 : 6D65 7227 2C20 2730 332F 3035 2F32 3030 mer', '03/05/200
0x0A829EA0 : 3427 29 4')
PID:3800 TID:3864 Node:000 Title: section stmt
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
2004-03-05-12.20.46.377003 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
relation data serv sqlrr_dump_ffdc Probe:902 Database:TDV8
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007ÿ
2004-03-05-12.20.46.377004 Instance:DB2 Node:000
PID:3800(db2syscs.exe) TID:3864 Appid:*LOCAL.DB2.01F2C5171908
relation data serv sqlrr_dump_ffdc Probe:902 Database:TDV8
PID:3800 TID:3864 Node:000 Title: SQLE_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLD_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLD_AGENT_CB Pointer:
0x036426D8 : 0x0A840080 ..„.
PID:3800 TID:3864 Node:000 Title: SQLD_AGENT_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLD_TRAN_CB Pointer
0x036426E0 : 0x0A83C490 .ă.
PID:3800 TID:3864 Node:000 Title: SQLD_TRAN_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLD_APP_CB Pointer
0x036426DC : 0x0A83C260 `ƒ.
PID:3800 TID:3864 Node:000 Title: SQLD_APP_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:3800 TID:3864 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<
PID:3800 TID:3864 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:3800 TID:3864 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<
PID:3800 TID:3864 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:3800 TID:3864 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=59, indexid(IID)=0, class=0
PID:3800 TID:3864 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0
PID:3800 TID:3864 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<
PID:3800 TID:3864 Node:000 Title: SQLI_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLE_APP_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLE_TRAN_CB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLP_LFPB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLP_ACB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: SQLP_TENTRY
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: locklist
Check C:\PROGRA~1\IBM\SQLLIB\DB2\l94371.000 for additional data.
PID:3800 TID:3864 Node:000 Title: NLSWA:DatabaseApp
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: NLSWA:DatabaseDatabase
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: nlsacb
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: dbNLSAppCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
PID:3800 TID:3864 Node:000 Title: UnicodeNLSAppCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\38003864.000
2004-03-05-12.21.47.720000 Instance:DB2 Node:000
PID:216(db2syscs.exe) TID:688 Appid:none
base sys utilities DB2StartMain Probe:911
ADM7513W Database manager has started.
2004-03-05-12.22.28.376000 Instance:DB2 Node:000
PID:216(db2syscs.exe) TID:2672 Appid:none
base sys utilities DB2StopMain Probe:911
ADM7514W Database manager has stopped.
2004-03-05-12.24.32.687000 Instance:DB2 Node:000
PID:1384(db2syscs.exe) TID:1388 Appid:none
base sys utilities DB2StartMain Probe:911
ADM7513W Database manager has started.
thanks.
Richard