Re: how release threads?
Posted in 2004
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
>
> 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
>
--------------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, <br>
<br>
at least I have discovered what status await_MC%d in onstat -g con (or
onstat -g wai) of thread means:<br>
"<big><big><big><big><big><big><big><big><span lang="EN-US"
style="font-size: 8pt; font-family: Garamond;">Producer thread(s) arewaiting to coordinate their
status with their Master Consumer thread.</span></big></big></big></big></big></big></big></big>"<br>
We have huge amout of scan threads with this status which increases
continuously.<br>
May I kindly ask for some comment?<br>
<br>
Thanks<br>
<br>
Rasto<br>
<br>
<br>
Rastislav Janáč wrote:<br>
<blockquote type="cite" cite="mid41010DCD.3090308@dignitas.sk">dear all
<br>
<br>
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
<br>
<br>
there is 20 connections-user session used by appserver and reused
within connection pooling by many users
<br>
however, the number of associated threads increases from day to day,
currently more than 3000
<br>
it seems every session holds its threads even not used anymore
<br>
<br>
onstat -g ath looks like, e.g.:
<br>98365 7000000a8df0e00 7000000ae4537a0 2 cond wait await_MC34
4cpu scan_34.0
<br>
which means scan threads waiting for condition await_MC34
<br>
onstat -g con shows, e.g.
<br>4787 7000000ac345418 await_MC34 98372 86898
<br>
<br>
what are these threads waiting for?
<br>
how to release them?
<br>
why it is not release automatically?
<br>
what is await_MC??
<br>
<br>
<br>
thank you
<br>
<br>
regards
<br>
<br>
rasto
<br>
<br>
<br>
<br>
sending to informix-list
<br>
<br>
</blockquote>
</body>
</html>
--------------020301030302090906080606--
sending to informix-list