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

Rob Vorbroker wrote > > 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. > Just to show someone is reading your posts Rob, I found that just by changing the compress to gzip I saved approx 20% of disk space. Exactly the same syntax. Probably need to change .Z suffixes to .gz though. (On Tru64 5.1) Colin Bull > 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 > > >