Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2haicu fails with error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-23-10, 03:14
nvk@vhv nvk@vhv is offline
Registered User
  
Join Date: Jan 2010
Posts: 294
db2haicu fails with error
Hi,

i'm setting up a HADR-System with db2haicu.
Setup of HADR for the database is done. Now i want to configure the automatic failover with db2haicu. It's my first time, so i'm using http://www.ibm.com/developerworks/fo...R_db2haicu.pdf as reference.
Setup ran fine till i wnated to set up the Cluster Manager. After i selected the TSA, the configuration for it failed. The following Messages were written to db2diag.log

Code:
2010-07-23-08.49.06.006903+120 I222399E529         LEVEL: Warning
PID     : 21966                TID  : 140309451237712PROC : db2sysc 0
INSTANCE: idb2tst              NODE : 000
APPHDL  : 0-176                APPID: *LOCAL.idb2tst.100722121726
AUTHID  : IDB2TST
EDUID   : 64                   EDUNAME: db2agent (instance) 0
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetPolicyTypeFromSysFile, probe:400
MESSAGE : No matching instance record ... setting policy to none
DATA #1 : unsigned integer, 4 bytes
0

2010-07-23-08.49.06.008110+120 I222929E444         LEVEL: Event
PID     : 21966                TID  : 140309451237712PROC : db2sysc 0
INSTANCE: idb2tst              NODE : 000
APPHDL  : 0-176                APPID: *LOCAL.idb2tst.100722121726
AUTHID  : IDB2TST
EDUID   : 64                   EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE  : CFG DBM: "Cluster_mgr" From: ""  To: "TSA"

2010-07-23-08.49.06.065179+120 E223374E741         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAddResourceGroup, probe:300
MESSAGE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
27
DATA #3 : String, 26 bytes
db2_idb2tst_DB2CLUS02_0-rg
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : unsigned integer, 8 bytes
1
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 0 bytes
Object not dumped: Address: 0x0000000000ABE29C Size: 0 Reason: Zero-length data

2010-07-23-08.49.06.065406+120 E224116E264         LEVEL: Warning
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaCreateGroup, probe:50

2010-07-23-08.49.06.085873+120 E224381E586         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
MESSAGE : Failed to create Resource Group in creating partition in cluster.
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-08.49.06.085957+120 E224968E510         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-08.49.06.101500+120 E225479E372         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIConfigurePartition, probe:1400
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-08.49.06.101672+120 E225852E369         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUINewInstanceSetup, probe:600
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-08.49.06.101724+120 E226222E358         LEVEL: Error
PID     : 30640                TID  : 140452318062336PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIMain, probe:1800
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

I'm using DB2 9.7 FP2 on SuSe Linux Enterprise 11 FP 0.

Cheers
nvk
Reply With Quote
  #2 (permalink)  
Old 07-23-10, 04:33
nvk@vhv nvk@vhv is offline
Registered User
  
Join Date: Jan 2010
Posts: 294
Second Try brought new errors
Code:
2010-07-23-09.45.22.736331+120 I271304E1257        LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, Generic Registry, GenRegFile::OpenReg, probe:8
MESSAGE : ECF=0x900001C0=-1879047744=ECF_GENREG_OPEN_OUTPUT_FILE_FAILED
          Failed to open the output registry
CALLED  : OS, -, fopen
RETCODE : ECF=0x90000513=-1879046893=ECF_GENREG_REGISTRY_DOESNT_EXIST
          The registry does not exist.
DATA #1 : String, 46 bytes
/var/db2luw/users/idb2tst/sqllib/cfg/db2ha.sys
CALLSTCK:
  [0] 0x00007F17C284333E pdOSSeLoggingCallback + 0x100
  [1] 0x00007F17C465AA42 /var/db2luw/users/idb2tst/sqllib/lib64/libdb2osse.so.1 + 0x1C4A42
  [2] 0x00007F17C465C157 ossLogRC + 0xBF
  [3] 0x00007F17C4261630 _ZN10GenRegFile7OpenRegEm + 0x414
  [4] 0x00007F17C426EF5E _ZN9GenRegBin3GetEmPvS0_ + 0xFC
  [5] 0x00007F17C2C52DFF _Z14sqlhaGetPolicyR5HARegR16_sqlhaPolicyType + 0xF9
  [6] 0x00007F17C2C5372A _Z14sqlhaSetPolicyR5HAReg16_sqlhaPolicyType + 0xDC
  [7] 0x00007F17C2C53BAB _Z27sqlhaSetPolicyTypeInSysFile16_sqlhaPolicyType + 0xDD
  [8] 0x000000000042026F _Z16sqlhaUISetPolicy16_sqlhaPolicyType + 0x31
  [9] 0x000000000044D47F _Z30sqlhaUIConfigureFailoverPolicyPc + 0x129

2010-07-23-09.45.22.781294+120 E272562E741         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAddResourceGroup, probe:300
MESSAGE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
27
DATA #3 : String, 26 bytes
db2_idb2tst_DB2CLUS02_0-rg
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : unsigned integer, 8 bytes
1
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 0 bytes
Object not dumped: Address: 0x0000000000AB8B9C Size: 0 Reason: Zero-length data

2010-07-23-09.45.22.781494+120 E273304E264         LEVEL: Warning
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaCreateGroup, probe:50

2010-07-23-09.45.22.801938+120 E273569E586         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
MESSAGE : Failed to create Resource Group in creating partition in cluster.
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-09.45.22.802022+120 E274156E510         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-09.45.22.802386+120 E274667E372         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIConfigurePartition, probe:1400
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-09.45.22.802519+120 E275040E369         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUINewInstanceSetup, probe:600
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-09.45.22.802570+120 E275410E358         LEVEL: Error
PID     : 16744                TID  : 139740061685504PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIMain, probe:1800
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
Reply With Quote
  #3 (permalink)  
Old 07-23-10, 07:37
przytula_guy przytula_guy is offline
Registered User
  
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
you indicate setup is ok : do you mean db2haicu ?
now cluster manager ?
additional ??
please remove all on both nodes db2haicu -delete
start with a clean setup and indicate the error
is preprpnode done ?
is db2cptsa done
many problems have been corrected with fp1
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #4 (permalink)  
Old 07-23-10, 09:27
nvk@vhv nvk@vhv is offline
Registered User
  
Join Date: Jan 2010
Posts: 294
Thanks for the Hints.

preprpnode was done on both servers
db2cptsa was missing, but it's done now on both servers.

DB2 FP2 installed a new version of sa scripts. I manually removed the FP0 Version of SA MP and installed the Version from FP2 (sam-3.1.0.6-10046).
Database was setup after installation of FP2. HADR is setup and working fine. I can make failovers manually.

I've dropped the Cluster Configuration and restarted it
Code:
...
Create networks for these network interface cards? [1]
1. Yes
2. No
1
Enter the name of the network for the network interface card: bond0 on cluster node: DB2CLUS02
1. Create a new public network for this network interface card.
2. Create a new private network for this network interface card.
Enter selection:
1
Are you sure you want to add the network interface card bond0 on cluster node DB2CLUS02 to the network db2_public_network_0? [1]
1. Yes
2. No
1
Adding network interface card bond0 on cluster node DB2CLUS02 to the network db2_public_network_0 ...
Adding network interface card bond0 on cluster node DB2CLUS02 to the network db2_public_network_0 was successful.
Enter the name of the network for the network interface card: bond0 on cluster node: DB2CLUS01
1. db2_public_network_0
2. Create a new public network for this network interface card.
3. Create a new private network for this network interface card.
Enter selection:
1
Are you sure you want to add the network interface card bond0 on cluster node DB2CLUS01 to the network db2_public_network_0? [1]
1. Yes
2. No
1
Adding network interface card bond0 on cluster node DB2CLUS01 to the network db2_public_network_0 ...
Adding network interface card bond0 on cluster node DB2CLUS01 to the network db2_public_network_0 was successful.
Retrieving high availability configuration parameter for instance idb2tst ...
Retrieving high availability configuration parameter for instance idb2tst was successful.
Adding DB2 database partition 0 to the cluster ...
There was an error with one of the issued cluster manager commands. Refer to db2diag.log and the DB2 Information Center for details.
Code:
2010-07-23-15.14.38.095903+120 I279332E1257        LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, Generic Registry, GenRegFile::OpenReg, probe:8
MESSAGE : ECF=0x900001C0=-1879047744=ECF_GENREG_OPEN_OUTPUT_FILE_FAILED
          Failed to open the output registry
