oninit trace to user

Hi, During peak usage, if I do a top, I see that oninit threads taking 80% of the cpu. Is there a way I can trace the oninit thread back to a user and an sql statement if applicable? The oninit thread might not be running an sql statement, but more times than not I would guess that it is. Or is there a version of the onstat command that will tell me the threads(oninit in particular) that a user is currently using? TIA. Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA jsmith112469@my-deja.com wrote: > > Hi, > > During peak usage, if I do a top, I see that oninit threads taking 80% > of the cpu. Is there a way I can trace the oninit thread back to a user > and an sql statement if applicable? The oninit thread might not be > running an sql statement, but more times than not I would guess that it > is. Or is there a version of the onstat command that will tell me the > threads(oninit in particular) that a user is currently using? > > TIA. > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.