Sponsored Content
Full Discussion: Compress dbexport on the fly
Operating Systems HP-UX Compress dbexport on the fly Post 302764357 by fella on Thursday 31st of January 2013 10:41:57 AM
Old 01-31-2013
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
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Rename files on the fly

Hi everyone, I am sort of new to shell scripting, I have a bunch of files that begin with 'blah' and I want to rename those files with something different (renamedFile1, renamedFile2, renamedFileN). I don't want to go through each file and rename them with the mv command. Could I just use a for... (4 Replies)
Discussion started by: kcor
4 Replies

2. UNIX for Dummies Questions & Answers

mv and compress on the fly

I want to move and compress a big export file. Like mv file_exp /filesystem/file_exp |compress The file system is too small to compress and move with 2 steps. What is the best command for me. I'm running solaris. :confused: (1 Reply)
Discussion started by: simquest
1 Replies

3. Shell Programming and Scripting

Grep logs on the fly

Hi, We use an application that is dumping logs to a file on disk. However, this is dumping very verbosely and there is no method of turning down the logging level. We need to remove certain contents from these before they are commited to disk. Has anybody got any ideas how I can do this... (3 Replies)
Discussion started by: harperonline
3 Replies

4. Solaris

Disable IPMP on the fly

Wats would be the best way to disable link based IPMP on the fly without loosing network connectivity ? (6 Replies)
Discussion started by: fugitive
6 Replies

5. UNIX for Dummies Questions & Answers

Issue: Compress in unix server and FTP to windows and open the compress file using Winzip

Hi All ! We have to compress a big data file in unix server and transfer it to windows and uncompress it using winzip in windows. I have used the utility ZIP like the below. zip -e <newfilename> df2_test_extract.dat but when I compress files greater than 4 gb using zip utility, it... (4 Replies)
Discussion started by: sakthifire
4 Replies

6. Shell Programming and Scripting

Read Files on the Fly

Hi, I am creating files in a folder on the fly with arbritrary names but same extension (say, ".img"). How can I read each filename from the folder through a script. regards Angshuman (2 Replies)
Discussion started by: angshuman_ag
2 Replies

7. What is on Your Mind?

The Only Way To Fly !

This is great! Lqh8e2KYIrU (8 Replies)
Discussion started by: Neo
8 Replies

8. Shell Programming and Scripting

compress files as they are created by a dbexport

hi, we work on an IBM machine, and we have an INFORMIX datbase, we need to make a dbexport which create a flat files according to the tables we have. we are on AIX OS using ksh 5.3 we need to make the dbexport and the compress (gzip) in the same time i tried to make a shell but i'm... (1 Reply)
Discussion started by: fastlane3000
1 Replies

9. OS X (Apple)

Creating An Executable On The Fly...

Hi all... Had an idea tonight which could really enhance shell scripting for me. Yes I am aware there could be difficulties but...... Creating a C script inside the shell script to do a task, (a simple text print to stdout in this example), compiling it on the fly, making sure it is... (4 Replies)
Discussion started by: wisecracker
4 Replies

10. Shell Programming and Scripting

Execute script on the fly

Hi all, I am calling a zsh script from batch file . This zsh just removes the trigger file in a particular directory.File name is passed as a parameter from the batch file Problem is this batch is called in multiple other batch files and sometimes system says file cant be used as it is used... (4 Replies)
Discussion started by: Hypesslearner
4 Replies
Apache::Session::Store::Informix(3pm)			User Contributed Perl Documentation		     Apache::Session::Store::Informix(3pm)

NAME
Apache::Session::Store::Informix - Store persistent data in a Informix database SYNOPSIS
use Apache::Session::Store::Informix; my $store = new Apache::Session::Store::Informix; $store->insert($ref); $store->update($ref); $store->materialize($ref); $store->remove($ref); DESCRIPTION
Apache::Session::Store::Informix fulfills the storage interface of Apache::Session. Session data is stored in a Informix database. SCHEMA
To use this module, you will need at least these columns in a table called 'sessions': id char(32) # or however long your session IDs are. a_session lvarchar To create this schema, you can execute this command using the sqlplus program: CREATE TABLE sessions ( id char(32) not null primary key, a_session lvarchar ); If you use some other command, ensure that there is a unique index on the table's id column. CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password. Example: tie %hash, 'Apache::Session::Informix', $id, { DataSource => 'dbi:Informix:database', UserName => 'database_user', Password => 'K00l' }; Instead, you may pass in an already-opened DBI handle to your database. tie %hash, 'Apache::Session::Informix', $id, { Handle => $dbh }; The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB. AUTHOR
This module was written by Mike Langen <mike.langen@tamedia.ch>, based on the original for Oracle. SEE ALSO
Apache::Session, Apache::Session::Store::DBI perl v5.10.1 2010-10-18 Apache::Session::Store::Informix(3pm)
All times are GMT -4. The time now is 10:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy