We are using stored procedures more now in UDB and we are fooling around with the KEEPDARI parameter. It's documented in many places that you should have KEEPDARI YES to improve performance of stored procedures. After first setting KEEPDARI to yes, I set MAXDARI to 5. I quickly got the error message SQL1130N (can't start any new DARI processes). I've since changed the MAXDARI to -1, and that has allowed us to avoid the SQL1130N message. I can go under Task Manager and see 12 "db2dari" processes out there right now. Before I rebooted the machine yesterday, I had 20 "db2dari" processes out there. I don't have 12 or 20 stored procedures that are executed, there are only 3 or 4 procedures that are getting called. Even after all of the connections are forced from the database, the "db2dari" processes stay out there. What I can't figure out is what will be the maximum number of "db2dari" that will be needed?
I'm concerned about setting MAXDARI to -1 on our production machine. We average over 300+ connections to the production server, I am concerned how many dari processes I would have on the production box. Does anybody have any experience with these parms? How many "db2dari" processes do you have running? We are running Win2K. Thanks in advance. ******************* PLEASE NOTE ******************* This E-Mail/telefax message and any documents accompanying this transmission may contain privileged and/or confidential information and is intended solely for the addressee(s) named above. If you are not the intended addressee/recipient, you are hereby notified that any use of, disclosure, copying, distribution, or reliance on the contents of this E-Mail/telefax information is strictly prohibited and may result in legal action against you. Please reply to the sender advising of the error in transmission and immediately delete/destroy the message and any accompanying documents. Thank you. - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
