Re: Copying an informix database with "cp" (fwd)

This is a forwarded message: Quoting Michael Segel... | From clout.chi.il.us!chinet!mikey@dsinc.UUCP Sat Jun 13 11:22:07 1992 | X-Delivered: at request of Udsinc on das13 | Message-Id: <m0lwYCW-0008LqC@chinet.chi.il.us> | Date: Sat, 13 Jun 92 08:31 CDT | From: mikey@chinet.chi.il.us (Michael Segel) | To: dave.snyder@snide.com | Subject: Re: Copying an informix database with "cp" | Newsgroups: comp.databases.informix | In-Reply-To: <9021@emory.mathcs.emory.edu> | Organization: Chinet - Public Access UNIX | Cc: | | | Dave, | | >From my news site, I cannot send out any news, so please relate the | following: | | Theoretically, you can in SE copy the database using the cp command. | | However, It is never recommended to do so. I would go as far to say | that only an idiot or someone who does not care about security or | database integrity will do so. | | First, | The systables are owned by informix, so if you just copy the | entire database, your new "database" will still be pointing to your | old one. So, you have to become user informix and edit the | systables. (Not bad if you have a small database) | | Second. | Security will be comprimised., Or rather can be comprimised. | If your new database is still pointing to your old one, and you give | a user DBA in the new one, then the user has DBA on the old Database. | (Until you change the pathnames in the systables table.) | | Third, | Support. Informix will not support nor does support a user's | database if they just copy it. | | The following above information is gained from first hand experience. | At a client site, they did copy the database. Of course because of | the size, they had to change the path names of the tables to different | parts of the disk and to different disks. | | Really, it is far easier and painless to do a DBSCHEMA, then create the | tables, and unload and load the data a table at a time. | | -Hope this info helps | | -Mikey | DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com