RE: Archive tables larger than 2GB, IDS 7.30uc5 on AIX 4.3.2

Hi Rec Did you try to compress your flat files ? Basically it looks like unloading via pipe to compress utility. You can use it with any Informix utility e.g. onunload, HPL, SQL unload. example for SQL unload. mknod comp_p p unl.sql " !/usr/contrib/bin/gzip -9 < comp_p >my_table.unl.gz & unload to comp_p select * from my_table;" Regards, Eugene Nechayev ------------- When we try to unload large tables to UNIX flat file, the process aborts with AIO error -27 (i.e., O/S file size exceeded). AIX 4.3.2 uses 64-bit addressing so there is no 2GB file size limit. We realize Informix has a 2GB file limit when archiving to tape, but not to a filesystem. High-Performance Loader also bombs when unloading to a single file in the device array. However, when unloading in parallel to several files (each remaining under 2GB), it works fine. The database supports a PeopleSoft implementation, therefore we cannot remodel the data design. Our ultimate goal is to archive the production database in order to refresh development, migration and test databases. It consists of roughly 10,000 tables, several of which are over 2GB. Basically, High-Performance Loader is out of the question since mapping flat files to table schema for a load job would be too labor intensive for a database this size. However, if someone has ideas how to automate the mapping through scripting to the onpload metadata database directly, we would appreciate some advice. We have looked at HDR (High-Availability Data Replication) as well but this is a server-level utility. We need to work at the database level in order to change table ownerships in the unload files (required by PeopleSoft for various purposes). We have also had no success with onunload, onbar, ontape, On Donner, On Blitzen, On Vixen, On Rudolph, etc. Thanks in advance for any help rendered! Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.