Table in dirty buffers
HI, How to determine which tables contribute primarily for dirty buffers ? Thanks Frank --94eb2c05c356bcc3d70535f670ac
Frank:
select dbsname, tabname, count(*) num_dirty
from systabnames AS st, systabextents AS ste, sysbufhdr AS sb
where mod( sb.lrunum, 2 ) = 1
and sb.chunk = ste.te_chunk and sb.offset >= ste.te_offset and sb.offset
<= (ste.te_offset + ste.te_size)
and ste.te_partnum = st.partnum
group by 1, 2;
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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, Jun 23, 2016 at 2:44 PM, FRANK <yunyaoqu@gmail.com> wrote:
> HI,
>
> How to determine which tables contribute primarily for dirty buffers ?
>
> Thanks
> Frank
>
> --94eb2c05c356bcc3d70535f670ac
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11448a043dec6a0535f6fbf2
Thank Art !!
Now we have lot more dirty buffers to flush in check point time(
increased Check point time: from usual fraction of a second to dozens
of seconds! ) , I need point out some major contributors and see if there
would be some unnecessary table updates could be eliminated in application
side( improvement).
Thanks
Frank
On Thu, Jun 23, 2016 at 3:23 PM, Art Kagel <art.kagel@gmail.com> wrote:
> Frank:
>
> select dbsname, tabname, count(*) num_dirty
> from systabnames AS st, systabextents AS ste, sysbufhdr AS sb
> where mod( sb.lrunum, 2 ) = 1
> and sb.chunk = ste.te_chunk and sb.offset >= ste.te_offset and sb.offset
> <= (ste.te_offset + ste.te_size)
> and ste.te_partnum = st.partnum
> group by 1, 2;>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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, Jun 23, 2016 at 2:44 PM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > HI,
> >
> > How to determine which tables contribute primarily for dirty buffers ?
> >
> > Thanks
> > Frank
> >
> > --94eb2c05c356bcc3d70535f670ac
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11448a043dec6a0535f6fbf2
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--94eb2c05c356fbd16c0535f73d74