this is part of db2 dialog, could you please help me to see if you can find anything suspicious? It almost crashed once a week, getting dizzy and headache, any help would be very very appreciated!
Thanks!
2005-09-27-13.01.30.654000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:1 Database:MYDB
Error in agent servicing application with coor_node:
0x200C81D6 : 0x0000 ..
2005-09-27-13.01.30.654001 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:2 Database:MYDB
Error in agent servicing application with coor_agent_index:
0x200C81D4 : 0x010C ..
2005-09-27-13.01.30.670000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:3 Database:MYDB
Error in agent servicing application with CLIENT PID:
0x200C81B4 : 0x32353137 7152
2005-09-27-13.01.30.670001 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:4 Database:MYDB
Error in agent servicing application with INBOUND APPLICATION ID:
0x1FE8FFB3 : 4741 3037 3032 3031 2E44 4530 432E 3033 GA070201.DE0C.03
0x1FE8FFC3 : 3833 3837 3137 3031 3330 8387170130
2005-09-27-13.01.30.670002 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:5 Database:MYDB
Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x1FE8FFD4 : 0x0001 ..
2005-09-27-13.01.30.670003 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:6 Database:MYDB
Error in agent servicing application with OUTBOUND APPLICATION ID:
2005-09-27-13.01.30.685000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:7 Database:MYDB
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2005-09-27-13.01.30.685001 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:8 Database:MYDB
Error in agent servicing application with AUTHORIZATION ID:
0x0373CEA9 : 4442 3241 444D 494E 0000 0000 0000 0000 DB2ADMIN........
0x0373CEB9 : 0000 0000 0000 0000 0000 0000 0000 00 ...............
2005-09-27-13.01.30.685002 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:9 Database:MYDB
Error in agent servicing application with PRODUCT SIGNATURE:
0x0373D078 : 0x35313038304C5153 SQL08015
2005-09-27-13.01.30.701000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
base sys utilities sqleagnt_sigsegvh Probe:10 Database:MYDB
Error in agent servicing application with APPLICATION NAME:
0x0373D04E : 0x6578652E6176616A java.exe
2005-09-27-13.01.30.935000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
DRDA Application Server sqljsSignalHandler Probe:10 Database:MYDB
DIA0505I Execution of a component signal handling function has begun.
PID:1684 TID:2204 Node:000 Title: **** DRDA ASCB ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** DRDA CMNMGR CB ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** RECEIVE BUFFER ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** SEND BUFFERS ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** CONNECTION HANDLE ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** DRDA ATTRIBUTES ****
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: **** AS UCINTERFACE ****
Dump File:c:\db2_diaglog\16842204.000
2005-09-27-13.01.30.982004 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
DRDA Application Server sqljsSignalHandler Probe:20 Database:MYDB
DIA0506I Execution of a component signal handling function is complete.
2005-09-27-13.01.30.982005 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
relation data serv sqlrr_signal_handler Probe:50 Database:MYDB
DIA0505I Execution of a component signal handling function has begun.
PID:1684 TID:2204 Node:000 Title: RDS AGENT CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLCA
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID =
0x200C7F9C : 0x1FE8FF40 @ÿè.
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgnamcsn.rdbcolid =
0x1FE8FF62 : 0x202044494C4C554E NULLID
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbcolidLen =
0x1FE8FF44 : 0x0008 ..
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
0x1FE8FF50 : 5452 4955 4D50 4820 2020 2020 2020 2020 MYDB
0x1FE8FF60 : 2020
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
0x1FE8FF74 : 5359 5353 4832 3030 2020 2020 2020 2020 SYSSH200
0x1FE8FF84 : 2020
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn =
0x1FE8FF86 : 0x31304C564C535953 SYSLVL01
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0x1FE8FF8E : 0x0004 ..
PID:1684 TID:2204 Node:000 Title: RDS UCINTFC: pStatementText =
PID:1684 TID:2204 Node:000 Title: RDS APPL CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS NESTED APPL CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS SP REGISTERS CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS TRAN CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS NESTED TRAN CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS COORD CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS NESTED CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: RDS INVOCATION CB
Dump File:c:\db2_diaglog\16842204.000
2005-09-27-13.01.31.045000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
relation data serv sqlrr_dump_ffdc Probe:20 Database:MYDB
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007ÿ
PID:1684 TID:2204 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08015
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:1684 TID:2204 Node:000 Title: SQLCA
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: CREATOR
0x71471762 : 0x202044494C4C554E NULLID
PID:1684 TID:2204 Node:000 Title: PACKAGE
0x71471780 : 0x3030324853535953 SYSSH200
PID:1684 TID:2204 Node:000 Title: CREATOR
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: PACKAGE
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: REQUEST TYPE
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: APM COMMON INFO
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: CONTEXT MCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: CONTEXT MEM CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: PACKAGE ENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: CACHED PACKAGE ENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: Recursive dump_sect
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SECTION NUMBER
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SECTION ENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SECTION CURSOR INFO
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SIBLING ENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: section stmt
PID:1684 TID:2204 Node:000 Title: section stmt
Dump File:c:\db2_diaglog\16842204.000
2005-09-27-13.01.31.107000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
relation data serv sqlrr_dump_ffdc Probe:902 Database:MYDB
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007ÿ
2005-09-27-13.01.31.107001 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
relation data serv sqlrr_dump_ffdc Probe:902 Database:MYDB
PID:1684 TID:2204 Node:000 Title: SQLE_DBCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_DBCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_AGENT_CB Pointer:
0x200C7F40 : 0x6CFAC080 €Àúl
PID:1684 TID:2204 Node:000 Title: SQLD_AGENT_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_TRAN_CB Pointer
0x200C7F48 : 0x7DFAC430 0Äú}
PID:1684 TID:2204 Node:000 Title: SQLD_TRAN_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_APP_CB Pointer
0x200C7F44 : 0x7DFAC200 .Âú}
PID:1684 TID:2204 Node:000 Title: SQLD_APP_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:1684 TID:2204 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<
PID:1684 TID:2204 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:1684 TID:2204 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<
PID:1684 TID:2204 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:1684 TID:2204 Node:000 Title: SQLD_CCB:
pool(TID)=90, obj(FID)=4, indexid(IID)=0, class=0
PID:1684 TID:2204 Node:000 Title: SQLD_CCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_CCB:
pool(TID)=92, obj(FID)=260, indexid(IID)=0, class=0
PID:1684 TID:2204 Node:000 Title: SQLD_CCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_CCB:
pool(TID)=90, obj(FID)=12, indexid(IID)=0, class=0
PID:1684 TID:2204 Node:000 Title: SQLD_CCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLD_CCB:
pool(TID)=97, obj(FID)=3, indexid(IID)=0, class=128
PID:1684 TID:2204 Node:000 Title: SQLD_CCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<
PID:1684 TID:2204 Node:000 Title: SQLI_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_APP_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_TRAN_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLP_LFPB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLP_ACB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLP_DBCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLP_TENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLP_TENTRY
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: locklist
Check c:\db2_diaglog\l12892.000 for additional data.
PID:1684 TID:2204 Node:000 Title: NLSWA:DatabaseApp
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: nlsacb
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: dbNLSAppCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: UnicodeNLSAppCB
Dump File:c:\db2_diaglog\16842204.000
2005-09-27-13.01.31.279000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
access plan manager sqlra_sqlC_dump Probe:25 Database:MYDB
Context info dumped! Check c:\db2_diaglog\a16842204.000 for additional data.
2005-09-27-13.01.31.341000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:MYDB
Private workspace info dumped! Check c:\db2_diaglog\a16842204.000 for additional data.
2005-09-27-13.01.31.373000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:MYDB
Shared workspace info dumped! Check c:\db2_diaglog\a16842204.000 for additional data.
2005-09-27-13.01.31.420000 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
access plan manager sqlra_cache_full_dump Probe:25 Database:MYDB
Package Cache info dumped! Check c:\db2_diaglog\a16842204.000 for additional data.
2005-09-27-13.01.31.420001 Instance:DB2 Node:000
PID:1684(db2syscs.exe) TID:2204 Appid:GA070201.DE0C.038387170130
relation data serv sqlrr_signal_handler Probe:20 Database:MYDB
DIA0506I Execution of a component signal handling function is complete.
PID:1684 TID:2204 Node:000 Title: SQLE_AGENTCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_DBCB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_TRAN_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_MASTER_APP_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_APP_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_COORDINATOR_CB
Dump File:c:\db2_diaglog\16842204.000
PID:1684 TID:2204 Node:000 Title: SQLE_APP_GROUP_CB
Dump File:c:\db2_diaglog\16842204.000
2005-09-27-13.51.37.343000 Instance:DB2 Node:000
PID:1020(db2dasstm.exe) TID:1120 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:1020 TID:1120 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2005-09-27-13.51.40.359000 Instance:DB2 Node:000
PID:1020(db2dasstm.exe) TID:1120 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:1020 TID:1120 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2005-09-27-13.51.40.468000 Instance:DB2 Node:000
PID:1020(db2dasstm.exe) TID:1120 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:1020 TID:1120 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2005-09-27-13.51.40.484001 Instance:DB2 Node:000
PID:1020(db2dasstm.exe) TID:1120 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:1020 TID:1120 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2005-09-27-13.52.00.085000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:1872 Appid:none
base sys utilities DB2StartMain Probe:911
ADM7513W Database manager has started.
2005-09-27-13.54.10.976000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:2752 Appid:*LOCAL.DB2.0159C7175407
base sys utilities sqledint Probe:30 Database:MYDB
Crash Recovery is needed.
2005-09-27-13.54.34.413000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:2752 Appid:*LOCAL.DB2.0159C7175407
recovery manager sqlpresr Probe:410 Database:MYDB
Crash recovery started. LowtranLSN 00000284132BBC12 MinbuffLSN 0000028411979E90
2005-09-27-13.54.34.429001 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:2752 Appid:*LOCAL.DB2.0159C7175407
recovery manager sqlprecm Probe:2000 Database:MYDB
Using parallel recovery with 5 agents 64 QSets 256 queues and 16 chunks
2005-09-27-13.54.43.163000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:1112 Appid:none
data protection sqlpgarl Probe:8150
Flushing pong page at index 4665 to disk for extent 585628.
2005-09-27-13.54.43.367000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:2752 Appid:*LOCAL.DB2.0159C7175407
recovery manager sqlprecm Probe:4000 Database:MYDB
DIA2051W Forward phase of crash recovery has completed. Next LSN is
"00000284133810D3".
2005-09-27-13.54.43.429000 Instance:DB2 Node:000
PID:1796(db2syscs.exe) TID:2752 Appid:*LOCAL.DB2.0159C7175407
recovery manager sqlpresr Probe:3170 Database:MYDB
Crash recovery completed. Next LSN is 00000284133810D3
-----Original Message-----
From: DValdez [mailto:db2udbdba-ezmlmshield-x34367833.[Email address protected]
Sent: Tue 27/09/2005 7:04 PM
To: LazyDBA Discussion
Cc:
Subject: Re: does it mean BAD SQL?
This depends on the Sql Message. Usually it points you in the correct
direction for Troubleshooting.
The 3rd Character will show you what part of the Crash was affected.
ie
sqle = Engine
sqld = Data
etc
There was a document within the help files that will detail what all those
numbers mean.
Dave Valdez
Sr. Systems Integrator/Support Engineer
Glory USA Inc.
[Email address protected]
"Yan Jiao \(Joanna\) Yang "
<db2udbdba-ezmlmshield-x60308273.[Email address protected]
09/27/2005 11:45 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
does it mean BAD SQL?
Hi,
I found one SQL log shown in db2 dialog.log file when my db2 database
(running on windows 2000 server) crashed, does this mean this SQL cause my
database crash?
Please help, thanks!
Joanna
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page