Re: tables activity
Hi Bill,
It would be appreciated if you could pl. either email to me or post that
script to group. The script developed by you to find system find hog is an
excellent.
I have been using in my day-to-day operation and maintenance. Thanks for
that.
To find out IO Stats on tables, currently I am using script as:
SELECT stn.dbsname,
stn.tabname,
DBINFO("dbspace", sti.ti_partnum) dbspace,
sti.ti_nptotal *
(
select sh_pagesize from sysshmvals
) /1024/1024 mb_total,
(pf_dskreads + pf_dskwrites) disk_io
FROM systabnames stn, systabinfo sti, sysptntab spt
WHERE sti.ti_partnum = stn.partnum
AND sti.ti_partnum = spt.partnum
AND sti.ti_nkeys = 0
AND stn.tabname not like "TBLSpace%"
AND stn.dbsname not like "HASH%"
ORDER BY disk_io DESC;
May be it might help some one else. Anyway.
Hari
"Bill Dare" <dareb@jevic.com> wrote in message
news:b9tfcq$nq0$1@terabinaries.xmission.com...
>
> If you are on a unix platform, I've got a script I run hourly to generate
> I/O statistics on tables. Let me know if you want a copy.
>
> Regards,
> Bill
>
> > -----Original Message-----
> > From: janto@luzdelsur.com.pe [SMTP:janto@luzdelsur.com.pe]
> > Sent: Tuesday, May 13, 2003 9:18 PM
> > To: informix-list@iiug.org
> > Subject: tables activity
> >
> > I'm planning to reform my database, but I need balancing tables' size
> > with tables' activity:
> >
> > Dbspaces
> > address number flags fchunk nchunks flags owner
> > name
> > c0000000318901c8 1 1 1 1 N informix
> > rootdbs
> > c000000032d15f40 2 4001 10 27 N informix
> > cliadbs
> > c00000003305a4c8 3 4001 21 14 N informix
> > clibdbs
> > c00000003305a5b0 4 2001 18 1 N T informix
> > tmp1
> > c00000003305a698 5 2001 19 1 N T informix
> > tmp2
> > 5 active, 2047 maximum
> >
> > Chunks
> > address chk/dbs offset size free bpages flags
> > pathname
> > c0000000318902b0 1 1 512 974336 362185 PO-
> > /dev/informix/clientes/chunkroot
> > c000000032d153b0 2 2 512 974336 34 PO-
> > /dev/informix/clientes/chunkA12
> > c000000032d154d8 3 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA13
> > c000000032d15600 4 3 512 974336 83 PO-
> > /dev/informix/clientes/chunkB8
> > c000000032d15728 5 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA14
> > c000000032d15850 6 2 512 974336 6 PO-
> > /dev/informix/clientes/chunkA15
> > c000000032d15978 7 3 512 974336 83 PO-
> > /dev/informix/clientes/chunkB9
> > c000000032d15aa0 8 2 512 974336 4 PO-
> > /dev/informix/clientes/chunkA16
> > c000000032d15bc8 9 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA17
> > c000000032d15cf0 10 2 512 974336 6 PO-
> > /dev/informix/clientes/chunkA1
> > c000000032d15e18 11 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA18
> > c000000033058028 12 3 512 974336 83 PO-
> > /dev/informix/clientes/chunkB10
> > c000000033058150 13 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA19
> > c000000033058278 14 3 512 974336 83 PO-
> > /dev/informix/clientes/chunkB11
> > c0000000330583a0 15 2 512 974336 1513 PO-
> > /dev/informix/clientes/chunkA20
> > c0000000330584c8 16 3 512 974336 77983 PO-
> > /dev/informix/clientes/chunkB12
> > c0000000330585f0 17 2 512 974336 46294 PO-
> > /dev/informix/clientes/chunkA21
> > c000000033058718 18 4 512 500000 380041 PO-
> > /dev/informix/clientes/chunkt1
> > c000000033058840 19 5 500512 474336 463897 PO-
> > /dev/informix/clientes/chunkt1
> > c000000033058968 20 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA22
> > c000000033058a90 21 3 512 974336 0 PO-
> > /dev/informix/clientes/chunkB1
> > c000000033058bb8 22 2 512 974336 7 PO-
> > /dev/informix/clientes/chunkA2
> > c000000033058ce0 23 2 512 974336 9 PO-
> > /dev/informix/clientes/chunkA3
> > c000000033058e08 24 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA23
> > c000000033058f30 25 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA24
> > c000000033059058 26 2 512 974336 51 PO-
> > /dev/informix/clientes/chunkA4
> > c000000033059180 27 2 512 974336 0 PO-
> > /dev/informix/clientes/chunkA25
> > c0000000330592a8 28 2 512 974336 9 PO-
> > /dev/informix/clientes/chunkA5
> > c0000000330593d0 29 2 512 974336 12 PO-
> > /dev/informix/clientes/chunkA6
> > c0000000330594f8 30 2 512 308736 0 PO-
> > /dev/informix/clientes/chunkA26
> > c000000033059620 31 2 512 974336 11 PO-
> > /dev/informix/clientes/chunkA7
> > c000000033059748 32 2 512 974336 134 PO-
> > /dev/informix/clientes/chunkA8
> > c000000033059870 33 2 512 974336 5 PO-
> > /dev/informix/clientes/chunkA9
> > c000000033059998 34 2 512 974336 60 PO-
> > /dev/informix/clientes/chunkA10
> > c000000033059ac0 35 2 512 974336 77 PO-
> > /dev/informix/clientes/chunkA11
> > c000000033059be8 36 3 512 308736 0 PO-
> > /dev/informix/clientes/chunkB13
> > c000000034106028 37 2 512 974336 874333 PO-
> > /dev/informix/clientes/chunkA27
> > c000000033059d10 38 3 512 974336 0 PO-
> > /dev/informix/clientes/chunkB2
> > c000000033059e38 39 3 512 974336 8 PO-
> > /dev/informix/clientes/chunkB3
> > c00000003305a028 40 3 512 974336 1 PO-
> > /dev/informix/clientes/chunkB4
> > c00000003305a150 41 3 512 974336 3 PO-
> > /dev/informix/clientes/chunkB5
> > c00000003305a278 42 3 512 974336 3 PO-
> > /dev/informix/clientes/chunkB6
> > c00000003305a3a0 43 3 512 974336 3 PO-
> > /dev/informix/clientes/chunkB7
> > c000000034106150 44 3 512 974336 649583 PO-
> > /dev/informix/clientes/chunkB14
> >
> >
> > How can I monitoring tables activity?
> > I'm using Informix 7.31FD3W1