Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Unanswered: Set MAXAPPLS, PCKCACHE & APPLHEAPSZ to a relevant value

    Hello all,

    We are currently facing a problem with shortage of CLI packages. Now and then we encounter sqlcode -805 telling that a package NULLID.SYSxxxxx is missing. I have rebound the list of bind files db2cli.lst with parameter clipkg 20 and got the missing package bound. However, this is not enough since the problem remains. To my understanding config parms MAXAPPLS, PCKCACHE and APPLHEAPSZ are also important here. Today we have MAXAPPL = AUTOMATIC but it seems not to work properly so I want to set a fixed value here.
    My problem is that I do not find any way to determine max applications on the database. It would have been nice to have a High water mark for max applications like it's for max connections f.ex.

    Do somebody have any tips or ideas?

    Thank in advance & best regards / Frank N

  2. #2
    Join Date
    May 2003
    Increasing the number of packages is like trying to cure someone of a drug addiction by giving them more drugs. The solution is to make sure that transactions are closed properly in java, and/or that commits are done more frequently.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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