Page 1 of 1

Sequential file on Datastage 8.0 running on Unix

Posted: Tue Mar 02, 2010 5:04 pm
by cooperjv
I have a parallel job which should read a file which is on a windows share but mounted on UNIX on which datastage runs. When I click View Data from the Output properties tab the file opens and I can see the data.

However when I run the job I get this message
Seq_GHM,0: Unable to open /mnt/edw/infosys/EBI_Work/EJ_LogA_665.txt: No such file or directory.

I can also log on to UNIX and view the file but I still get this error Message'


Any help will be appreciated

Thanks

Joseph

Posted: Wed Mar 03, 2010 2:34 am
by ArndW
How is this drive mounted? Is it mounted per session or at a system level and is available to all users? You can try to add a before-job UNIX call and execute 'ls -al /mnt/edw/infosys/EBI_Work/' to see if that directory is available and what the access rights to it are, as seen by the DataStage runtime process.

Posted: Wed Mar 03, 2010 7:04 am
by cooperjv
Hi Arndw,

Thanks for the reply. The drive is accessable to all users. As I had mentioned I can view the data in the file with View Data as well as in UNIX. I am however new to UNIX, Could you please explain what the UNIX commnad you suggested does.

Thanks

Joseph

Posted: Wed Mar 03, 2010 7:23 am
by cooperjv
Hi Arndw,

I am sorry I should have explained myself better. I can view the file in UNIX when I log on with the user id and password of the account that I use for datastage. I would like to know what The list command that you suggested would do.

Thanks

Joseph

Posted: Wed Mar 03, 2010 7:30 am
by ArndW
It is a simple "ls" command, but if the drive is not mounted or not accessible at runtime the error message might assist in finding out the cause of your problem.

Posted: Thu Mar 04, 2010 3:55 pm
by cooperjv
Hi ArndW,

Thanks for the tip. With your help I could find out that the drive was not accessable.

Joseph