Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Arrow Unanswered: Application Heap size error ( SQL0954C)

    While trying to drop a table in the Partitioned environmetn , I am getting SQL0954C which is the Applciation Heapsize error. So I increased the value of applheapsz parameter to 60000 , whcih si maximum allowed.
    But still I am getting the same SQL09654C error .

    Does someone has a clue to the solution to this .

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Application Heap size error ( SQL0954C)

    As application heap size is database config. parameter, make sure you update it on all the partitions not just one. Use db2_all command or manually attach to each partition and issue the command.

    dollar

    Originally posted by m1nisha
    While trying to drop a table in the Partitioned environmetn , I am getting SQL0954C which is the Applciation Heapsize error. So I increased the value of applheapsz parameter to 60000 , whcih si maximum allowed.
    But still I am getting the same SQL09654C error .

    Does someone has a clue to the solution to this .

Posting Permissions

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