09-05-2011
There is more relative value in tools that import than those that export. If you select delimited text you might find it easy to compress on the fly, reducing latency/end-to-end time. Not sure if dbexport would write a named pipe, with the gzip on the other side. Maybe use ksh/bash '>(...)' to make the named pipes on the fly. No sense writing the uncompressed data to disk!
You could use 'parallel' to get N parallel runs. A more primitive shell trick is to have a process writing table names to a pipe feeding to parens in which there are 4 background subshells reading names using 'line' one at a time and export/gzipping them. Send the names in biggest first. The biggest may take more time than all others!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have my log files in /home/user1/temp2/logs i want to archive
*.log and *.txt files and to store in my /home/user1/temp2/archved/
with *.log with Time stamp ,Please let me know how to do this? (1 Reply)
Discussion started by: redlotus72
1 Replies
2. Shell Programming and Scripting
Hi gurus,
I have a batch job running daily night automatically. The job produces file with extension '.0' like a.0, b.0 etc.
Now due to file space constraints, most of the time, the job fails with insufficient disk space and then we have to manually start the job again and keep running the... (1 Reply)
Discussion started by: super_duper_guy
1 Replies
3. Shell Programming and Scripting
Hi Friends,
Can anyone help me out with compressing multiple files.
I have multiple files in directory , I have to compress these into a single file,
I tried using
gzip -r outfile.gz file1 file2 file3.
It is not working
Thanks in advance for your help
S :) (5 Replies)
Discussion started by: sbasetty
5 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I would like to archive some of the scripts below(USFINUM042006_01.CSV
USFINUM042006_02.CSV and USFINUM042006_03.CSV )and also use a wildcard e.g. <command> USFINUM*.CSV. Also there are a lot of similar files but I want only the three latest files to be compressed. Which is the best... (3 Replies)
Discussion started by: indira
3 Replies
5. Filesystems, Disks and Memory
Hello,
I am having difficulty compressing the files using compress or GZIP utility on NAS share NFS mounted on my linux server. Any one have idea on how to do this ? I get the followign error but the trying to compress the files
STRP2> compress STR_OUTBOUND_CDM_LOG_LOB.PRT2008_26.txt... (0 Replies)
Discussion started by: kamathg
0 Replies
6. Shell Programming and Scripting
Could someone give me an idea how to compress all files from a given directory that are not of type .z (compressed). Please help. (2 Replies)
Discussion started by: lesstjm
2 Replies
7. UNIX for Dummies Questions & Answers
Could someone please help?
I'm trying to compress all the files in a directory without extension. I know for typical files with extension, the command is something like:
tar -zcvf file.tar.gz *.doc
What is the command for files without extension? Thanks. (4 Replies)
Discussion started by: AChan1118
4 Replies
8. UNIX for Dummies Questions & Answers
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
9. Shell Programming and Scripting
Hi ALL,
I am working on a folder where there are lot of files for the past one year. I need to compress a particular month files alone. suppose i need to compress the feb month files alone, what is the script we can use.
Thanks in advance (2 Replies)
Discussion started by: acronis.84
2 Replies
10. HP-UX
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... (1 Reply)
Discussion started by: fella
1 Replies
pipe(2) System Calls Manual pipe(2)
Name
pipe - create an interprocess channel
Syntax
include <limits.h> /*Definition of PIPE_MAX*/
pipe(fildes)
int fildes[2];
Arguments
fildes Passing an address as an array of two integers into the system call.
Description
The system call creates an I/O mechanism called a pipe. The file descriptors returned can be used in and operations. Their integer values
will be the two lowest available at the time of the function call. The O_NONBLOCK and FD_CLOEXEC flags will be clear on both file descrip-
tors.
When the pipe is written using the descriptor fildes[1], up to PIPE_MAX bytes of data are buffered before the writing process is suspended.
A read using the descriptor fildes[0] picks up the data.
It is assumed that after the pipe has been set up, two (or more) cooperating processes (created by subsequent calls) pass data through the
pipe with and calls.
The shell has a syntax to set up a linear array of processes connected by pipes.
For further information on how and calls behave with pipes, see the and reference pages.
A signal is generated if a write on a pipe with only one end is attempted.
Restrictions
Should more than 4096 bytes be necessary in any pipe among a loop of processes, deadlock may occur.
The underlying implementation of pipes is no longer socket based, but rather implemented through the file system. Any application that
needs socket functionality from pipes should use the system call.
Return Values
The function value zero is returned if the pipe was created; -1 if an error occurred.
Diagnostics
The call fails if:
[EMFILE] Too many descriptors are active.
[ENFILE] The system file table is full.
[EFAULT] The fildes buffer is in an invalid area of the process's address space.
Environment
Differs from the System V definition in that ENFILE is not a possible error condition.
See Also
sh(1), fork(2), read(2), socketpair(2), write(2)
pipe(2)