Re: 5.0 Archiving to disk > 2G

Nils Myklebust wrote: > > ecg00@hplvesv2.lvld.hp.com (Ed Gulczynski) wrote: > > :We have 4GIG dbspace instance of INFORMIX (5.07) that we want to archive to > :disk instead of tape. We can still backup to tape (8mm) but want unattended > :backups that can get stored with normal daily UX file backups. > > :Has anyone done this 1) successfully 2) unattended > > :We hit the wall at 2G because of the system max file size parameter > :(HP870/200 running UX9.04.) > > ztools has a tool that they say will compress your data on the fly > without using temporary disk space. I haven't tested it, but may be > that can help you out for some time. > > Check out http://www.ztools.com > > Nils.Myklebust@ccmail.telemax.no > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > My opinions are those of my company 2G file size is a "wall". We have 10 GB data, including compressed images. No matter what kind of compression algorithms anyone can offer, there is no way to compress 10G compressed images down to 2GB. However, Informix developers should have done a better job to continue backing up the data/images/BLOBs by using a different file name. It is much easier to resolve this issue from Informix side.