IDS Forum

RE: exporting a 35G database

Posted By: Priest, Darryl - BALTO
Date: Wednesday, 26 May 2004, at 1:35 p.m.

In Response To: exporting a 35G database (KENNETH PENZA)

I had a similar problem a while back and I used HPL to unload the large
tables,
dropped them, and used dbexport to get the rest of the tables. Worked well
because
I didn't want to have to set up HPL jobs for hundreds of small tables, and
couldn't dbexport the entire database.

HTH,
-Darryl


-----Original Message-----
From: forum.subscriber@iiug.org
To: ids@iiug.org
Sent: 5/26/2004 5:39 AM
Subject: exporting a 35G database [3024]

People,

We are tring to export a 35G informix 7.30 database to importing again
on an infromix 9.4 database.
The 7.3 database resides on a NCR Unix machine that does not support
files larger then 2G (unfortunately we have 5 tables larger then this
limit). Due to incompatible tape drives fitted on the machines we cannot
perform an export to tape and import it again.

What I was thinking is as follows
create a unix pipe (mknod mypipe.1 p)

In the backgroud start a process that reads data from the pipe.
dd if=mypipe.1 | split -a 5 -b 1024m &

and start the export
dbexport -d se4rt -t mypipe.1 -s 1024000 -b 32 <<!




!

However I fear that the split and the dbexport get out of sync and make
the export process useless.

Is there a better or cleaner way to do this ?

Thanks and regards
Kenneth



____________________________________________________________________________
The information contained in this communication may be confidential, is
intended only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, or copying of
this communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please re-send this communication
to the sender and delete the original message and any copy of it from your
computer system.
Thank you.

For more information please visit us at http://www.piperrudnick.com
____________________________________________________________________________

Messages In This Thread

• exporting a 35G database
  KENNETH PENZA -- Wednesday, 26 May 2004, at 5:39 a.m.
  • Re: exporting a 35G database
    Gerd Kaluzinski -- Wednesday, 26 May 2004, at 6:56 a.m.
  • Re: exporting a 35G database
    DL Redden -- Wednesday, 26 May 2004, at 9:40 a.m.
  • RE: exporting a 35G database
    Gentsch, Sam -- Wednesday, 26 May 2004, at 11:47 a.m.
  • RE: exporting a 35G database
    Priest, Darryl - BALTO -- Wednesday, 26 May 2004, at 1:35 p.m.
  • RE: exporting a 35G database
    Alexey Sonkin -- Wednesday, 26 May 2004, at 2:05 p.m.
    • Re: RE: exporting a 35G database
      KENNETH PENZA -- Thursday, 27 May 2004, at 6:44 a.m.
      • Re: exporting a 35G database
        Gerd Kaluzinski -- Thursday, 27 May 2004, at 8:30 a.m.
      • Re: RE: exporting a 35G database
        ART KAGEL, BLOOMBERG/ 499 PARK -- Friday, 28 May 2004, at 9:03 a.m.
        • RE: exporting a 35G database
          Alexey Sonkin -- Friday, 28 May 2004, at 12:22 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.