Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Server Stops in Middle

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the db2diag.log file.

    Andy

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    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

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What OS is your system?

    Andy

  5. #5
    Join Date
    Jan 2009
    Posts
    153
    Windows XP Professional
    Version 2002
    Service Pack 3

    Pentium Dual core CPU
    2.52GHz,4GB RAM

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by db2girl
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •