Wednesday, August 15, 2012

named pipe access module in Teradata:


named pipe access module in Teradata:



Note: To invoke Teradata access module check the access module option under perform load in load request

 
Filenames in different operating systems
AXSMOD Name Specifications for Teradata Named Pipes Access Module
Operating System Teradata Parallel Transporter Version Named Pipes Access Module

Linux Shared library file called
np_axsmod.so

UNIX HP-UX PA-RISC Shared library file called
np_axsmod.sl

HP-UX IA64 Not Available
IBM-AIX Shared object file called
np_axsmod.so

Solaris SPARC Shared object file called
np_axsmod.so

Solaris Opteron np_axsmod.so np_axsmod.so

Windows 2000/XP/2003 Dynamic link library file called
np_AXSMOD.dll

Nice link on teradta named pipe access module
http://developer.teradata.com/tools/articles/understanding-named-pipe-access-module-data-transfer




To use Teradata Named Pipes Access Module on UNIX with named pipes:
1) Use the UNIX mknod command with the p option to create a named pipe. In the following
example, /tmp/mypipe is the name of the pipe:
/sbin/mknod /tmp/mypipe p
 

2 Program the writer process to send its output stream to the named pipe, as in the
following FastExport script example:
.EXPORT OUTFILE /tmp/mypipe;
 

3 Program the reader process to read from the named pipe as in the following FastLoad
script example:
axsmod np_axsmod.so “fallback_directory=...”;
define file= /tmp/mypipe;

4 Launch both the writer and the reader processes, as in the following example where
flod.cmds is the name of the FastLoad job script file:
fexp <fexp.cmd & fastload <flod.cmds &
In this example, UNIX connects both processes through the named pipe /tmp/mypipe.

No comments:

Post a Comment