Re: informix 5 tbstat -d shows negative values and ...(goes on)

utkanbir wrote: > This is related to a very old version , informix 5x. What is the x in 5.x? If it is prior to 5.10, I recommend an upgrade; 3 years ago would have been 10 months too late. > I was asked to add some dataspace to this rather old version ,but when > i went to the customer i discovered strange things: > > This is a gsm company . Their problem is lack of disk space. when i > run tbstat -d, i see 3 dbspaces rootdbs, dbs1, dbs2 and 2 > databases, db1 and db2 . I dropped some tables in db2 (which resides > in dbs2), then move a large table from dbs1 to dbs2. Basically this > solved the customers space problem until they reboot the server! > Before rebooting the server tbstat -d had proper information. After > reboot, tbstat -d had negative values for free spaces! > > More interestingly , i discovered that the customer who knows nothing > about informix , issue tbinit after the server reboots and starts > application but the server has 2 informix instance running and both of > these instances use SAME DISK AREA. They use SAME ROOTDBS ,... all the > files! I think that means they must have different server numbers. It also means that all bets are off. One server will modify something and the other won't. And what ends up recorded on disk depends on whose checkpoint occurred most recently. Chaos! Don't do it. Don't bother with debugging anything else - this is a disaster. Well, that's my immediate take on it. You're at liberty to explain why this setup will work correctly - but I really think you're on a hiding to nothing here. >[...snip...] -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/