Re: IDS v9.3 Sun OS ontape to disk - compressing thru pipe?

I'm answering my own question...Found the answer on like the 10th or so page of postings in the CDI archives. mknod ontape_pipe p (Set TAPEDEV in onconfig file to this value) touch compressed_ontape_file.Z chmod 660 ontape_pipe chmod 660 compressed_ontape_file.Z compress < ontape_pipe > compressed_ontape_file.Z & echo '0\\n\\n' | ontape -s Took 40+ gig of used pages (based on onstat -d output) and created a 10.5 Gig compressed file. Poster was Nick Driver - kudos. Rob Vorbroker > OK I've got a development SUN box running IDS v9.3 and I've loaded 47+ > Million rows into a geo_code table for this client. No one has done > archiving before and they are in the process of getting their NetBackup > licenses for this box. In the meantime I have gotten the SA to give me > a 60GB partition (/informixdump) to which to archive to disk. Being a > firm believer in Murphy I don't want to spend 3 days reloading this > table again. > >>From what I remember (a bit foggy) on a 32 bit platform I still have >> the 2 > Gig file size problem so I want to create a pipe and run the archive > thru it compressing the files, etc. > > Can someone point me to an example in the IIUG archive that would work > (or post appropriate code for a simple American to follow). Tried IDBB > script in the IIUG Archive but it was written for v5 or v7 and I can't > get it to work for v9.3 > > Thanks in advance. > > Rob