DSXchange

Dear Srini,

The same issue is coming in one of my job.

but the issue get resolved by using delete then insert rather update then insert.

I have no clue why it is happening.

Please reply.

Regards,
Sany

Hi,

I have the relaxed the firewall from all servers. But still no success. Several times started the servers, also did the manual starting of servers but with no success. Now I am thinking to re install the engine tier

Thanks.

Dear Istsaur,

I have tried lsof but no results were fetched...

Thanks

Dear Istsaur,

I will definitely try lsof and let you know the result. However can you tell me in addition to systemout.log where I can check datastage logs.

Thanks

Dear Chulett,

Due to this I am not able to login datastage client as asbagent service port (31531) port is not available at engine tier.

Thanks.

Dear Ray,

No error logged in Systemout.log

Thanks.

Dear Chulett, Between DataStage App Servers (Both engine and Service tier) and DataStage DB Servers Cluster following ports are opened: 50000 (Db2 port), 60000-60004 (Db2 instance service port), 31538, 31531, 13400,13401, 31533 (Datastage ports), 80, 9080-9084, 2810-2812,9100-9102,9407-9412,7278-727...

Dear istsaur, I have tried node NodeAgents.sh start and uv -admin start with root user and dsadm respectively, but with no sucess. Server was working fine earlier when firewal was not used although as i mentioned i have opened all the required ports for datastage. Please help if i miss out anything....

Hi Everyone, Not getting the listing of 31531 port via netstat -an | grep 3153*. Only 31533 and 31538 are visible. Have tried all possible option to start/stop DS engine and Websphere application server but with no success. I have open all the ports in firewall required for IBM information server. E...

Dear Elaveni,

Sorry for not replying you on time, please add the dns ip in your client machine network adapter.

thnx, it works.

Hello, I would like to give little background of my actual problem. I have table which is having blob datatype column having values from rich text editor having basic word pad type formatted text. I have to migrate this data to another database for some requirement using datatstage 8.5. I have used ...

Hi All,

I have table having column with Hex values. How can I convert those Hex values to plain text using DataStage job? Which stage can help me in achieving the same?

Thanks,

Sanygup

This error was resolved by opening all the DataStage required ports from the firewall.

Hi, I have facing issue while login datastage client. Error message is: "An error occured while retrieving the folder content for "/" : Failure in repository access interface." Datastage engine and services are in AIX cluster mode. DB2 is a database. Datastage version is 8.5 Clie...