how release threads?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rastislav Janáč - 23 Jul 2004 14:08 GMT

dear all

we have an java application running on websphere 5 and using jdbc
connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1

there is 20 connections-user session used by appserver and reused
within connection pooling by many users
however, the number of associated threads increases from day to day,
currently more than 3000
it seems every session holds its threads even not used anymore

onstat -g ath looks like, e.g.:
98365 7000000a8df0e00 7000000ae4537a0 2 cond wait await_MC34
4cpu scan_34.0
which means scan threads waiting for condition await_MC34
onstat -g con shows, e.g.
4787 7000000ac345418 await_MC34 98372 86898

what are these threads waiting for?
how to release them?
why it is not release automatically?
what is await_MC??

thank you

regards

rasto

sending to informix-list

Reply to this Message

DNix - 27 Jul 2004 14:01 GMT

make sure when you update statistics for procedure you set pdq to
0...the stored procedures that help facilitatemay be mutltithreading
if you do not and the thread count will increase until evetually you
get an exception error which might crash the engine.

Reply to this Message

Rastislav Janáč - 30 Jul 2004 13:34 GMT

This is a multi-part message in MIME format.
--------------020301030302090906080606
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Well,

at least I have discovered what status await_MC%d in onstat -g con (or
onstat -g wai) of thread means:
"Producer thread(s) are waiting to coordinate their status with their
Master Consumer thread."
We have huge amout of scan threads with this status which increases
continuously.
May I kindly ask for some comment?

Thanks

Rasto

Rastislav Jan???? wrote:

> dear all
>
[quoted text clipped - 27 lines]
>
> sending to informix-list

--------------020301030302090906080606
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Well, 
 
at least I have discovered what status await_MC%d in onstat -g con (or
onstat -g wai) of thread means: 
"<big><big><big><big><big><big><big><big>Producer thread(s) are
waiting to coordinate their
status with their Master Consumer thread.</big></big></big></big></big></big></big></big>" 
We have huge amout of scan threads with this status which increases
continuously. 
May I kindly ask for some comment? 
 
Thanks 
 
Rasto 
 
 
Rastislav Jan???? wrote: 
<blockquote type="cite" cite="mid41010DCD.3090308@dignitas.sk">dear all
 
 
we have an java application running on websphere 5 and using jdbc
connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2,
pdqpriority=1
 
 
there is?? 20 connections-user session used by appserver and reused
within connection pooling by many users
 
however, the number of associated threads increases from day to day,
currently more than 3000
 
it seems every session holds its threads even not used anymore
 
 
onstat -g ath looks like, e.g.:
 
98365???? 7000000a8df0e00?? 7000000ae4537a0?? 2?????? cond wait?? await_MC34????
4cpu?????????????? scan_34.0
 
which means scan threads waiting for condition?? await_MC34
 
onstat -g con shows, e.g.
 
4787???????? 7000000ac345418?? await_MC34???????????????? 98372?????? 86898
 
 
what are these threads waiting for?
 
how to release them?
 
why it is not release automatically?
 
what is await_MC??
 
 
 
thank you
 
 
regards
 
 
rasto
 
 
 
 
sending to informix-list
 
 
</blockquote>
</body>
</html>

--------------020301030302090906080606--

sending to informix-list

Reply to this Message