Re: Writing files over 2GB on AIX 4.3.3 Thanks dude! You know the ironic thing is that I found that same
answer...in our own knowledge base entries! Some days the brain cramps
are worse than others...
---- Knowledge Base ----
Unloading/Loading an Informix Database Larger Than 2GB
Due to file size limitations, it is sometimes a problem to try and
extract data from a database if the resulting file would be larger than
2GB in size. However, there are ways around the limitation. Below is
one example of how to accomplish this.
To Unload A Database:
Change directory into a temp filesystem where you will be unloading the
database (make sure the filesystem is created using the large file
system enabled option in AIX).
cd /tempdir
Create the dummy raw device:
mknod dbname p
Change the permission and ownership on the file to the following:
chmod 660 dbname
chown informix:informix dbname
Redirect writing to this file to a compressed file:
cat dbname | compress > dbname.Z &
Become informix and set your environment to unload the database:
su - informix
. set.{instance_name}
Issue the onunload command:
onunload -t /tempdir/dbname -b 16 -s 3000000000 dbname
To Load the Database:
Change directory into a temp filesystem where you will be uncompressing
the database (make sure the filesystem is created using the large file
system enabled option in AIX):
cd /tempdir
uncompress dbname.Z
Once uncompressed, change the permission and ownership on the file to
the following :
chmod 660 dbname
chown informix:informix dbname
Become informix, set your environment and load the database:
su - informix
. set.{instance_name}
Issue the onload command:
onload -t /tempdir/dbname -b 16 -s 30000000000 -d datadbs dbname |