RE: Informix spawning threads every 5 seconds

Are you running the IECC Server Agent? I observed similar activity when I started it on our AIX platform. If so, you may want to install and run Informix's Server Administrator (ISA) product instead. Rick Bernstein -----Original Message----- From: David Williams To: informix-list@iiug.org Sent: 6/18/00 7:26 AM Subject: Re: Informix spawning threads every 5 seconds In article <8id17o$8o$1@oak.fernuni-hagen.de>, Johnson <johnson@kudzu.fernuni-hagen.de> writes >We have Informix 7.23 UC3 running under AIX 4.2.1. Aio has been activated. >Using vmstat, I have observed that the number of runnable kernel threads jumps >from 0-1 to 19-21 every 5 seconds. This does not occur when Informix has >been stopped, so I am guessing that Informix is causing this. >Any thought as to what is going on, and what I can (should?) do about it would >be appreciated. > >Thanks. Possibly a user building several small indexes or altering several small tables. Informix can allocate several threads to index builds and small index builds can finish quickly. Informix uses a hybrid of user-space based and kernel based threading. Possibly the new kernel threads are when user sessions cause new user space threads to need another kernel thread. This is very much deep into the internals of online and a) not documented b) platform specific c) Informix version specific. Can you get stack traces from the kernel threads?? -- David Williams