DSXchange

Hi

After having installed Datastage 7.5.1A, we were not able to configure the plugin for the Oracle Enterprise Stage fro which we changed entries in the dsenv file and shutdown n restarted the engine a couple of times

Subsequently(after having restarted the engine a couple of time) we have not been able to connect to the Server and have been receiving the follow error msg

Failed to connect to host: XYZ,project: TEST
(The connection is broken (81002))

We have bounced the server too to no effect.

Have searched the forum without much success

Any ideas?

Can you do a netstat -a | grep -i fin

Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds.

You can verify that the service is running successfully by running
$ ps -ef | grep dsrpc
root 28014 1 0 Nov 07 - 0:00 /Ascential/Ascential/DataStage/DSEngine/bin/dsrpcd

$ netstat -a | grep dsrpc
tcp4 0 0 *.dsrpc *.* LISTEN

Does all that look good?

Ultramundane wrote:Can you do a netstat -a | grep -i fin

Do you see any connections out there with a finwait2 status? If so, you will have to wait for the no -a | grep tcp_finwait2 value divided by 2 seconds to expire before these connections die and you can restart the service. I set this value to 60 for 30 seconds.

You can verify that the service is running successfully by running
$ ps -ef | grep dsrpc
root 28014 1 0 Nov 07 - 0:00 /Ascential/Ascential/DataStage/DSEngine/bin/dsrpcd

$ netstat -a | grep dsrpc
tcp4 0 0 *.dsrpc *.* LISTEN

Does all that look good?

yup it does

dsadm /home/dsadm > netstat -s|grep -i fin
0 delayed ACKs for FIN

and the checks on the dsrpc service succeed

but i still cant get thru

Hi

It seems as though the dsenv we were using was corrupt - we replaced the existing one with a backup copy that we had created and presto - things worked fine

Will have to check the actual cause corruption in the dsenv file.