Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<cb**********@hanover.torolab.ibm.com>...
Hi Jeff,
Yes, any v7 migrated sql stored procedures need to be passed back
through the compiler to make them threadsafe (and thus able to run trusted).
In v7 all sql sps run fenced, so they're all using the extra segment,
just like a 'normal' fenced stored proc. Do you have any details on what
statement failed in the sp (or does your sp code seem to not be getting
reached)? Anything in the diag.log might help.
Hi Sean, Don't really know the answer on what statement fail. The stored proc was one we were implementing from this ibm article.
http://www-106.ibm.com/developerwork...tein/#IDAAEIEC
The piece we tried to execute was the "call truncate". Here is part ot
the diaglog.
2004-06-22-10.03.58.248050 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
oper_system_services sqlommapwrite Probe:130 Database:DMDB001
errno: 0000 000c ....
2004-06-22-10.03.58.279375 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePageToContainer Probe:30
Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.294070 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePageToContainer Probe:30
Database:DMDB001
Obj={pool:3;obj:5;type:64} State=x0 Parent={0;0}, EM=0, PP0=0 Cont=2
Offset=971
616 BlkSize=12
Data Title:SQLB_OBJECT_DESC PID:206300 Node:000
0003 0005 0000 0000 4000 0000 0000 0000 ........@.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0102 0000 0000 0000 0000 ................
0000 1000 0000 0060 0000 0004 4005 0003 .......`....@...
4053 f8dc 46aa 4030 @SøÜFª@0
2004-06-22-10.03.58.314656 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbwrpg Probe:1120 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.318076 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbwrpg Probe:1120 Database:DMDB001
Obj={pool:3;obj:5;type:64} State=x0 Parent={0;0}, EM=0, PP0=0
Data Title:SQLB_OBJECT_DESC PID:206300 Node:000
0003 0005 0000 0000 4000 0000 0000 0000 ........@.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0102 0000 0000 0000 0000 ................
0000 1000 0000 0060 0000 0004 4005 0003 .......`....@...
4053 f8dc 46aa 4030 @SøÜFª@0
2004-06-22-10.03.58.328621 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:1150 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.370663 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.375980 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.376881 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLB_PAGE
2004-06-22-10.03.58.381456 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:90 Database:DMDB001
obj = 0003 0005 0000 0000 4000 0000 0000 0000 ........@.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0102 0000 0000 0000 0000 ................
0000 1000 0000 0060 0000 0004 4005 0003 .......`....@...
4053 f8dc 46aa 4030 @SøÜFª@0
2004-06-22-10.03.58.389358 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:91 Database:DMDB001
poolPageNum = 003b 4cc0 .;LÀ
2004-06-22-10.03.58.393787 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:92 Database:DMDB001
pagePointer= 490a 5000 I.P.
2004-06-22-10.03.58.398090 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:93 Database:DMDB001
pageHeader = 0030 0fd0 0000 2328 0300 05cf f7e4 1a7a
..0.Ð..#(...Ï÷ä.z
003b 4cc0 0005 4002 4526 d8ed 0000 0000 .;LÀ..@.E&Øí....
0000 0003 0000 0000 0000 0000 0000 0000 ................
2004-06-22-10.03.58.404719 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:95 Database:DMDB001
mapInfo = 000e d360 4055 8030 0000 000c ..Ó`@U.0....
2004-06-22-10.03.58.411337 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbWritePage Probe:96 Database:DMDB001
containerID = 0000 0002 ....
2004-06-22-10.03.58.416128 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbSplatObject Probe:111 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.419942 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
buffer_pool_services sqlbSplatObject Probe:111 Database:DMDB001
Obj={pool:3;obj:5;type:64} State=x10027 Parent={3;5}, EM=3886272,
PP0=3886368
Data Title:SQLB_OBJECT_DESC PID:206300 Node:000
0003 0005 0003 0005 4000 0000 05cf f7e4 ........@....Ï÷ä
18c4 0000 1f99 a0c1 003b 4cc0 0000 0000 .Ä....*Á.;LÀ....
003b 4d20 0000 0102 0001 0027 0000 0065 .;M .......'...e
0000 1000 0000 0060 0000 0004 4005 0003 .......`....@...
4053 f8dc 46aa 4030 @SøÜFª@0
2004-06-22-10.03.58.431535 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.435376 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.436401 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
2004-06-22-10.03.58.440321 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
data_management sqldChangeLifeLSN Probe:739 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.443854 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
data_management sqldChangeLifeLSN Probe:741 Database:DMDB001
New Life should be:05cf f7e4 26b7
..Ï÷ä&·
2004-06-22-10.03.58.448080 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
data_management sqldChangeLifeLSN Probe:743 Database:DMDB001
Error changing life of object.0003 0005 0003 0005 0000 0000 05cf f7e4
....
..........Ï÷ä
18c4 0000 1f99 a0c1 003b 4cc0 0000 0000 .Ä....*Á.;LÀ....
003b 4d20 0000 0102 0001 0027 0000 0065 .;M .......'...e
0000 1000 0000 0060 0000 0004 0005 0003 .......`........
4053 f8dc 46aa 4030 @SøÜFª@0
2004-06-22-10.03.58.458221 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.462066 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.463605 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
2004-06-22-10.03.58.467199 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrltt0 Probe:10 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
Data Title:SQLRLTT0 10: file token PID:206300 Node:000
0005 ..
Data Title:SQLRLTT0 10: table token PID:206300 Node:000
0003 ..
2004-06-22-10.03.58.475809 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
global_services sqlzerdm Probe:40 Database:DMDB001
ffff f624 ÿÿö$
2004-06-22-10.03.58.482725 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.486659 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.487612 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
2004-06-22-10.03.58.491164 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DMDB001
DIA3833C The system memory limit was reached.
2004-06-22-10.03.58.492249 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:DMDB001
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF624".
Data Title:SQLCA PID:206300 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2
sqlerrmc: 36
sqlerrp : sqlrltt€
sqlerrd : (1) 0xFFFFF624 (2) 0x00000024 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLCA
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:DB2RA
Data Title:CREATOR PID:206300 Node:000
4e55 4c4c 4944 2020 NULLID
Data Title:PACKAGE PID:206300 Node:000
5351 4c55 4344 3039 SQLUCD09
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:CREATOR
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:REQUEST TYPE
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:RDS AGENT CB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:RDS APPL CB
2004-06-22-10.03.58.510368 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:DMDB001
DIA3833C The system memory limit was reached.
ZRC=0xFFFFF624
2004-06-22-10.03.58.513858 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:DMDB001
2004-06-22-10.03.58.518465 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.523351 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.524384 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLE_DBCB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_DBCB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_AGENT_CB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_TRAN_CB
Data Title:SQLD_AGENT_CB Pointer: PID:206300 Node:000
2026 3358 &3X
Data Title:SQLD_AGENT_CB PID:206300 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 1000 2027 a2d8 ............ '¢Ø
0000 1000 2027 7358 0000 0000 0000 0000 .... 'sX........
0000 0000 0000 0000 0000 8000 202d b368 ............ -³h
0000 1000 2027 8368 0000 0000 0000 0000 .... '.h........
Data Title:SQLD_TRAN_CB Pointer PID:206300 Node:000
a000 80e0 *..à
Data Title:SQLD_TRAN_CB PID:206300 Node:000
5cb5 0060 0000 0001 0000 0000 0000 0000 \µ.`............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0003 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 a000 8c40 a000 8f60 0000 0003 ....*..@*..`....
0000 0003 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0003 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:206300 Node:000
OPEN PERM CURSORS: >>
String Title:<< End CURSOR dump: PID:206300 Node:000
OPEN PERM CURSORS: <<
String Title:>> Begin CURSOR dump: PID:206300 Node:000
OPEN TEMP CURSORS: >>
String Title:<< End CURSOR dump: PID:206300 Node:000
OPEN TEMP CURSORS: <<
String Title:>> Begin CURSOR dump: PID:206300 Node:000
CLOSED CURSORS: >>
String Title:SQLD_CCB: PID:206300 Node:000
pool(TID)=0, obj(FID)=2, indexid(IID)=0, class=0
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:206300 Node:000
pool(TID)=0, obj(FID)=3, indexid(IID)=0, class=0
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_CCB
String Title:SQLD_CCB: PID:206300 Node:000
pool(TID)=0, obj(FID)=39, indexid(IID)=0, class=0
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_CCB
String Title:<< End CURSOR dump: PID:206300 Node:000
CLOSED CURSORS: <<
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_INSERT_TABLE
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_INSERT_TABLE
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLD_INSERT_TABLE
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLI_CB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLE_ACB
2004-06-22-10.03.58.583626 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
data_protection sqlpgdmp Probe:111 Database:DMDB001
Active Log Buffer is dumped to:
/db2/db2inst3/NODE0000/SQL00004/LOGBUFF.DMP
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLP_ACB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLP_DBCB
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:SQLP_TRTBL
String Title:locklist PID:206300 Node:000
Check /db2log/db2inst3/db2dump/l961532.000 for additional data.
2004-06-22-10.03.58.610930 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrrdi Probe:120 Database:DMDB001
ffff 876d ÿÿ.m
Data Title:rc_flags: PID:206300 Node:000
0400 0040 ...@
2004-06-22-10.03.58.617154 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleflsr Probe:1 Database:DMDB001
DiagData
0400 0140 ...@
2004-06-22-10.03.58.621476 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleflsr Probe:1 Database:DMDB001
RIDS/sqleflsr MS/DB_BAD_FAT PRCS/10400 0140
....@
2004-06-22-10.03.58.625921 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleflsr Probe:2 Database:DMDB001
DiagData
5351 4c43 4120 2020 0000 0088 ffff fc7a SQLCA ....ÿÿüz
0002 3336 2020 2020 2020 2020 2020 2020 ..36
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 7371 6c72 6c74 7480 sqlrltt.
ffff f624 0000 0024 0000 0000 0000 0000 ÿÿö$...$........
0000 0000 0000 0000 2020 2020 2020 2020 ........
2020 2020 2020 2020
2004-06-22-10.03.58.638015 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleflsr Probe:2 Database:DMDB001
RIDS/sqleflsr MS/DB_BAD_FAT PRCS/25351 4c43 4120 2020 0000 0088 ffff
fc7a
SQLCA ....ÿÿüz
0002 3336 2020 2020 2020 2020 2020 2020 ..36
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020
2020 2020 2020 2020 7371 6c72 6c74 7480 sqlrltt.
ffff f624 0000 0024 0000 0000 0000 0000 ÿÿö$...$........
0000 0000 0000 0000 2020 2020 2020 2020 ........
2020 2020 2020 2020
String Title:sqleMarkDBad: PID:206300 Node:000
Marking the database bad.
2004-06-22-10.03.58.654743 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:10 Database:DMDB001
DIA7107I Execution of a component signal handling function has begun.
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:APM COMMON INFO
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:PACKAGE ENTRY
Dump File:/db2log/db2inst3/db2dump/206300.000 Data:USED_IN_UOW BIT
VECTOR
2004-06-22-10.03.58.658567 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
relation_data_serv sqlrr_signal_handler Probe:20 Database:DMDB001
DIA7108I Execution of a component signal handling function is
complete.
2004-06-22-10.03.58.659531 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqleDumpAgentInfo Probe:1 Database:DMDB001
snum 36, app handle 0:257
2004-06-22-10.03.58.663252 Instance:db2inst3 Node:000
PID:206300(db2agent (DMDB001)) Appid:*LOCAL.db2inst3.040622135652
base_sys_utilities sqlesrsp Probe:9 Database:DMDB001
DiagData
ffff fbf6 ÿÿûö