Hi,
The pipe file is really a FIFO queue. It remains in place but does not
store any data. It merely acts as a conduit. It is a standard
inter-process communication mechanism provided by Unix Operating System.

Thanks,


-----Original Message-----
From: HARVEY SHAPIRO
[mailto:db2udbdba-ezmlmshield-x25417052.[Email address protected]
Sent: Friday, February 29, 2008 12:07 PM
To: LazyDBA Discussion
Subject: Re: db2 export using pipes (Windows ?)

Don't know how to do this in Windows.

What happens to the pipe file after you compress it? Depending on your
answer, there may be a different way to do this.

>>> "MChakravarty" <db2udbdba-ezmlmshield-x31210236.[Email address
protected] 2/29/2008 4:32:42 AM >>>
Hello All,

Is there anything simlilar to beow in windows :
mkfifo pipefile <--- creat a pipe file

db2 'export to pipefile of ixf select * from tablename' & <--- export
and
put in background !

gzip -f < pipefile > abc.gz <--- compress the file

Thanks,
Mac


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




************************************************************************
******
This e-mail is intended only for the use of the individual or entity
to which it is addressed and may contain information which is
privileged, confidential, and exempt from disclosure under applicable
law. If you are not the intended recipient, or an employee or agent
of the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error
please notify us immediately by replying to [Email address protected]
************************************************************************
******



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page