DSXchange

Posted: **Thu Feb 18, 2010 12:55 pm**

Hi i have created a job which load data from sequential file into database

job flow

SEQ_ FILE ------> ODBC Connector

The job was working fine earlier. but now when i am trying to test the connection i am getting an error stating that.

An Execption occured while trying to send the request to the handler. the agent nsads-dev2:31531 is not available.

can any one help me out.

Posted: **Thu Feb 18, 2010 1:16 pm**

What is nsads-dev2 ? Is this your server name? Can you connect to it from outside of DataStage?

Posted: **Thu Feb 18, 2010 1:33 pm**

nsads-dev2 is server name. what do you mean by can you connect outside the datastage i dint get it please can you explain in detail

thank you

Posted: **Thu Feb 18, 2010 2:16 pm**

I mean use your favourite sql tool, acess or something to connect to the database and see if its up and running.

Posted: **Thu Feb 18, 2010 4:29 pm**

Check that all services are running, particularly the WebSphere Application Server and the ASBAgent. That's where port number 31531 gets involved. Check, too, that the machine name nsads-dev can be resolved to an IP address (using ping is sufficient).

DSXchange

agent at nsads-dev2:31531 is not available

agent at nsads-dev2:31531 is not available