Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Stmtheap, Applheapsz

    Hi,
    Can anyone tell me the best value practise to set these parameters to?
    The defaults seem to be quite low?
    Many thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I cannot give specific values to set them to, but you want to set them to the smallest value that works for your system. stmtheap is used for dynamic SQL compiling. If you have alot of dynamic SQL and it is not just basic select * from mytable stuff, then this obviously need increasing from the default. How big depends on your application. If it is too small, you will get a specific error about increasing this parameter. applheapsz is another one that depends on you application. The best way to tune this is to start at the default. If you get the error saying it is too small, increase it a little bit. Keep on doing this until the error stops.

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    general recommendation about applheapsz is: if error in db2diag.log double the size of applheapsz, if problem persists double it again.
    Hope this helps,
    Grofaty

Posting Permissions

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