Unable to connect to Server

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
adarsh shrinagesh
Premium Member
Premium Member
Posts: 68
Joined: Sat Feb 05, 2005 4:59 am
Location: India

Unable to connect to Server

Post by adarsh shrinagesh »

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?
Last edited by adarsh shrinagesh on Fri Nov 11, 2005 4:20 pm, edited 1 time in total.
Ultramundane
Participant
Posts: 407
Joined: Mon Jun 27, 2005 8:54 am
Location: Walker, Michigan
Contact:

Re: Unable to connect to Server

Post by Ultramundane »

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?
adarsh shrinagesh
Premium Member
Premium Member
Posts: 68
Joined: Sat Feb 05, 2005 4:59 am
Location: India

Re: Unable to connect to Server

Post by adarsh shrinagesh »

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
adarsh shrinagesh
Premium Member
Premium Member
Posts: 68
Joined: Sat Feb 05, 2005 4:59 am
Location: India

Re: Unable to connect to Server

Post by adarsh shrinagesh »

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.
Post Reply