Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!tut.cis.ohio-state.edu!pt.cs.cmu.edu!cadre.dsl.pitt.edu!pitt!darth!investor!rbp
From: rbp@investor.pgh.pa.us (Bob Peirce #305)
Newsgroups: comp.databases
Subject: Re: Duplicating Informix SQL Database
Keywords: Informix SQL SCO Xenix  [ugh!]
Message-ID: <1989Sep28.121400.10043@investor.pgh.pa.us>
Date: 28 Sep 89 12:14:00 GMT
References: <Sep.22.11.17.54.1989.4802@yes.rutgers.edu> <2404@infmx.UUCP>
Reply-To: rbp@investor.UUCP (Bob Peirce #305)
Organization: Cookson, Peirce & Co.
Lines: 27

In article <2404@infmx.UUCP> aland@infmx.UUCP (alan denney) writes:
>In article <Sep.22.11.17.54.1989.4802@yes.rutgers.edu> emuleomo@yes.rutgers.edu (Emuleomo) writes:
>>
>>Can anybody please tell me how I can *completely* duplicate an entire
>>Informix Sql database.???
>>
>Sounds like you had some tables which had explicit pathnames in the systables
>catalog table.  Since you copied the catalog contents along with the data
>table contents, the systables catalog still points to the same physical C-ISAM
>file (in the old database).  When you drop the table, the engine checks
>systables to locate the physical file, and away it goes!
>
>  2) check all values for systables.dirpath.  If any contain explicit full
>     pathnames, they will probably need to be changed.  (You will also need
>     to recopy those files from their given location, since they weren't in the
>     .dbs; or if they were in the same .dbs directory and they were copied to
>     your new .dbs, just strip out the pathname.)  Change carefully (as 
>     creating DBA) using regular UPDATE statement:
>       UPDATE systables set dirpath = "<full path or file basename>" 
>          WHERE tabname = "<table name>"
>
If there are more than a couple of tables in the db, it is a heck of a lot
easier to use isql to create a default form for systables and to use that
to query on and change dirpath.
-- 
Bob Peirce, Pittsburgh, PA				  412-471-5320
...!uunet!pitt!investor!rbp			rbp@investor.pgh.pa.us