Re: Copying an informix database with "cp"

donb@pdx.csd.mot.com (Don Bolton) writes: : In article <2213@compel.UUCP> her@compel.UUCP (Helge Egelund Rasmussen) writes: : >I want to take a copy a informix database, so that the users can get : >access to both the old and the new copy by setting DBPATH. : : >Is it ok to use cp to copy the database files to another directory, : >or does the db files contain absolute pathnames? : : I tried the above once, *ONCE*. The Info in the system table catalogs : will prevent you from being successful as I recall, sure that data is : there BUT....the database name is already defined and its a mess by then. : : >Is there a better way to copy the database? : : dbschema, unload, drop, create(using dbschema files), load : I would concur with Don. I tried the 'cp' route once, but had so many problems getting the permissions and DPATH and PATH set up that I just went ahead and used dbschema and unload/load instead. It would have saved me time in the long run if I did it that way originally. If this is one of your first experiences with Informix (like it was with mine), I would suggest you do what Don suggests. -Chris -- Christopher Edler Hewlett-Packard Company cedler@hpdmd48.boi.hp.com Boise, Idaho USA