Restoring a dataspace

[HFS]

Hi,

I have two identical database installations in two identical machines.
Is it possible restore one dbspace from one machine to another with
ontape? I'd like to load a database to this dbspace in one machine and
then move it over to another machine afterwards.

Thank you for any help
HFS

[Martin Fuerderer]

Hi,

no, you cannot restore a backup of one dbspace from one machine
as a dbspace onto another machine to another IDS instance. As you
want to only restore a specific dbspace I assume that this is not a
critical dbspace (i.e. not root dbspace or one containing logs). As
such this would be a warm restore of that dbspace.

You can do a cold restore of a backup from one system/machine
to another system/machine. But as this is a cold restore you would
have to restore also root dbspace, etc. This in effect will overwrite
the existing IDS instance (especially all its data) on the target
machine. But if I understand it correctly, this is not what you want.

I think you have to look into export/import or unload/load methods.
There is dbexport/dbimport and High Performance Loader. Besides
there is unload/load (SQL statenments) and possibly the use of the
onunload/onload utilities (the last I'm not 100% sure in your case).
But also make sure to look at Art Kagel's utility suite! There is some
useful help for export and import of data! :)

Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland Research & Development GmbH
Chairman of the Supervisory Board: Martin Jetter
Board of Management: Dirk Wittkopp
Corporate Seat: Boeblingen, Germany
Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294

informix-l...@iiug.org wrote on 12/17/2009 09:16:12 AM:

> [image removed]
>
> Restoring a dataspace
>
> HFS
>
> to:
>
> informix-list
>
> 12/17/2009 09:20 AM
>
> Sent by:
>
> informix-l...@iiug.org

> _______________________________________________
> Informix-list mailing list
> Inform...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

[Beau Nanaz]

Warning: Shameless, self-promoting plug below. ];-)

HFS,
Martin has already given you a basic response but it begs the question:
How do you easily find out what database objects reside in that specific
dbspace?

If your version is < 10.0, use partitions.sh -D <your dbspace>
If your version is >= 10.0, use fragments.sh -D <your dbspace>

This will show you all table fragments and indexes in the specified
DBSpace and give you a clue about the required space, excluding blob
information. (Note to self: Include and option for BLOB information in
there already!)

Both of these are in the IIUG software repository. One of these
decades, I may actually get around to updating the documentation of the
package and consolidating them into one .shar file.

One thing these utilities may reveal: There may be table fragments in
this dbspace that are only part of a larger [partitioned] table. In
that case, you will see why it is not safe to simple copy a dbspace,
even if it were doable the way you wanted to.

In any case, you can see (from the output of these scripts) which tables
you need to unload to replicate on your target system.

BTW, the comments at the beginning of these scripts do warn you of a
previous requirement: FOr both scripts to run, you need:
- beautify-unl.sh

For partitions.sh. you need:
- partition-list.sh

For fragments.sh, you need:
- fragment-list.sh

<EOSP> (End of shameless plug)