IDS Forum

RE: ontape command

Posted By:
Date:

Hi,

no. In general you can't use ontape in the way you want to do this.

With ontape in general, you can create a copy of a server instance
(and if that contains several databases, then you will have to copy
all database, since ontape backs up and restores only instances,
not selected databases), and such a copy will be a rather exact
copy of the instance. That means especially that the physical layout
(i.e. pathnames of chunks) must be exactly the same.

There are several workarounds possible :

If you creat the chunks based on symbolic links (as is strongly
recommended), then only the link names need to be the
same, but they can point to different physical locations on disk ...

With 9.40.UC1 the ontape utility has a new "-rename" option, that
lets you rename chunk path names during the restore. With that,
you can have truly different names (not just same-name-links pointing
elsewhere).

You could check for other utilities besides dbexport/dbimport,
e.g. High Performance Loader which can be quite fast due to
parallelism ...

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions





"Lee Aholima" <lee.aholima@tcdc.govt.nz>
Sent by: forum.subscriber@iiug.org
22.04.2003 06:55


To: ids@iiug.org
cc:
Subject: RE: ontape command [970]



Hi,

Can somebody tell me if using ontape you can specify what database
server to load an archive that you have backed up using ontape?

I am assuming that the dbspaces are identical although not in the same
location of course. Is this possible? Because I am looking for a way to
copy one database from one server to another without having to use
dbimport dbexport because this is really slow.

Thanking you in advance.

Lee Aholima,
Database Administrator
Thames-Coromandel District Council
Ph 07 868 6025
Email lee.aholima@tcdc.govt.nz
Mobile 0274333915

The contents of this e-mail maybe CONFIDENTIAL OR LEGALLY PRIVILEGED, &
is intended only for the persons named above. If this e-mail is not
addressed to you, you must not use, read, distribute or copy this
document. If you have received this document by mistake, please call us
and destroy the original. Thank you.

Messages In This Thread

• RE: ontape command
  Lee Aholima -- Tuesday, 22 April 2003, at 12:55 a.m.
  • RE: ontape command
    Simmons, Keith -- Tuesday, 22 April 2003, at 4:38 a.m.
  • RE: ontape command
    Martin Fuerderer -- Tuesday, 22 April 2003, at 5:16 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.