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.

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.

man mknod
note the p parameter

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