RE: dbspaces (data & index) usage

Surprisingly,when I run oncheck -pe on those chunks I just added, it shown all spaces been 100% occupied by indexes themself. Chunk: 27 /home/informix/databaselinks/dbs3b Used Free 1048575 1048575 0 Disk usage for Chunk 27 Start Length ------------------------------------------- --------- --------- Disk usage for Chunk 27 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 db_live:admn.k1 3 253060 db_live:admn.k0 253063 795512 Chunk: 28 /home/informix/databaselinks/dbs4b Used Free 1048575 1048575 0 Disk usage for Chunk 28 Start Length ------------------------------------------- --------- --------- ^L Disk usage for Chunk 28 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 db_live:admn.k1 3 253060 db_live:admn.k2 253063 795512 Unbelievable, how can these two indexes used up few 2 Gb in two single block ? Regards, --- "Bernstein, Rick" <rbernste@alarismed.com> wrote: > The "onstat -d" command shows how much of the chunk > has ben "allocated" > to tables. To determine "used" space, run the > "oncheck" command: > * oncheck -pt <db-name>:<table-name> -- or -- > * oncheck -pT <db-name>:<table-name> > > Your table definition contains "NEXT SIZE 1600000". > Each time that more space is needed in one of the > dbspaces, Informix will > try to allocate that much more space. Some > proportion of this value is > also used when increasing space for indexes. > > The "oncheck -pe" command can be used to list table > extents, which are > allocated within each chunk. Or you can run a query > against the > sysmaster database. > > -----Original Message----- > From: K.Hong Lee > To: informix-list@iiug.org > Sent: 6/24/00 6:23 PM > Subject: dbspaces (data & index) usage > > hi Guys, > > I have a table with > row size 196, num of columns 22 and index size 120 > (listed on the dbschema output) > > This table is fragmented to 5 dbspaces based on the > key condition. > fragment by expression > (a_col [10,10] IN (1 ,2 )) in dbs1, > (a_col [10,10] IN (3 ,4 )) in dbs2, > (a_col [10,10] IN (5 ,6 )) in dbs3, > (a_col [10,10] IN (7 ,8 )) in dbs4, > (a_col [10,10] IN (9 ,0 )) in dbs5, > remainder in dbs6 > extent size 16 next size 1600000 lock mode row; > > totally space allocated of these 5 dbspaces is about > 27 Gb > > But if I calculated now_row * (row_size + index_size > + > 4) =~ 13 Gb. Where is the rest of the space has gone > ? > > All the while there were records inserted and > deleted > from this table. > > Yesterday, dbs3 and dbs4 was almost full, so I added > two chunks which 2Gb in size to these dbspaces. The > num of row count was 39 million. > > This morning, when I did a health check on database, > I > found out that those chunk been added yesterday has > been used up. 0 free space. The number of records > still remains as 39 million. records are moving in > and > out from this table. > > I only left 100 Mb each on these dbspace. Should I > add > another two 2 Gb chunk ? But it seems like the chunk > usage is stagnant now. My initial idea was Wait and > see, but After waiting for 2 hours the remaininig > space still stand on 100 Mb even though there are > more > records been added and row size is increasing. I'm > sure when the database complaints the dbspaces is > running out of space and wreak havoc the whole app. > But before I go ahead a add chunk, I need to > understand where the the spaces gone ? > > Does the onstat -d shows the real space usage on the > database. Any related to the extend size of the > table? > > How do we know what tables/indexes are sitting on > these > dbspaces ? > > Thanks, > > > > > > __________________________________________________ > Do You Yahoo!? > Get Yahoo! Mail - Free email you can access from > anywhere! > http://mail.yahoo.com/ __________________________________________________ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/