onstat -u ( Active threads increasing )

Dear all, IDS 11.10.FC1X1 on Linux . onstat -u normally has < 1000 active userthreads.but today we are facing a issue where the no of threads are increasing & may be because of which the shared mem requirement is increasing hence virtual segments are added by the database after short intervals. the no of active threads reaches the maximum limit and then we get a error in online.log and no further user's get's any thread to connect. it seems that the no of sessions are not increasing but the no of user threads are not released.dont know if this is the actuall case. We found that all the threads are taken & not released by one user ie our web application user . onstat -g ses session id for that user shows session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 1791 jdb - -1 webserver 122 4956160 4858568 off tid name rstcb flags curstk status 67597 sqlexec 88e54050 Y--P--- 6016 cond wait(netnorm) 67606 scan_1.0 cc305748 Y------ 496 cond wait(await_MC1) 67607 scan_1.0 9b67e170 Y------ 496 cond wait(await_MC1) 67608 scan_1.0 9b67e988 Y------ 496 cond wait(await_MC1) 67609 scan_1.0 9b67f1a0 Y------ 496 cond wait(await_MC1) 67668 scan_1.0 8a996260 Y------ 496 cond wait(await_MC1) 67669 scan_1.0 8a995a48 Y------ 496 cond wait(await_MC1) 67670 scan_1.0 972b37d8 Y------ 496 cond wait(await_MC1) 67671 group_1. 972b3ff0 Y------ 496 cond wait(await_MC1) 67672 group_1. 972b4808 Y------ 496 cond wait(await_MC1) . . . we have restarted the web application server and also the database server but still same thing is happening again . the no of userthreads are increasing towards its threshold limit. The information that i have says there is change made in application code. no changes in database configuration either. Pls Help ,let me know what more do i have to check & what more information do i have to collect. Thanks Vikas.

The optimizer has changed its plan, perhaps? has something changed? ? did someone run update statistics recently? try running update statistics on all stored procedure (W/O using PDQ). Hope this helps. ----- Original Message ---- From: VIKAS HIVARKAR <vikashivarkar3@gmail.com> To: ids@iiug.org Sent: Thursday, April 3, 2008 5:03:24 AM Subject: onstat -u ( Active threads increasing ) [11776] Dear all, IDS 11.10.FC1X1 on Linux . onstat -u normally has < 1000 active userthreads.but today we are facing a issue where the no of threads are increasing & may be because of which the shared mem requirement is increasing hence virtual segments are added by the database after short intervals. the no of active threads reaches the maximum limit and then we get a error in online.log and no further user's get's any thread to connect. it seems that the no of sessions are not increasing but the no of user threads are not released.dont know if this is the actuall case. We found that all the threads are taken & not released by one user ie our web application user . onstat -g ses session id for that user shows session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 1791 jdb - -1 webserver 122 4956160 4858568 off tid name rstcb flags curstk status 67597 sqlexec 88e54050 Y--P--- 6016 cond wait(netnorm) 67606 scan_1.0 cc305748 Y------ 496 cond wait(await_MC1) 67607 scan_1.0 9b67e170 Y------ 496 cond wait(await_MC1) 67608 scan_1.0 9b67e988 Y------ 496 cond wait(await_MC1) 67609 scan_1.0 9b67f1a0 Y------ 496 cond wait(await_MC1) 67668 scan_1.0 8a996260 Y------ 496 cond wait(await_MC1) 67669 scan_1.0 8a995a48 Y------ 496 cond wait(await_MC1) 67670 scan_1.0 972b37d8 Y------ 496 cond wait(await_MC1) 67671 group_1. 972b3ff0 Y------ 496 cond wait(await_MC1) 67672 group_1. 972b4808 Y------ 496 cond wait(await_MC1) .. .. .. we have restarted the web application server and also the database server but still same thing is happening again . the no of userthreads are increasing towards its threshold limit. The information that i have says there is change made in application code. no changes in database configuration either. Pls Help ,let me know what more do i have to check & what more information do i have to collect. Thanks Vikas. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ________________________________________________________________________________ ____ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com

I would update statistics with PDQPRIOITY set to 0 dbaccess database - set pdqpriority 0; update statistics for procedure; = "VIKAS HIVARKAR" = <vikashivarkar3@g = mail.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect onstat -u ( Active threads = 04/03/2008 02:03 increasing ) [11776] = AM = = = Please respond to = ids@iiug.org = = = Dear all, IDS 11.10.FC1X1 on Linux . onstat -u normally has < 1000 active userthreads.but today we are facing a issue where the no of threads are increasing = & may be because of which the shared mem requirement is increasing hence virt= ual segments are added by the database after short intervals. the no of active threads reaches the maximum limit and then we get a er= ror in online.log and no further user's get's any thread to connect. it seems that the no of sessions are not increasing but the no of user threads are not released.dont know if this is the actuall case. We found that all the threads are taken & not released by one user ie o= ur web application user . onstat -g ses session id for that user shows session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 1791 jdb - -1 webserver 122 4956160 4858568 off tid name rstcb flags curstk status 67597 sqlexec 88e54050 Y--P--- 6016 cond wait(netnorm) 67606 scan_1.0 cc305748 Y------ 496 cond wait(await_MC1) 67607 scan_1.0 9b67e170 Y------ 496 cond wait(await_MC1) 67608 scan_1.0 9b67e988 Y------ 496 cond wait(await_MC1) 67609 scan_1.0 9b67f1a0 Y------ 496 cond wait(await_MC1) 67668 scan_1.0 8a996260 Y------ 496 cond wait(await_MC1) 67669 scan_1.0 8a995a48 Y------ 496 cond wait(await_MC1) 67670 scan_1.0 972b37d8 Y------ 496 cond wait(await_MC1) 67671 group_1. 972b3ff0 Y------ 496 cond wait(await_MC1) 67672 group_1. 972b4808 Y------ 496 cond wait(await_MC1) .. .. .. we have restarted the web application server and also the database serv= er but still same thing is happening again . the no of userthreads are increasing towards its threshold limit. The information that i have says there is change made in application co= de. no changes in database configuration either. Pls Help ,let me know what more do i have to check & what more informat= ion do i have to collect. Thanks Vikas. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =