Re: Restricting Informix Resources

You could look into Informix's product I-spy. It does allow you to govern/limit queries. ----- Original Message ----- From: Red Valsen <red_valsen@yahoo.com> To: <informix-list@iiug.org> Sent: Wednesday, August 18, 1999 9:52 AM Subject: Restricting Informix Resources > My IDS instance hangs whenever one of my feckless users runs an > abysmally coded java app with convoluted SQL statements. Informix > proceeds to grab additional 8 MB segments of virtual memory shared > memory until the instance halts with no warning in the message log > (except for usual missives about the grabs). Informix will then not > respond to anything except killing of the primary oninit daemon. > > Besides the obvious "don't do that" -- and the educational effort that > will have to be expended on this programmer (and possible application of > the Troop Alignment Tool, aka 2x4) -- how can I restrict the amount of > system resources allocated to a user thread from within Informix? Which > onconfig parameters need to be set? Is this even possible with > Informix? > > We are using IDS 7.23.UC1 on Solaris 2.5.1 on Intel w/128 MB memory. >