ontape/ondatartr restores -Reply

>>> <ntruby@netcomuk.co.uk> 11/01/96 11:49am wrote:>>> >It's well known that OnLine demands that a restore requires the original chunks to be >available, or at least the same symbolic links. > >But why is this? I can't understand why, since the physical location of pages is >unimportant. The important thing is the relative address of each page wrt the start of >its dbspace. > >Other DBMSs, e.g. Adabas, work entirely on relative address blocks >(pages). This makes transfer of data between servers, or between prod and dev on the same >server, much easier. > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK ========= But 'restore' and 'transfer' are two different concepts, and INFORMIX has different utilities for each. To do a table or database transfer, that is relatively FAST, try the onunload/onload combination (See Chapters 34 and 40 on the 7.1 Admin Guide for details). These utilities move the data in binary, page-sized units, and do not care about physical location. The OnTape/OnArchive utilities are meant to put your system back the way it was before 'something amiss' occurred, or to get you started on data replication. -- Sky +-------(southwel@smtpgw.maricopa.gov)-------+- Maricopa County -+ | Schuyler L. Southwell | Attorney's Office | | Data Management Consultant | 301 W. Jefferson | | Voice: 602-506-8107 **** FAX: 602-506-3970 | Phoenix, AZ 85003 | +--------------------------------------------+-------------------+