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

Ric You could unload to a named pipe instead of a file and have split at the other end of the pipe to split the file into peices once it reaches 2 GB. Check out my script IDBB.sh (look for mkfifo or mknod) in the IIUG respository that does something similar. HTH Sujit Ric Stamm <stammr@email.uc.edu> on 07/28/99 05:24:14 AM Please respond to Ric Stamm <stammr@email.uc.edu> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Archive tables larger than 2GB, IDS 7.30uc5 on AIX 4.3.2 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!