Results 1 to 5 of 5

Thread: Sheapthres..

  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Sheapthres..

    Hi All,

    I am using DB2 V7.1 and Fixpak 5 server and oslevel as Aix5.2 . I am getting error in the db2diag.log as
    2007-08-15-17.57.20.588710 Instance:udbprd1 Node:000
    PID:69780(db2agntp (MIAMI)) Appid:0A69E41A.0955.070815153129
    sort/list_services sqlsAllocateSortMemory Probe:35 Database:MIAMI

    Not enough memory available for a (private) sort heap of size 25000
    Trying smaller size...

    so we increased the parameter sort heap threshold(SHEAPTHRES)-dbm and issued db2terminate. After executing also we faced same problem.

    Any Help....

    Many Thanks
    Meena.s

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    SHEAPTHRES is a DBM level parameter. I do not remember in V7, but you might have to stop the instance (db2stop) for a change to take effect.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You must be hitting the private memory limit at the OS level. See if increasing ulimit to 256MB helps. You can also try reducing SORTHEAP and/or APPLHEAPSZ. That, obviously, would have performance implications.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Sep 2006
    Posts
    105

    shepathres..

    Hi ,

    We have restarted the instance, and we are not getting the error now, have to check with the application team. The issue is resolved now.


    Thanks for all your support.


    Regards
    Meena.s

  5. #5
    Join Date
    Sep 2006
    Posts
    105
    Hi All,

    After restarting the instance, we are getting the error while connecting to the database.
    db2 connect to miami
    SQL0987C The application control shared memory set cannot be allocated.
    SQLSTATE=57011

    It seems like we need to reduce the parameters sortheap and Application heap size..

    Any Help...

    Thanks
    Meena.s

Posting Permissions

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