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
3  4167 
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
what is the complete message in the db2diag.log ??
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 ...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Eric Brunel |
last post by:
Hi all,
I was creating a Tkinter widget in the style of the reversed tabs below Excel
worksheets and I stepped in a serious problem: the code I made makes python
crash with a seg fault, bus...
|
by: DKM |
last post by:
Here are the source code files to a Java applet that utilizes
LiveConnect to communicate with Javascript, and the HTML file.
The thing works both in IE 6.0 and FireFox 1.4. but with some...
|
by: pratchaya |
last post by:
This is my sample error in my MySQL Log
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions...
|
by: Jim Langston |
last post by:
I understand the rule of three, that if I have a custom constructor, copy or
destructor I probably need the other 2. My class object definately has a
custom constructor and destructor, but I'm...
|
by: Mike |
last post by:
Greetings,
Having a major problem here. running version 8.2 on win2003 server.
The problem I am having is backing up a database seems to get to the
last part of the backup and then fails. This...
|
by: NG |
last post by:
Hi,
We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our
system to fixpack 13 and activated activate AIX asynchronous IO
function.
Our DB is going to crash recovery with...
|
by: Gsec |
last post by:
Hi,
Can anybody let me know how to write a infinite loop, such that the
program never crashes ?
I, guess, buffer overflow method mite help!Not sure.
Plz let me know.
-thanks and regards,
|
by: NewToCPP |
last post by:
Hi,
Why does a C/C++ programs crash?
When there is access to a null pointer or some thing like that programs
crash, but why do they crash?
Thanks.
|
by: alf |
last post by:
Hi,
is it possible that due to OS crash or mysql itself crash or some e.g.
SCSI failure to lose all the data stored in the table (let's say million
of 1KB rows). In other words what is the worst...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| | |
