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

Need Help, DB2 Crash with Error DIA8301C

P: n/a
Hi.
I have a sql Stored Procedure running on aix5.1, db2 udb 8.1.2
it has a temp table, but when it's done running it does not free heap
memory, here is a snapshot of db2diag.log which becomes 100% full and
all applicatin hangup:

ADM5502W The escalation of "113778" locks on table "TTT" to
lock intent "X" was successful.

2005-11-01-17.18.58.349958 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
runtime interpreter sqlri_hsjnGetTupleBlock Probe:10 Database:TP

Private virtural memory exhausted

2005-11-01-17.20.02.959229 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 725
Trying smaller size...

2005-11-01-17.20.03.199855 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 362
Trying smaller size...

2005-11-01-17.20.03.210477 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 181
Trying smaller size...

2005-11-01-17.20.03.216617 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 90
Trying smaller size...

2005-11-01-17.23.41.192924 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
data management sqldEscalateLocks Probe:3 Database:TP

ADM5502W The escalation of "113751" locks on table "TTT" to
lock intent "X" was successful.

2005-11-01-17.25.35.698165 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_mem_get_block Probe:400 Database:TP

Private Workspace Get Block Error Info
Memory Requested : 0x00000480=1152
Total Space Used : 0x000290F7=168183
Max : 0x05000000=83886080
Pool ID : 1
Heap Size : 0x06438000=105086976
Heap Max Used : 0x0E210000=237043712
Heap Cur Used : 0x038A0FB7=59379639
RC :
0x2FF155C0 : 0x8B0F0001 ....

2005-11-01-17.25.35.705549 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_mem_get_block Probe:9999 Database:TP

DIA8301C No memory available in the application heap.
ZRC=0x8B0F0001

2005-11-01-17.25.35.707640 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_copy_section Probe:200 Database:TP

DIA8301C No memory available in the application heap.
ZRC=0x8B0F0001

.... UNTIL IT's 100% FULL...

Thanks in advance
Fayez

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
fayez wrote:
Hi.
I have a sql Stored Procedure running on aix5.1, db2 udb 8.1.2
it has a temp table, but when it's done running it does not free heap
memory, here is a snapshot of db2diag.log which becomes 100% full and
all applicatin hangup:

ADM5502W The escalation of "113778" locks on table "TTT" to
lock intent "X" was successful.

2005-11-01-17.18.58.349958 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
runtime interpreter sqlri_hsjnGetTupleBlock Probe:10 Database:TP

Private virtural memory exhausted

2005-11-01-17.20.02.959229 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 725
Trying smaller size...

2005-11-01-17.20.03.199855 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 362
Trying smaller size...

2005-11-01-17.20.03.210477 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 181
Trying smaller size...

2005-11-01-17.20.03.216617 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
sort/list services sqlsAllocateSortMemory Probe:35 Database:TP

Not enough memory available for a (private) sort heap of size 90
Trying smaller size...

2005-11-01-17.23.41.192924 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
data management sqldEscalateLocks Probe:3 Database:TP

ADM5502W The escalation of "113751" locks on table "TTT" to
lock intent "X" was successful.

2005-11-01-17.25.35.698165 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_mem_get_block Probe:400 Database:TP

Private Workspace Get Block Error Info
Memory Requested : 0x00000480=1152
Total Space Used : 0x000290F7=168183
Max : 0x05000000=83886080
Pool ID : 1
Heap Size : 0x06438000=105086976
Heap Max Used : 0x0E210000=237043712
Heap Cur Used : 0x038A0FB7=59379639
RC :
0x2FF155C0 : 0x8B0F0001 ....

2005-11-01-17.25.35.705549 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_mem_get_block Probe:9999 Database:TP

DIA8301C No memory available in the application heap.
ZRC=0x8B0F0001

2005-11-01-17.25.35.707640 Instance:db2inst1 Node:000
PID:61762(db2agent (TP) 0) TID:1 Appid:*LOCAL.db2inst1.061891211626
access plan manager sqlra_sqlW_copy_section Probe:200 Database:TP

DIA8301C No memory available in the application heap.
ZRC=0x8B0F0001

... UNTIL IT's 100% FULL...


You should apply the latest fixpak and see if that solves the issue. (FP10
is up to date now.) And if that doesn't help, you should contact IBM
support as they are the only ones why can handle this in the proper way.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

P: n/a
what is the complete message in the db2diag.log ??

Nov 12 '05 #3

P: n/a
I just remember:

DIA8301C No memory available in the application heap.

Could this be ?
Increase your application heap size (double it, if that is not enough,
double it again ...) Still, usually that does not cause an instance
crash ...

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.