Re: Ontape

We tried that, no, ontape just refuses to restore to "missing" or "smaller" chunks. I think onbar also does the same behavior. A few possible thought we have in mind but yet to try is: - HPL, unload and reload - Informix also push their Enterprise Replication, which claims to be able to replicate to other machine, even at table level... Chrsi Robertson Lee NTSE (Lee.Robertson@nts.hl.siemens.de) wrote: : Hi, : Please see attached out output from onstat -d below : INFORMIX-OnLine Version 7.13.UC2 -- On-Line (Prim) -- Up 40 days : 10:27:58 -- 133184 Kbytes : Chunks : offset size free flags pathname : 0 100000 99209 PO- /ws/PRD1/root1 : 0 1000000 11650 PO- /ws/PRD1/comets1 : 0 1000000 552553 PO- /ws/PRD1/ntcdat1 : 0 1000000 999947 PO- /ws/PRD1/wiplth1 : 0 1000000 456235 PO- /ws/PRD1/ntcenh1 : 100000 100000 82447 PO- /ws/PRD1/log1 : 200000 50000 2447 PO- /ws/PRD1/phy1 : 0 50000 30975 PO- /ws/PRD1/cmtsum1 : 50000 50000 37516 PO- /ws/PRD1/wiplot1 : 0 1000000 999947 PO- /ws/PRD1/lecdat1 : 0 1000000 575379 PO- /ws/PRD1/comets2 : 0 1000000 999997 PO- /ws/PRD1/comets3 : 0 1000000 0 PO- /ws/PRD1/lecdat2 : 0 1000000 0 PO- /ws/PRD1/wiplth2 : 0 1000000 999997 PO- /ws/PRD1/wiplth3 : 0 1000000 999997 PO- /ws/PRD1/wiplth4 : 0 1000000 999997 PO- /ws/PRD1/wiplth5 : 0 1000000 999997 PO- /ws/PRD1/wiplth6 : 0 1000000 999997 PO- /ws/PRD1/wiplth7 : 0 1000000 999997 PO- /ws/PRD1/wiplth8 : 0 50000 49797 PO- /ws/PRD1/dbtemp : 0 250000 249997 PO- /ws/PRD1/dbtemp2 : What we need to do (its along story) is to restore this to a machine : with much less disk space as the one that the ontape -s came from. : As you can see the actual used space comes to about 10Gb yet more than : 30 has been allocated. : Is it possible to squeeze the data from the ontape -s (using ontape -r) : into a 10Gb area (say of 2x5Gb chunks) using offsets etc. Documentation : seems to suggest that if we archived it from a chunk of 2Gb, even if : only 2Mb was used within it, to restore it on another machine would need : a chunk of 2Gb to restore it into. Therefore the machine on which it is : to be restored needs in excess of 30Gb in free space. Am I way out here : or is this the way Informix works. : This is a particularly urgent problem so immediate replies would be : greatly appreciated. : : Regards : Lee -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: paclck@hk.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>