Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    306

    Unanswered: db2haicu stops before quorum config

    9.7 WSE SLES11

    Hey all,

    I'm setting up TSA for the first time and I've encountered a few problems. Have overcome a few of them but I'm not having any luck on the following (I'm thinking a reinstall might be my only option :[ )

    So on the standby I get this far:
    Code:
     db2haicu
    Welcome ....
    ..
    
    db2haicu did not find a cluster domain on this machine. To continue configuring your clustered environment for high availability, you must create a cluster domain; otherwise, db2haicu will exit.
    
    Create a domain and continue? [1]
    1. Yes
    2. No
    1
    Create a unique name for the new domain:
    hadr_melaitludbpp01_domain
    Nodes must now be added to the new domain.
    How many cluster nodes will the domain hadr_melaitludbpp01_domain contain?
    2
    Enter the host name of a machine to add to the domain:
    melaitludbpp01a
    Enter the host name of a machine to add to the domain:
    melaitludbpp01b     
    db2haicu can now create a new domain containing the 2 machines that you specified. If you choose not to create a domain now, db2haicu will exit.
    
    Create the domain now? [1]
    1. Yes
    2. No
    1
    Creating domain hadr_melaitludbpp01_domain in the cluster ...
    Creating domain hadr_melaitludbpp01_domain in the cluster was successful.
    But then it just stopped.. no errors from the db2haicu but in the diaglog LOADS like:
    Code:
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloNotifyVendorOfNewCall, probe:1010
    MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown"
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x870F00A6
    DATA #2 : unsigned integer, 4 bytes
    10
    DATA #3 : Hexdump, 624 bytes
    0x00007F03BBF150E0 : 401A 2DC6 037F 0000 0000 0000 0000 0000    @.-.............
    0x00007F03BBF150F0 : 0000 0000 0000 0000 E016 0000 0000 0000    ................
    0x00007F03BBF15100 : 0600 0000 4200 0000 0010 0000 0000 0000    ....B...........
    0x00007F03BBF15110 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15120 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15130 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15140 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15150 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15160 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15170 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15180 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15190 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151A0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151B0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151C0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151E0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF151F0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15200 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15210 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15220 : 0300 0000 4100 0000 0010 0000 0000 0000    ....A...........
    0x00007F03BBF15230 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15240 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15250 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15260 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15270 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15280 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15290 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152A0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152B0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152C0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152E0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF152F0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15300 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15310 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15320 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    0x00007F03BBF15330 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
    ...skipping...
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
    MESSAGE : Sending SIGKILL to the following process id
    DATA #1 : signed integer, 4 bytes
    5856
    CALLSTCK: 
      [0] 0x00007F03C3EC1333 pdLog + 0x1FF
      [1] 0x00007F03C3F7D55E sqlossig + 0x10A
      [2] 0x00007F03C3F6B978 /db2home/db2qa/sqllib/lib64/libdb2.so.1 + 0x55B978
      [3] 0x00007F03C3F6B466 sqloTerminateVendorProcess + 0x8E
      [4] 0x00007F03C42DACCA _Z16sqlhaListClusterP16listClusterBlock + 0x35A
      [5] 0x000000000043E1F1 _Z26sqlhaUIGetActiveDomainNamePbPc + 0x151
      [6] 0x00000000004573B7 _ZN17SqlhaUIAppContext6UpdateEv + 0x155B
      [7] 0x0000000000455D50 _ZN17SqlhaUIAppContext11getInstanceEv + 0x168
      [8] 0x0000000000419F81 main + 0x969
      [9] 0x00007F03C2F58BC6 __libc_start_main + 0xE6
    
    2012-08-17-15.52.04.585766+600 E5087793E325        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaListCluster, probe:1500
    RETCODE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown"
    
    2012-08-17-15.52.04.585865+600 E5088119E399        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIListAllDomainsInClus, probe:200
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    MESSAGE : Failed to get cluster list.
    
    2012-08-17-15.52.04.585930+600 E5088519E361        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIListAllDomainsInClus, probe:200
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    
    2012-08-17-15.52.04.585982+600 E5088881E410        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIGetActiveDomainName, probe:200
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    MESSAGE : Error in retrieving Domains in Cluster.
    
    2012-08-17-15.52.04.586034+600 E5089292E498        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIGetActiveDomainName, probe:200
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    DATA #1 : String, 0 bytes
    Object not dumped: Address: 0x00007FFFE1E16620 Size: 0 Reason: Zero-length data
    DATA #2 : Boolean, 8 bytes
    true
    
    2012-08-17-15.52.04.586112+600 E5089791E360        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, SqlhaUIAppContext::Update, probe:1100
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    
    2012-08-17-15.52.04.586178+600 E5090152E364        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, SqlhaUIAppContext::getInstance, probe:100
    RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL
              Internal SQLHA Error
    
    2012-08-17-15.52.04.586234+600 E5090517E353        LEVEL: Error
    PID     : 5855                 TID  : 139654186710784PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIMain, probe:900
    RETCODE : ECF=0x90000530=-1879046864=ECF_SQLHA_NOTINITED
              Library uninitialized error
    Tried to do db2haicu -delete and get:
    Code:
    db2haicu -delete
    Welcome to....
    There was an error with one of the issued cluster manager commands. Refer to db2diag.log and the DB2 Information Center for details.
    Any advice?
    Last edited by meehange; 08-17-12 at 04:13. Reason: typo

  2. #2
    Join Date
    Jul 2004
    Posts
    306
    I've uninstalled and reinstalled SAM and run db2haicu again. It still craps out just before Quorum config but now the diaglog has :

    Code:
    2012-08-20-14.12.51.657259+600 I5562446E381        LEVEL: Warning
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    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
    
    2012-08-20-14.13.34.590935+600 E5562828E800        LEVEL: Error
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetClusterVersion, probe:300
    MESSAGE : ECF=0x90000554=-1879046828=ECF_SQLHA_QUERY_FAILED
              Query object attributes failed
    DATA #1 : String, 35 bytes
    Error during vendor call invocation
    DATA #2 : unsigned integer, 4 bytes
    22
    DATA #3 : String, 21 bytes
    melaitludbpp01_domain
    DATA #4 : unsigned integer, 8 bytes
    1
    DATA #5 : signed integer, 4 bytes
    262157
    DATA #6 : String, 114 bytes
    Line # : 10587---2610-412 A Resource Manager terminated while attempting to enumerate resources for this command.
    DATA #7 : String, 30 bytes
    Name = 'melaitludbpp01_domain'
    
    2012-08-20-14.13.34.591169+600 E5563629E371        LEVEL: Error
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaGetInfoForCluster, probe:1300
    RETCODE : ECF=0x90000554=-1879046828=ECF_SQLHA_QUERY_FAILED
              Query object attributes failed
    
    2012-08-20-14.13.34.612025+600 E5564001E370        LEVEL: Error
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIConfigureDomain, probe:1000
    RETCODE : ZRC=0x827300D1=-2106392367=HA_ZRC_QUERY_FAILED
              "Query object attributes failed"
    
    2012-08-20-14.13.34.612167+600 E5564372E368        LEVEL: Error
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUINewDomainSetup, probe:300
    RETCODE : ZRC=0x827300D1=-2106392367=HA_ZRC_QUERY_FAILED
              "Query object attributes failed"
    
    2012-08-20-14.13.34.612223+600 E5564741E359        LEVEL: Error
    PID     : 19168                TID  : 140224156796672PROC : db2haicu
    INSTANCE: db2qa                NODE : 000
    FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure, sqlhaUIMain, probe:1500
    RETCODE : ZRC=0x827300D1=-2106392367=HA_ZRC_QUERY_FAILED
              "Query object attributes failed"

  3. #3
    Join Date
    Jan 2014
    Posts
    1
    Hi,

    I met the problem too. Could you tell me how you fixed it?
    thank you very much!

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you executed preprpnode ?
    have you copied policies : db2cptsa
    fixpack ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •