big problem.

good morning. excuse me for my poor english. i have informix rapid on sco unix, some days ago, a dat file was near of 2 gb and i deleted some records and after i alter table (a decimal (3,0) to (4,0) and after another time to (3,0)) to compact the dat file. that was right. when i was doing the alter table, i saw that the filesystem was near of 98% and i pass 3 dat files of the database directory to may computer and when the alter table was made i put the dat files in the database directoy. After that one of the tables (an important table) does not work well, there are records that the query instructions not found. i have made a bcheck -y but it doesnt work well. can anybody help me. thanks a lot.

Are you saying you moved some database files out of the directories where the database thought they were, ran an alter, and then moved database files back? All while the database was online? That sounds dangerious and likely unsupported. Maybe that is not what you meant? Do you have a backup you can restore from? -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Juanito Sent: Sunday, July 20, 2008 3:36 AM To: informix-list@iiug.org Subject: big problem. good morning. excuse me for my poor english. i have informix rapid on sco unix, some days ago, a dat file was near of 2 gb and i deleted some records and after i alter table (a decimal (3,0) to (4,0) and after another time to (3,0)) to compact the dat file. that was right. when i was doing the alter table, i saw that the filesystem was near of 98% and i pass 3 dat files of the database directory to may computer and when the alter table was made i put the dat files in the database directoy. After that one of the tables (an important table) does not work well, there are records that the query instructions not found. i have made a bcheck -y but it doesnt work well. can anybody help me. thanks a lot. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================