Re: Upgrading to version 10 ontape question

Posted in 2006

Topics: Backup & Restore, Third-Party Tools & Monitoring

bozon — 25 May 2006 04:45:29 -0700 — source: Usenet: comp.databases.informix

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.

↪ replying to bozon

scottishpoet — 25 May 2006 07:37:56 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to scottishpoet

david@smooth1.co.uk — 25 May 2006 08:24:32 -0700 — source: Usenet: comp.databases.informix

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.

↪ replying to david@smooth1.co.uk

Martin Fuerderer — Fri, 26 May 2006 10:25:32 +0200 — source: Usenet: comp.databases.informix

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

Glossary

ontape