Re: Hanging Sqlturbo's

On 17 May 1995, Doug McAllister wrote: } caseeval (caseeval@iaccess.za) wrote: } : Is there anyone that can shed any light on the following problem. } } : A brief explanation of what the problem is is as follows : } : The site has the problem that at seemingly random periods during } : the month, the spawned "sqlturbo" processes become "parentless" and } : then take as long as two hours to be released by the Online engine. } } : The setup on the site is as follows : } : Platform - IBM RISC 6000 (360) } : OS - AIX 3.2.5 } : Database - Informix Online 5.0 } : - Informix 4GL 4.1 (RDS) } : Users - 64 } : Other Software - Fourgen Accounting, CaseTools, etc } : Other Info - A lot of the original software is hand } : written, although all of the new stuff } : is written via the case tool. } } : In more detail, what occurs is that as each user process is started up, the } : database connection is spawned (sqlturbo). The user works within the } : relevant screen / report and then exits back to the menu. At this stage, } : both the sqlturbo and fglgo process should die. However, the sqlturbo } : continues to "live" for up to 2 hours and is an unattached process. } } : The result of all of this is that the USER limit (as in the tbconfig) of } : 120 is soon exceeded and users then have to wait until all of the "hanging" } : sqlturbo's die off by themselves. At any one stage, we can have as many } : as 118 sqlturbos existing of which 60 - 70 are "hanging". } } This problem has nothing to do with the Online configuration. It has to do } with the way that the user is exiting. Most likely the user is leaving the } app 'ungracefully' in some manner. This leaves the process hanging waiting } for the user to continue. The two hour time comes from a UNIX parameter } - keep_alive - that defaults to two hours. By changing this parameter to } something less, like 1 minute, it will at least get rid of the orphans } quicker. Then check out the app and user to see why the user exits ungracefully. } } } : Various Online engine configurations have been tried but with no success. } } : Any suggestions or possible solutions ??? } } : Michael Engelbrecht We had this problem, and it's a real pain in the but. When we upgraded to Online Dynamic Server the problem was gone. Hope it helps. Regards, Peter .-------------------------. | Peter Estabrook |___________________________________________ | User Technology Assoc. | Host : SEQUENT S2000/200 Dynix/ptx 1.4 / | 2121 Crystal Drive #103 | Fax : (703) 486-7179 / | Arlington, VA 22202 USA | Voice: (703) 486-7190 ( (-------------------------| Mail : estabroo@sea07s.navsea.navy.mil \\ (__________________________________________\\