RE: tables activity

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