HACMP does not start db2 after failover (db2nodes not getting modified by hacmp)


 
Thread Tools Search this Thread
Operating Systems AIX HACMP does not start db2 after failover (db2nodes not getting modified by hacmp)
# 1  
Old 04-18-2011
HACMP does not start db2 after failover (db2nodes not getting modified by hacmp)

hi,

when I do a failover, hacmp always starts db2 but recently it fails to start db2..noticed the issue is db2nodes.cfg is not modified by hacmp and is still showing primary node..manually changed the node name to secondary after which db2 started immediately..unable to figure out why hacmp is not doing it automatically as it should.. I have checked permissions, all configuration I can think of and even compared to working ones but could not find any diff...any help on the issue is greatly appreciated.

thanks,
g rob
# 2  
Old 04-19-2011
Did you check the hacmp-logs and errpt?
# 3  
Old 04-19-2011
try to run your application server script manually and check where it fails

for db2nodes.cfg, I use the following lines in my Scripts:


Code:
         
                echo "0 $(hostname) 0" > /db2/db2${HASID}/sqllib/db2nodes.cfg 
                chown db2${HASID}:db${HASID}adm /db2/db2${HASID}/sqllib/db2nodes.cfg
                chmod 444 /db2/db2${HASID}/sqllib/db2nodes.cfg

# 4  
Old 04-21-2011
Quote:
Originally Posted by funksen
try to run your application server script manually and check where it fails

for db2nodes.cfg, I use the following lines in my Scripts:


Code:
         
                echo "0 $(hostname) 0" > /db2/db2${HASID}/sqllib/db2nodes.cfg 
                chown db2${HASID}:db${HASID}adm /db2/db2${HASID}/sqllib/db2nodes.cfg
                chmod 444 /db2/db2${HASID}/sqllib/db2nodes.cfg


As I understand, modification of db2nodes.cfg file is the responsiblity of the DB2 start script. So, if that is not happening then something is wrong in the DB script and not an issue with HACMP configuration itself?

In simple, HACMP is not directly responsible for modifying this file with the correct nodename..right? instead it should be the DB2 start script(which is initiated by HACMP) that should be doing it?
# 5  
Old 04-26-2011
the modification is not built in, so you manually have to make it

there must be an application server configured on your cluster, search for that script, and try to add my lines, with your paths of course

db2 checks, if the local hostname is equal with the hostname in db2nodes.cfg

if not, the database wont come up


maybe there is another method to achive this, but simply editing db2nodes.cfg worked fine for me for years now


changing the hostname in the cluster is another solution to solve this problem, but this may lead to problems with other applications

Last edited by funksen; 04-26-2011 at 06:42 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

Thoughts on HACMP: Automatic start of cluster services

Hi all, I remember way back in some old environment, having the HA cluster services not being started automatically at startup, ie. no entry in /etc/inittab. I remember reason was (taken a 2 node active/passive cluster), to avoid having a backup node being booted, so that it will not... (4 Replies)
Discussion started by: zaxxon
4 Replies

2. AIX

HACMP with VIO, service IP failover

Would anyone please kindly help to solve this problem... An LPAR with the below network configuration. ent0 and ent1 are logical lan (virtual ethernet) from VIO SEA. en0 1.2.3.4 <- boot ip 192.168.1.1 <- persistent ip 192.168.1.10 <- service ip en1 11.22.33.44 <- boot ip When I... (6 Replies)
Discussion started by: skeyeung
6 Replies

3. AIX

NFS won't work till I start HACMP

Hi, My NFS does not work till I start HACMP. The NFS service is indeed started when server starts. But it is not in active state, when I use lssrc to check NFS services' status I find they are all in inoperative status. But after I start HACMP (smitty clstart), all NFS services become active... (4 Replies)
Discussion started by: qiulang
4 Replies

4. AIX

hacmp ip load balancer failover

Hi All, How do I failover on the ip load balancer (back and forth)? It involves first to load a new config on the passive ip. If success, load the new config on the ip active (which is now passive). Any idea, please. Thanks in advance. (0 Replies)
Discussion started by: itik
0 Replies

5. AIX

hacmp upgrade with db2

Hi All, My company is going to upgrade the db2 on the one node hacmp, I think there's one backup. After the upgrade of the db2. Do I need to restart cluster and server? I mean, do a graceful shutdown of the cluster, reboot the server and do a cluster start. Is that it? Do I need to reboot... (1 Reply)
Discussion started by: itik
1 Replies

6. AIX

failover on 4.5 hacmp

Hi All, How do I trigger the failover on the second hacmp server? Please give me idea and I will do the rest. Thanks, itik (2 Replies)
Discussion started by: itik
2 Replies

7. HP-UX

HACMP in HP-UX

Hi, Can anybody advice whether it is possible to configure HACMP in HP-UX Server. To my knowledge HACMP is IBM Solution. Thanks && Regards, N. Poorna Chandra Rao. (2 Replies)
Discussion started by: npcrao
2 Replies

8. AIX

Can anyone shed some light on this HACMP failover?

Hello All, Here is a snipet from our cluster.log, I was wondering if anyone could shed some light on what may have caused the failover. The first two lines indicate a possible memory issue which I am currently looking into. Thanks. (0 Replies)
Discussion started by: Wez
0 Replies

9. AIX

HACMP (Again)

Hello I am a noobie to HACMP I have 2 55A servers and a 7031 disk subsystem For HACMP to work, do I need to have the hdisks on both servers to match the same drives?? The hdisks on each box are currently different: hdisk0 and hdisk1 are the internal disks and hdisk2-5 are on the D24 on... (1 Reply)
Discussion started by: mhenryj
1 Replies

10. AIX

Hacmp

(0 Replies)
Discussion started by: mhenryj
0 Replies
Login or Register to Ask a Question