RE: Online V7.11 Stored Procedure Cache

Jim - Try looking in the release notes, specifically (at least in my case), SERVERS_7.1. I believe what you are thinking about, is an environment variable that was added starting with 7.11.UC1, called DBMAXPROC which allows you to control the number of procedures in each users session cache. Jon ------------------------------ Jon C. Vemo jvemo@cyberspace.com Bothell, WA U.S.A. ---------- From: Jim Gordon[SMTP:jgordon@us.DHL.COM] Sent: Wednesday, March 27, 1996 4:43 PM To: informix-list@rmy.emory.edu Subject: Online V7.11 Stored Procedure Cache Does anyone know of a way to increase the size of the Stored Procedure Cache in V7.11? I'm sure I came across some documentation that discussed the size of the cache and how to vary it. I thought it was either an Online variable or an Environment variable. Unfortunately I cannot now remember where that documentation was and, after searching we can't find it again!! Alternatively I could be thinking of an enhancement request to create such a variable. If that is what I am thinking about does anyone know when this enhancement is scheduled? Thanks - Jim -- ------------------------------------------------------------------------ ----- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ------------------------------------------------------------------------ ----- My opinions are my own. They may vary with time but they remain mine!