onunload / onload question
Frank Gresham asked whether onunload/onload preserves dbspace structure when copying a database between machines on OnLine 7.22. Phillip answered it is a binary copy: the target needs dbspaces with the same names for any fragmented tables or indexes, though the main dbspace may differ. Informix version and operating system must also match.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I want to copy a database from one machine to another.
If I use the onunload/onload utilities to copy the whole database, will
they keep the structure of dbspaces which I have in the original
database ?
Or do I have to specify the tables and their dbspaces individually ?
The Informix manuals don't seem very helpful about this.
Thanks,
Frank Gresham
Sent via Deja.com http://www.deja.com/
Before you buy.
Which version of IDS are you on, Frank?
<fgresham@my-deja.com> wrote in message news:8uc27h$t1t$1@nnrp1.deja.com...
> I want to copy a database from one machine to another.
>
> If I use the onunload/onload utilities to copy the whole database, will
> they keep the structure of dbspaces which I have in the original
> database ?
> Or do I have to specify the tables and their dbspaces individually ?
>
> The Informix manuals don't seem very helpful about this.
>
> Thanks,
> Frank Gresham
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
We're using Informix Online 7.22
In article <8uc94o$bo4$1@taliesin2.netcom.net.uk>,
"Neil Truby" <ntruby@netcomuk.co.uk> wrote:
> Which version of IDS are you on, Frank?
>
> <fgresham@my-deja.com> wrote in message
news:8uc27h$t1t$1@nnrp1.deja.com...
> > I want to copy a database from one machine to another.
> >
> > If I use the onunload/onload utilities to copy the whole database,
will
> > they keep the structure of dbspaces which I have in the original
> > database ?
> > Or do I have to specify the tables and their dbspaces individually ?
> >
> > The Informix manuals don't seem very helpful about this.
> >
> > Thanks,
> > Frank Gresham
> >
>
Sent via Deja.com http://www.deja.com/
Before you buy.
well, yes and no. Onload/onunload is essentially a binary copy that does
keep the server specific structure. However, what the books don't point
out too clearly is that let's say your database in the originating machine
(server 1) was on a dbspace called server1_db1. However, you also had
tables and indexes of that database that were on server1_db2. When you do
a onload onto server 2, you have to have a dbspace called server1_db2 or
else your onload will fail. On the target machine, you can specify which
dbspace you want to put it in which doesn't necessarily have to have the
same name as it was on the originating server, but if you had fragmented
tables or indexes or whatever, then those dbspaces have to be present in
the target server or else the onload will fail. Let me know if this clears
things up.
Oh, another thing, make sure the version of Informix is the same on both
machines or else it won't happen. And the OS has to be the same too so no
going from Solaris to NT.
fgresham@my-deja.com wrote:
> I want to copy a database from one machine to another.
>
> If I use the onunload/onload utilities to copy the whole database, will
> they keep the structure of dbspaces which I have in the original
> database ?
> Or do I have to specify the tables and their dbspaces individually ?
>
> The Informix manuals don't seem very helpful about this.
>
> Thanks,
> Frank Gresham
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--
Phillip Tien
Database Administrator
Whole Foods Market, Inc.
If I ever get rich, I hope I'm not real mean to poor people, like I am now.