Can not see any ODBC Data Source names from ODBC stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
go4stage
Participant
Posts: 1
Joined: Thu Feb 21, 2008 8:42 am

Can not see any ODBC Data Source names from ODBC stage

Post by go4stage »

Hi All,

I am using ODBC stage to connect to source(DB2) in a parallel job and it is working absolutely fine. While developing the job, in the ODBC stage, we have to write the Data Source Name and there is button to click to see all the available data source names. This was working fine before I restart the Data stage server and WAS (because of adding a Native DB2 connection in dsenv). After the restart the job is running fine with ODBC. But in any ODBC stage, if I want to see all the available ODBC connection present in the UNIX server, I get an error message -
"An exception has occurred while trying to send the request to the handler. Failed to log on via the authenticatiob service".

But if I just type the Data Source Name, the job runs fine.

Anyone knows how to fix this?

Thanks
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”