I have a fastexport job.
when we are using datafile the following error was coming.
"Fatal: Cannot Open Datafile".
Then we ran the job using NamedPipe, which is successful.
what is the difference between the named pipe and data file?
any help?
Named Pipe
Moderators: chulett, rschirm, roy
You can google up the definition of a 'named pipe' if that concept is unfamiliar to you. However, that shouldn't be the difference between success and failure here. 
How about explaining your job design? Saying you have a "fastexport job" doesn't really tell us much of anything.
How about explaining your job design? Saying you have a "fastexport job" doesn't really tell us much of anything.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Au contraire, mon ami...
"FastExport" indicates extraction from Teradata. It may (for example) be that the user ID for Teradata lacks permission to create a file in the indicated directory but can create a fifo file (named pipe), presumably in a different directory.
"FastExport" indicates extraction from Teradata. It may (for example) be that the user ID for Teradata lacks permission to create a file in the indicated directory but can create a fifo file (named pipe), presumably in a different directory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
With the named pipe option, the FastExport process will stream data to a named pipe, and the Teradata MultiLoad plug-in will concurrently read the data from that named pipe.
If you turn off the named pipe option, the MultiLoad plug-in will first run FastExport to dump the output to a sequential data file. Then it will read that sequential data file and send the data down the output link. This is slower than using a named pipe since you don't get the concurrency, but it is a workaround if you have named pipe issues. It is generally preferred to use named pipes if possible.
If you turn off the named pipe option, the MultiLoad plug-in will first run FastExport to dump the output to a sequential data file. Then it will read that sequential data file and send the data down the output link. This is slower than using a named pipe since you don't get the concurrency, but it is a workaround if you have named pipe issues. It is generally preferred to use named pipes if possible.