View Single Post

   
  #4 (permalink)  
Old 01-05-2008, 07:02 AM
steven_nospam at Yahoo! Canada
 
Posts: n/a
Default 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

Reply With Quote