Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2005
    Posts
    40

    Unanswered: No memory available in the application heap

    Hi all,

    Iam using db2 8.1.4 on solaris 5.9 and iam getting the following error
    DIA8301C No memory available in the application heap.

    I have increased APPLHEAPSZ db cfg parameter and forced all the applications which are using that databse, but still iam having the same problem.

    Can anyone tell why iam still getting the same error...

    Thanks in advance......

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    General rule about application heap: double it! If problem persist: double it! Still problem: double it!

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Jan 2005
    Posts
    40
    Quote Originally Posted by grofaty
    Hi,

    General rule about application heap: double it! If problem persist: double it! Still problem: double it!

    Hope this helps,
    Grofaty
    ok onemore question, will there be any impact on the database if i increase the application heap?

    Thanks in advance.....

  4. #4
    Join Date
    Jan 2005
    Posts
    191
    When you read the documentation on configuration parameters you'll notice that some of them (eg diaglevel) have a Parameter Type of Configurable Online. If it doesn't have that magic word "online" it means a new value only takes effect after an instance bounce.

    James Campbell

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    winnersparadise,
    only make sure you have enough memory.

    Hope this helps,
    Grofaty

  6. #6
    Join Date
    Jan 2005
    Posts
    40
    Quote Originally Posted by grofaty
    winnersparadise,
    only make sure you have enough memory.

    Hope this helps,
    Grofaty
    Thanks Grofaty & jacampbell.......

Posting Permissions

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