Re: copying with UNIX informix tables.

abalis@ikaria.ntua.gr (Abraham-Nektarios N. Balis) writes: >I would like to ask which are the problems that may be caused if you >simply copy these tables with UNIX, for eaxmple: > > cp /usr/stores/store.dbs/* /usr2/store2/store.dbs No problem at all. The only thing you have to take care with are the 'dirpath' entries in the systables. You'll have to check if there are absolute pathnames in there and if so, correct these. Just remove the path prefix. (depending on the version you have, you might have to be user informix for this) After this, you can safely copy the files. If you want the database log to move as well, use a 'START DATABASE WITH LOG IN ...' statement. Take care with file permissions, 660 for all informix files, and they must be group informix as well. We even link table files across databases and that works fine too. Stuff like currency exchange tables and so on. -- "We convoke the Nephilim and they come {*} Stefan Posthuma, SPC Company to us, strangers with the eyes of men." | stefan@spc.nl