Re: tables activity

Hi. onstat -g ppf ?? onstat -g iof ?? Just suggestion. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: janto@luzdelsur.com.pe >Reply-To: janto@luzdelsur.com.pe >To: informix-list@iiug.org >Subject: tables activity >Date: 13 May 2003 18:17:40 -0700 > >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 _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus