Sponsored Content
Operating Systems AIX HACMP does not start db2 after failover (db2nodes not getting modified by hacmp) Post 302517094 by funksen on Tuesday 26th of April 2011 04:41:49 AM
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..
 

10 More Discussions You Might Find Interesting

1. AIX

Hacmp

(0 Replies)
Discussion started by: mhenryj
0 Replies

2. 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

3. 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

4. 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

5. 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

6. 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

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

8. 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

9. 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

10. 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
MySQL::Diff(3pm)					User Contributed Perl Documentation					  MySQL::Diff(3pm)

NAME
MySQL::Diff - Generates a database upgrade instruction set SYNOPSIS
use MySQL::Diff; my $md = MySQL::Diff->new( %options ); my $db1 = $md->register_db($ARGV[0], 1); my $db2 = $md->register_db($ARGV[1], 2); my $diffs = $md->diff(); DESCRIPTION
Generates the SQL instructions required to upgrade the first database to match the second. METHODS
Constructor new( %options ) Instantiate the objects, providing the command line options for database access and process requirements. Public Methods Fuller documentation will appear here in time :) o register_db($name,$inx) Reference the database, and setup a connection. The name can be an already existing 'MySQL::Diff::Database' database object. The index can be '1' or '2', and refers both to the order of the diff, and to the host, port, username and password arguments that have been supplied. o db1() o db2() Return the first and second databases registered via "register_db()". o diff() Performs the diff, returning a string containing the commands needed to change the schema of the first database into that of the second. COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
mysqldiff, MySQL::Diff::Database, MySQL::Diff::Table, MySQL::Diff::Utils AUTHOR
Adam Spiers <mysqldiff@adamspiers.org> perl v5.14.2 2012-04-06 MySQL::Diff(3pm)
All times are GMT -4. The time now is 09:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy