Hi Experts,

My server IBM DB2 9.5c Express is stopping without showing any error or messages.How can i track the reason or culprit behind this? What i need to do? Is there any error log from which i can find the reason.Please Help

TIA

Look in the db2diag.log file.

Andy

Got this error

0501C A stack overflow exception has occurred. The DB2 instance
has terminated abnormally. To remedy this problem, you may increase
the default stack size for db2syscs.exe using the db2hdr utility as
follows: db2hdr \sqllib\bin\db2syscs.exe /s:<stackreserve>[,
<stackcommit>] Note that increasing the default stack size will
consume virtual memory space and may reduce the maximum number of
concurrent connections. Contact IBM Support for further assistance.

I have increased the default stack size to 1024 and then to 1536 but getting the same error.

My server is having 2GB RAM

What OS is your system?

Andy

Windows XP Professional
Version 2002
Service Pack 3

Pentium Dual core CPU
2.52GHz,4GB RAM

How many databases do you have?

What is the output of "db2 get dbm cfg"?

What is the output from "db2 get db cfg for <database>" for each database?

What are the sizes of you bufferpools on each database?

Andy

v9.5 should not crash due to stack overflow:
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

But there is a bug which can cause the instance to crash. It's fixed in fp4:
IBM - IZ33027: DB2 instance may abend due to stack overflow (instead of dumping SQL0973N) while processing a very large predicate


There is also another bug related to agent_stack_size dbm cfg:
IBM - JR29443: DBM CONFIGURATION PARAMETER AGENT_STACK_SZ IS NOT RESPECTED ON WINDOWS PLATFORM


I'd suggest to upgrade to fp4 and then monitor the system.

That is going to be kind of hard as the OP is using the free version.

Andy