RE: Chunk reported full, while it shouldn't ...

Petzi wrote > > One a DB, I get error messages that the database is full. Looking at > onspaces, I notice that only 78 blocks are free (out of 950000). > What version of Informix would probably be useful. > SO what I did, for each database, I took size*nrows for each table in > each db, and I noticed that it represents only 210 MB, while the full > chunk is nearly 2GB. So we have nearly 90% overhead here, which I > consider a bit too much :) What dbspace are you storing data in. Have you got separate log and tempdbspaces ? Have you got any indexes ? Where are they stored ? > > This DB has a lot of activity (one table for instance contains more > than 6 millions entries that are updated every 24 hours). > > Could it be some stupid stuff like a transaction log that is filling > the database (DB has been up and running for 4 months) ? If yes, how > can I clear it without touching the data ? Could be temp space is filling. Try oncheck -pe to see if that gives an idea. Colin Bull c.bull@videonetworks.com sending to informix-list