Re: transaction table overflow?

Kim Geiger wrote: > > I need some help. The following is an error I have been getting in some of > my programs: > > SQL statement error number -229. > Could not open or create a temporary file. > SYSTEM error number -190. > ISAM err: Transaction table overflow > > What causes this overflow and what can I do to prevent it? > > Kim D. Geiger > Youth With A Mission Strategic Frontiers > e-mail address: kimgeiger@aol.com Kim, There is a variable called "TRANSACTIONS" in your onconfig file, whose value you are likely exceeding. You can check its current setting with "onstat -x". Incrementing that variable and bouncing your engine ought to prevent future nastiness. BTW, this parameter evaporates after version 7.10.UC1, as Informix has decided to allocate it and several others dynamically. HTH, Glenn Miller tsunami consulting group glenn@tsunami.com Denver, Colorado And Yea Verily the Avalanche did rumble down and smite the countryside. And it was good. And there was much rejoicing.