RE: Urgent help needed - shared memory size growing and growing

Are you using the NVL function? Last summer we encountered a problem with that particular IDS 7.3x feature. The problem was traced to the following Informix bug that was fixed in subsequent 7.3x releases. 100419 USING NVL FUNCTION ON 7.30 CAUSES 2 OR 3 SHARED MEMORY SEGMENTS TO BE DYNAMICALLY ALLOCATED, SAME QUERY WITHOUT NVL FUNCTION DOES NOT. We changed our queries to use the CASE statement in order to circumvent the problem. -----Original Message----- From: Lauri Pietarinen To: informix-list@iiug.org Sent: 2/11/00 7:47 AM Subject: Urgent help needed - shared memory size growing and growing Hello everybody! I have an urgent problem with executing a stored prosedure. The amount of shared memory for the connection is constantly increasing, as can be seen from this output. What could be the cause for this problem?? My environment is the following: Op.System: NT 4.0 Database : Informix Dynamic Server Version 7.30.TC7 Memory usage for pool name 5: size memid 120 overhead 96 scb 2024 ostcb 9224 sqscb 528 fragman 616 osenv 5992 opentable 1016 filetable 280 hashfiletab 13600 gentcb 4200 log 1888 sqtcb 424 rdahead 152 misc 320759512 ralloc <<<<<<<<<<<<<<<<<--------------------------------- 224 ru 4680 temprec 1416 buft_buffer -- ====================================================================== Lauri Pietarinen tel +358-9-2534 4632 AtBusiness Communications Oy fax +358-9-2534 4601 Italahdenkatu 19 mob +358-50-594 2011 00210 HELSINKI mailto:lauri.pietarinen@atbusiness.com Finland http://www.atbusiness.com ======================================================================