Re: Copying over .dat and .idx files in SE 4

Herschel Chandler wrote } } [parts of scenario description snipped] } }Create the tables as I want them on a test/lab machine. }Take the 'live' server down (stop all sqlexecs and database accesses). }Remove table__123.dat and table__123.idx. }Copy in the new tables with the same filenames. }Reboot the machine. (Could possibly restart the server app, but reboot }is easier to do from remote). Run bcheck against the new tables. Why not bcheck the files -before- copying over; and drive instead an 'update statistics ...' at the local engine. }I've done some testing offline and it _appears_ to work. But I wanted }to get some other opinions on this. Is copying over tables an accepted }practice with Informix SE? Has anyone done something like this? } }This is one of those -- "It REALLY needs to get done and you have three }days to figure out how to do it safely without interupting operations" }scenarios. I have to make a call soon -- just how risky is this? Low risk - if your copying is reliable :-) and you can avoid new connections during the copy. It's has one major advantage for SE too: your new table comes unfragmented to disk. -- Chris Drauch <cdr@xteam.co.at> ... just speaking for myself ...