Compress dbexport on the fly | Unix Linux Forums | HP-UX

  Go Back    


HP-UX HP-UX (Hewlett Packard UniX) is Hewlett-Packard's proprietary implementation of the Unix operating system, based on System V.

Compress dbexport on the fly

HP-UX


Tags
hpux, informix, nfs

Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 01-31-2013
fella fella is offline
Registered User
 
Join Date: Jan 2013
Last Activity: 31 January 2013, 11:22 AM EST
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Compress dbexport on the fly

Hi,

I have an old HPUX 10.20 server running Informix 7.23
I need to dump the database to get it off that hardware before it dies.
Unfortunately there is insufficient local diskspace to do so.

I have set up a linux box with sufficient disk onto which I can export the database.

Having configured an NFS link between the two, I ran
dbexport -o /remote
However, the HPUX server has NFS v2 which has a 2Gb file size limit.
Some of the tables being unloaded are over 2Gb in size so the dbexport process terminates when it reaches the first one.

Seems bundle PHNE_25234 would upgrade to NFS v3 but I cannot find it.

My only other idea on how to do this, is to compress the dbexport output on the fly before it is saved to the NFS disk, but I cannot figure out the syntax, or even if it's possible.

Does anyone know how I might achieve this?
Or if it might be possible to transfer the data on the fly another way? By ftp maybe?

Thank you for any help you can offer
Sponsored Links
    #2  
Old 01-31-2013
DGPickett DGPickett is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Last Activity: 15 October 2014, 5:08 PM EDT
Location: Southern NJ, USA (Nord)
Posts: 4,455
Thanks: 8
Thanked 546 Times in 524 Posts
Can the -t be used to redirect it to write to stdout? Then you can compress or ssh over to another host to lay down the file. I wonder if the -t output is a tar file or something like that. This page says "-s -": The dbexport and dbimport Programs Try pointing it to a named pipe from '/sbin/mknod name p'. This guy seems to have it working: http://newsgroups.derkeiler.com/Arch.../msg00193.html

The utility ontape is more versatile and fast, but not as platform independent: http://informix-zone.com/idswiki/dok...bexport_ontape

This guy talks about onbar and onunload: http://oreilly.com/catalog/unixbr/chapter/ch14.html

This guy uses unload and a named pipe: http://www.iiug.org/forums/ids/index...ames/read/1026

If you have the schema file, you can select * from each table and save the data that way for future insert/import.

There may be some JDBC tools that will help do this, like kettle and xigole jisql.

Last edited by DGPickett; 01-31-2013 at 02:40 PM..
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
compress files as they are created by a dbexport fastlane3000 Shell Programming and Scripting 1 09-05-2011 04:52 PM
The Only Way To Fly ! Neo What is on Your Mind? 8 11-06-2010 10:29 AM
Read Files on the Fly angshuman_ag Shell Programming and Scripting 2 04-08-2010 06:24 AM
Issue: Compress in unix server and FTP to windows and open the compress file using Winzip sakthifire UNIX for Dummies Questions & Answers 4 11-02-2009 08:38 AM
mv and compress on the fly simquest UNIX for Dummies Questions & Answers 1 02-22-2007 11:51 AM



All times are GMT -4. The time now is 06:19 AM.