db2start or db2stop is not working in ESE instance when network is down?

Harishkumar .Pathangay

db2start or db2stop is not working in ESE instance when network is down?

hi,

I have an ESE instance and Express-C instance. both with TCPIP communication manager enabled.

I am able to start stop db2 in Express-C [regular instance] even if network is off or down.

I am not able to start stop db2 in ESE [ESE instance with db2nodes.cfg] even if network is off or down

Error: SQL6048N

so if for some reason the network is down, some physical error with cables, then how do you start stop db2 if needed. I do not want to wait till the network problem is getting fixed right?

/etc/host.conf:

order host,bind

multi on

As per this file, if network is down, then it should still resolve machine/host name from /etc/hosts file.

so that should not prevent the db2 instance stop or start.

I do not what I am missing?

 

thanks,

harish pathangay

Edited By:
Harishkumar .Pathangay[Organization Members] @ Dec 17, 2017 - 10:56 PM (Asia/Calcutta)

Harishkumar .Pathangay

RE: db2start or db2stop is not working in ESE instance when network is down?
(in response to Harishkumar .Pathangay)

it is not pinging the node name of the machine when network is down. I am not a Linux expert, but my understanding was even if network is down the IP Address can be resolved from /etc/hosts file [in my case it is a static ip] except that it is not participating in a network as long as it is down or off. if the network comes up, my computer should join into the network if no other existing computer in the network is having the same ip address. it should not affect the up and down of a service. for example, I have ssh service I can start and stop ssh daemon even if network is down. whether client connect to ssh service is only dependent on availability of the network, the start and stop of service is allowed irrespective of the network availability. I understand that ssh and db2 are different services, but the concept is more of tcp ip right? why db2 chooses to behave in a different way. please let me know your thoughts.

thanks, harish pathangay