View Single Post

   
  #3 (permalink)  
Old 01-05-2008, 11:52 AM
aixdude@yahoo.com
 
Posts: n/a
Default Re: Z/OS to AIX DB2 named pipe

On Aug 17, 11:36 am, bscottberg <bscottb...@yahoo.com> wrote:
> I've been asked by one of our DBAs to look into using named pipes to
> unload a DB2 z/os database down to DB2 on AIX. Curious if anyone has
> any doc on this subject or can point me in the right direction as
> google hasn't drummed up anything for me.
>
> It looks like you can set up named pipes as devices on AIX for backing
> up, other than that they seem to be more common place for Windows.


some additonal info:

This command created the named pipe.

mknod /tmp/exp_pipe p

This starts compress reading from the named pipe and
writing to tape.

compress < /tmp/exp_pipe > /dev/rmt0

This starts the export, writing to the named pipe.
exp file=/tmp/exp_pipe

Reply With Quote