CALLED  : OS, -, fopen
RETCODE : ECF=0x90000513=-1879046893=ECF_GENREG_REGISTRY_DOESNT_EXIST
          The registry does not exist.
DATA #1 : String, 46 bytes
/var/db2luw/users/idb2tst/sqllib/cfg/db2ha.sys
CALLSTCK:
  [0] 0x00007F10C2EF233E pdOSSeLoggingCallback + 0x100
  [1] 0x00007F10C4D09A42 /var/db2luw/users/idb2tst/sqllib/lib64/libdb2osse.so.1 + 0x1C4A42
  [2] 0x00007F10C4D0B157 ossLogRC + 0xBF
  [3] 0x00007F10C4910630 _ZN10GenRegFile7OpenRegEm + 0x414
  [4] 0x00007F10C491DF5E _ZN9GenRegBin3GetEmPvS0_ + 0xFC
  [5] 0x00007F10C3301DFF _Z14sqlhaGetPolicyR5HARegR16_sqlhaPolicyType + 0xF9
  [6] 0x00007F10C330272A _Z14sqlhaSetPolicyR5HAReg16_sqlhaPolicyType + 0xDC
  [7] 0x00007F10C3302BAB _Z27sqlhaSetPolicyTypeInSysFile16_sqlhaPolicyType + 0xDD
  [8] 0x000000000042026F _Z16sqlhaUISetPolicy16_sqlhaPolicyType + 0x31
  [9] 0x000000000044D47F _Z30sqlhaUIConfigureFailoverPolicyPc + 0x129

2010-07-23-15.14.38.145813+120 E280590E741         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaAddResourceGroup, probe:300
MESSAGE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
27
DATA #3 : String, 26 bytes
db2_idb2tst_DB2CLUS02_0-rg
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : unsigned integer, 8 bytes
1
DATA #6 : signed integer, 4 bytes
0
DATA #7 : String, 0 bytes
Object not dumped: Address: 0x0000000000AB8B9C Size: 0 Reason: Zero-length data

2010-07-23-15.14.38.146033+120 E281332E264         LEVEL: Warning
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaCreateGroup, probe:50

2010-07-23-15.14.38.166528+120 E281597E586         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
MESSAGE : Failed to create Resource Group in creating partition in cluster.
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-15.14.38.166616+120 E282184E510         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUICreatePartition, probe:200
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
DATA #1 : String, 7 bytes
idb2tst
DATA #2 : String, 9 bytes
DB2CLUS02
DATA #3 : signed integer, 4 bytes
1
DATA #4 : signed integer, 4 bytes
0

2010-07-23-15.14.38.167079+120 E282695E372         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIConfigurePartition, probe:1400
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-15.14.38.167259+120 E283068E369         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUINewInstanceSetup, probe:600
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster

2010-07-23-15.14.38.167313+120 E283438E358         LEVEL: Error
PID     : 31898                TID  : 139710003922688PROC : db2haicu
INSTANCE: idb2tst              NODE : 000
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIMain, probe:1800
RETCODE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR
          Error reported from Cluster
Reply With Quote
  #5 (permalink)  
Old 06-07-11, 19:14
glabelle glabelle is offline
Registered User
  
Join Date: Jun 2011
Posts: 1
Did you ever fix this problem, I have the exact same issue.

Thanks

Guillaume

guillaume_labelle@yahoo.com
Reply With Quote
  #6 (permalink)  
Old 06-08-11, 02:35
nvk@vhv nvk@vhv is offline
Registered User
  
Join Date: Jan 2010
Posts: 294
Yes, i was able to fix it.
I was really annoyed and so i reinstalled both boxes from scratch. Afterwards it worked as expected.
Reply With Quote
  #7 (permalink)  
Old 06-10-11, 14:32
deshaipet deshaipet is offline
Registered User
  
Join Date: Aug 2008
Posts: 76
HI Glabelle,

If your problem still persists. Please make sure that the hostname, uname -a, db2nodes.cfg has the same hostname. If it is a short hostname it must be short in all the 3 locations mentioned and if it is fully qualified name it must be fully qualified in all the 3 locations.

on AIX:

hostname

uname -a

cd $HOME/sqllib
cat db2nodes.cfg

Thanks,
Panditt
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.