thread bp_priosweep
what exactly does this thread?
have something with LRUs priority???
Is it tunable?
$ onstat -u
IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34 --915248 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
....
5c06ad0 Y--P--D 36 informix - 44525030 0 0 0 0
19 active, 128 total, 27 maximum concurrent
$ onstat -g con
...Conditions with waiters:
cid addr name waiter waittime
769 44525030 bp_cond 65 31
$ onstat -g ath
Threads:tid tcb rstcb prty status vp-class name
...
65 7712f1d8 75c06ad0 1 cond wait bp_cond 3cpu bf_priosweep()
...
This could the the Btree Cleaner thread.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Thu, May 13, 2010 at 8:57 AM, Cesar Inacio Martins <
cesar_inacio_martins@yahoo.com.br> wrote:
> what exactly does this thread?
> have something with LRUs priority???
> Is it tunable?
>
> $ onstat -u
> IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34
> --> 915248 Kbytes
> Userthreads
> address flags sessid user tty wait tout locks nreads nwrites
> .....
> 5c06ad0 Y--P--D 36 informix - 44525030 0 0 0 0
> 19 active, 128 total, 27 maximum concurrent
>
> $ onstat -g con
> ....> Conditions with waiters:
> cid addr name waiter waittime
> 769 44525030 bp_cond 65 31
>
> $ onstat -g ath
> Threads:> tid tcb rstcb prty status vp-class name
> ....
> 65 7712f1d8 75c06ad0 1 cond wait bp_cond 3cpu bf_priosweep()
> ....
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cd2e05ce6a0ee04867d1748
The bp_briosweep thread re-evaluates your buffer pool
usage and based on the usage counts of the individual
buffers and where they are laid out in the buffer can re-assign how
buffers are accessed and stored in the bufferpool.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 05/13/2010 10:29:01 AM:
> [image removed]
>
> Re: thread bp_priosweep [20140]
>
> Art Kagel
>
> to:
>
> ids
>
> 05/13/2010 10:30 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> This could the the Btree Cleaner thread.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other
> organization with which I am associated either explicitly, implicitly, or
by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Thu, May 13, 2010 at 8:57 AM, Cesar Inacio Martins <
> cesar_inacio_martins@yahoo.com.br> wrote:
>
> > what exactly does this thread?
> > have something with LRUs priority???
> > Is it tunable?
> >
> > $ onstat -u
> > IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up
00:30:34
> > --> > 915248 Kbytes
> > Userthreads
> > address flags sessid user tty wait tout locks nreads nwrites
> > .....
> > 5c06ad0 Y--P--D 36 informix - 44525030 0 0 0 0
> > 19 active, 128 total, 27 maximum concurrent
> >
> > $ onstat -g con
> > ....> > Conditions with waiters:
> > cid addr name waiter waittime
> > 769 44525030 bp_cond 65 31
> >
> > $ onstat -g ath
> > Threads:> > tid tcb rstcb prty status vp-class name
> > ....
> > 65 7712f1d8 75c06ad0 1 cond wait bp_cond 3cpu bf_priosweep()
> > ....
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0cd2e05ce6a0ee04867d1748
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
It manages the BUFFER priority. It was introduced in 9.40 I believe...
probably not on the first fixpack.
As far as I know it's not tunable. If you're seeing some problem with it you
should contact support.
Regards
On Thu, May 13, 2010 at 1:57 PM, Cesar Inacio Martins <
cesar_inacio_martins@yahoo.com.br> wrote:
> what exactly does this thread?
> have something with LRUs priority???
> Is it tunable?
>
> $ onstat -u
> IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34
> --> 915248 Kbytes
> Userthreads
> address flags sessid user tty wait tout locks nreads nwrites
> .....
> 5c06ad0 Y--P--D 36 informix - 44525030 0 0 0 0
> 19 active, 128 total, 27 maximum concurrent
>
> $ onstat -g con
> ....> Conditions with waiters:
> cid addr name waiter waittime
> 769 44525030 bp_cond 65 31
>
> $ onstat -g ath
> Threads:> tid tcb rstcb prty status vp-class name
> ....
> 65 7712f1d8 75c06ad0 1 cond wait bp_cond 3cpu bf_priosweep()
> ....
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--0016e6d64b18c2062604868028ee
Fernando, Art , John, thank for the answers. I don't have any problem with this thread, just for curiosity. Once don't exists any word about it into the Manuals. Regards César