SQLCODE -443, CLI -973, DIA8300C A memory heap error has occurred.

[all...@ndr.com]

DB21085I Instance "md" uses "32" bits and DB2 code release "SQL08014"
with level identifier "02050106".
Informational tokens are "DB2 v8.1.0.32", "s031027", "MI00060", and
FixPak "4". Product is installed at "/opt/IBM/db2/V8.1".

I am getting the following error output from a Java/JDBC program:
DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLCOLUMNS;COLUMNS;SYSIBM:CLI:-973

And my db2diag.log has:
2004-03-22-12.19.34.142092 Instance:md Node:000
PID:18251(db2agent (MD)) TID:8192 Appid:C0455564.DB8C.00FB7395757F
access plan manager sqlra_load_var Probe:25 Database:MD
DIA8300C A memory heap error has occurred.
ZRC=0x8B0F0044˙

The -973 tells me that I need more heap, but what KIND of heap?

Here are the current heap params for the db:
db2 get db cfg for md | grep -i heap
Database heap (4KB) (DBHEAP) = 3666
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 66079
Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 320
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) =
(SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 902
SQL statement heap (4KB) (STMTHEAP) = 2048
Default application heap (4KB) (APPLHEAPSZ) = 1024
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

And here they are for the dbm:
db2 get dbm cfg | grep -i heap
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 4096
Sort heap threshold (4KB) (SHEAPTHRES) = 23454
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128

Which one needs to be bumped up?

Any help appreciated. TIA

AJ

[PM (pm3iinc-nospam)]

0x8B0F0044 -1961951164 SQLO_NOMEM_AGSH -973

No memory avilable in 'App Group Shared

Heap'

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=INTERNAL+RETURN+CODE&uid=swg21066178&loc=en_US&cs=utf-8&lang=en+en

PM

<all...@ndr.com> a écrit dans le message de
news:405f23e0....@news.supernews.com...

[Matthew Dauphinee]

I was experiencing problems that looked to be from APAR IY50445 (
memory leak ) and was getting the same vague "memory heap error".

I would suggest getting Fixpak 5 on as soon as your environment
allows. It may just be a memory leak and your configuration could be
fine.

Matt

"PM \(pm3iinc-nospam\)" <PM(pm3iinc-nospam)@sympatico.ca> wrote in message news:<8WI7c.10891$re.7...@news20.bellglobal.com>...