05-18-09, 08:41 #1Registered User
- Join Date
- Jan 2009
Unanswered: Set MAXAPPLS, PCKCACHE & APPLHEAPSZ to a relevant value
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
05-18-09, 11:03 #2Registered User
- 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