Hi,

I have recently upgraded my database from db2 V8 to db2 v9 fix pack 5.
I getting following error in db2daig.log file and instance will be shutdown automatically.

Funcation: DB@ UDB, SQO Memory management, sqlomemlogpoolconditions, Probe:30
Data #2:<Preformatted>
Out of mermory failure for application heap.
Requested block size: 688 bytes
physical heap size:65536 bytes
configured heap size: 1310851072 bytes

Can anyone please help me how to fix this problem.

Reduce the heap size for the application heap from 1.3GB to something reasonable.

Thanks for quick response.

please find the configuration parameters set in server.

APPLHEAPSZ=10000(4KB)
STMTHEAPSZ=16000(KB)
APP_CTL_HEAP_SZ=1024
GROUPHEAP_RATIO=70
APPLGROUP_MEM_SZ=20000(KB)
UTIL_HEAP_SZ=10240(KB)

But what the application heap in the above, how to find the application heap in my server.

How exactly did you determine the config parameters? I am asking because you reformatted them, and maybe you have STMM running or so. Seeing the exact output of the command (including the SHOW DETAILS option) on the console/shell would be appreciated.