473,289 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Fenced SQL PROCEDURES vs Fenced STORED PROCEDURES

I have question about differences in fenced sql procedures and fenced
stored procedures. Do fenced sql procedures take up an extra memory
segment when executed? Reason I ask is we have several fenced sql
procedures that have been excuting o.k. We implemented a fenced stored
procedure on a C program and when trying to execute it, we get the
"DIA3833C The system memory limit was reached."
Nov 12 '05 #1
5 4502
If you're v8, there's no such thing as a fenced SQL procedure (they all
run trusted).

Any fenced routine on unix requires an extra segment for IPC communications.

Jeff wrote:
I have question about differences in fenced sql procedures and fenced
stored procedures. Do fenced sql procedures take up an extra memory
segment when executed? Reason I ask is we have several fenced sql
procedures that have been excuting o.k. We implemented a fenced stored
procedure on a C program and when trying to execute it, we get the
"DIA3833C The system memory limit was reached."

Nov 12 '05 #2
Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<cb**********@hanover.torolab.ibm.com>...
If you're v8, there's no such thing as a fenced SQL procedure (they all
run trusted).

Any fenced routine on unix requires an extra segment for IPC communications.

Thanks Sean for your response. This environment is a version 7
environment. Looking at SYSCAT.PROCEDURES it says both the sql and
stored procedures are fenced. So do you know of any reason the sql
procedures execute successfully and the stored procedures fail with
the out of memory error?

Also, we have upgraded some of our instances to version 8 and the
syscat.procedures is still showing the sql procedures as fenced.
Should we recreate our procedures after upgrading to v8?
Nov 12 '05 #3
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.

Jeff wrote:
Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<cb**********@hanover.torolab.ibm.com>...
If you're v8, there's no such thing as a fenced SQL procedure (they all
run trusted).

Any fenced routine on unix requires an extra segment for IPC communications.


Thanks Sean for your response. This environment is a version 7
environment. Looking at SYSCAT.PROCEDURES it says both the sql and
stored procedures are fenced. So do you know of any reason the sql
procedures execute successfully and the stored procedures fail with
the out of memory error?

Also, we have upgraded some of our instances to version 8 and the
syscat.procedures is still showing the sql procedures as fenced.
Should we recreate our procedures after upgrading to v8?

Nov 12 '05 #4
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 ÿÿûö
Nov 12 '05 #5
It looks like tje bufferpool complaining that you're out of memory. This
is more likely to be caused by one of the sql statements in your stored
procedure...you probably need to track down which one to figure out
what's happening.

Jeff wrote:
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 ÿÿûö

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: M Wells | last post by:
Hi All, I'm wondering if anyone can tell me if it's possible to search for stored procedures by their contents? I tend to leave very descriptive notes in stored procedures and they're...
17
by: serge | last post by:
How can i delete all user stored procedures and all table triggers very fast in a single database? Thank you
11
by: jrefactors | last post by:
I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...
2
by: scott | last post by:
Hi, Just wondering what sort of problems and advantages people have found using stored procedures. I have an app developed in VB6 & VB.NET and our developers are starting to re-write some of the...
1
by: NG | last post by:
Hi All, I am trying to create a new db2instance using db2icrt command. It has a parameter -u FENCED USER ID. I want to use same FENCED USER ID as that of our existing DB2INSTANCES. I...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
5
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored...
45
by: John | last post by:
Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards
28
by: mooreit | last post by:
The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.