Re: Upgrading to version 10 ontape question
A poster asked about platform independent ontape backups. scottishpoet said dbexport is the independent mechanism; another poster suggested table level restore in version 10. Martin Fuerderer said TLR is based on platform dependent archives, so it is platform dependent too, and recommended dbexport/dbimport, unload/load or HPL.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Thanks, I didn't think that you could but I just wanted to make sure. I
certainly would think this would be a good and useful feature. That and
platform independent backups and restores with ontape (if it makes it
slower just make it an option). (can that be done?) I read some c.d.i
on this and it looked like you needed to be careful about endianess of
the two machines and the float formats between the two machines. Is
this feature coming in a future release or is it deemed not important.
and the page size
and changes to page structures between the informix versions
and changes to logical log record structures between informix versions
and ...
and ....
dbexport is your "platform independent" backup and restore mechanism
For a platform independent backup/restore use version 10 and table level restore to restore all tables from a level 0 archive. This is platform independent. Backup/restore will always be version dependent since each new version has more features. David.
No.
Table Level Restore (TLR) is based on a normal backup/archive.
Normal backups/archives are platform dependent, therefore
TLR also is platform dependent. It is a way to extract from a
backup/archive only the data that belongs to a specific table
and put it somewhere. But this does not make it platform
independent, because the data itself is platform dependent.
To be platform independent, one of dbexport/dbimport or
unload/load or HPL is the choice.
Sorry,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
Visit one of the upcoming Infobahn events in Germany
to get up-to-date information on Informix products:
- June 20, 2006 at the IBM Forum Muenchen
- June 21, 2006 at the IBM Forum Frankfurt
- June 22, 2006 at the IBM Forum Berlin
For more please see:
http://www.ibm.com/de/events/infobahn/
informix-list-bounces@iiug.org wrote on 25.05.2006 17:24:32:
>
> For a platform independent backup/restore use version 10 and table
> level restore to restore
> all tables from a level 0 archive. This is platform independent.
>
> Backup/restore will always be version dependent since each new version
> has more features.
>
> David.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list