By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Fenced SQL PROCEDURES vs Fenced STORED PROCEDURES

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 @SF@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 @SF@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 @SF@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 @SF@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 @SF@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

P: n/a
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 @SF@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 @SF@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 @SF@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 @SF@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 @SF@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 discussion thread is closed

Replies have been disabled for this discussion.