Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    29

    Unanswered: TSA library cannot load errors

    Hello guys,

    I have been getting a lot of errors in my db2diag.log file along with multiple trap files being created (about 1.5 GB in three weeks).

    This has started after I have upgraded the instance and database from version 9.7.0.4 to 10.5.0.3. The upgrade process went fine without any errors and the database is actually functioning fine - that is, apart from the errors in the db2diag.log, nothing else out of ordinary.

    I did however, had TSA enabled in the past, but that is now disabled:
    Cluster manager is now unset.

    Has anyone expirienced similar problems or knows what could be the problem. It probably has something to do with TSA, but I'm unsure what. A previous dba configured TSA and it was disabled after, so maybe it has something to do with that (maybe that it wasn't disabled all the way through, but these errors only appeared after the upgrade, whereas the TSA was disabled over a year ago. They also appear on the other node in the HADR (that node also used to be included in the TSA cluster)

    Anyway, here are the errors that keep poping up in db2diag.log:

    Code:
    2014-06-23-13.28.22.274934+120 I585180537E959        LEVEL: Error
    PID     : 23365                TID : 46912868212640  PROC : db2havend (db2ha)
    INSTANCE: db2insp1             NODE : 000
    HOSTNAME: pfdb01
    FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80
    MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
              Cannot load the specified library
    DATA #1 : Hex integer, 4 bytes
    0x00000000
    DATA #2 : String, 40 bytes
    /home/db2insp1/sqllib/lib64/libdb2tsa.so
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
      [0] 0x00002AAAB75CEE0B /opt/ibm/db2/V10.5/lib64/libdb2osse.so.1 + 0x217E0B
      [1] 0x00002AAAB75CEC43 ossLog + 0xA3
      [2] 0x00002AAAB75DC09C _ZN11OSSHLibrary4loadEPKcm + 0x1BC
      [3] 0x0000000000410499 _Z28sqlhaInitializeVendorProcessPv + 0xC9
      [4] 0x0000000000405405 main + 0x805
      [5] 0x00002AAAB85BDC36 __libc_start_main + 0xE6
      [6] 0x0000000000404B69 pdOSSeLoggingCallback + 0x239
    
    2014-06-23-13.28.22.275867+120 I585181497E947        LEVEL: Error
    PID     : 23365                TID : 46912868212640  PROC : db2havend (db2ha)
    INSTANCE: db2insp1             NODE : 000
    HOSTNAME: pfdb01
    FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
    MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
              Cannot load the specified library
    DATA #1 : String, 70 bytes
    libct_mc.so: cannot open shared object file: No such file or directory
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
      [0] 0x00002AAAB75CEE0B /opt/ibm/db2/V10.5/lib64/libdb2osse.so.1 + 0x217E0B
      [1] 0x00002AAAB75CEC43 ossLog + 0xA3
      [2] 0x00002AAAB75DC114 _ZN11OSSHLibrary4loadEPKcm + 0x234
      [3] 0x0000000000410499 _Z28sqlhaInitializeVendorProcessPv + 0xC9
      [4] 0x0000000000405405 main + 0x805
      [5] 0x00002AAAB85BDC36 __libc_start_main + 0xE6
      [6] 0x0000000000404B69 pdOSSeLoggingCallback + 0x239
    
    2014-06-23-13.28.22.276564+120 E585182445E631        LEVEL: Error
    PID     : 22923                TID : 46912605061920  PROC : db2gcf
    INSTANCE: db2insp1             NODE : 000
    HOSTNAME: pfdb01
    FUNCTION: DB2 UDB, high avail services, sqlhaInitVendorInfrastructure, probe:850
    MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
              Cannot load the specified library
    DATA #1 : String, 36 bytes
    Error initializing HA Vendor Process
    DATA #2 : unsigned integer, 4 bytes
    2415919222
    DATA #3 : String, 40 bytes
    /home/db2insp1/sqllib/lib64/libdb2tsa.so
    DATA #4 : String, 5 bytes
    db2ha
    DATA #5 : Pointer, 8 bytes
    0x00002aaab1372080
    
    2014-06-23-13.28.22.277739+120 E585183077E269        LEVEL: Error
    PID     : 22923                TID : 46912605061920  PROC : db2gcf
    INSTANCE: db2insp1             NODE : 000
    HOSTNAME: pfdb01
    FUNCTION: DB2 UDB, high avail services, sqlhaSetupHAInfrastructure, probe:70
    
    2014-06-23-13.28.22.278353+120 I585183347E838        LEVEL: Error
    PID     : 22923                TID : 46912605061920  PROC : db2gcf
    INSTANCE: db2insp1             NODE : 000
    HOSTNAME: pfdb01
    FUNCTION: DB2 Common, Generic Control Facility, gcf_getstate, probe:109
    MESSAGE : ZRC=0x827300AA=-2106392406=HA_ZRC_FAILED "SQLHA API call error"
    CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
      [0] 0x00002AAAAAEE3E0B /home/db2insp1/sqllib/lib64/libdb2osse.so.1 + 0x217E0B
      [1] 0x00002AAAAAEE3C67 ossLog + 0xC7
      [2] 0x00002AAAB343D5E7 gcf_getstate + 0xAD7
      [3] 0x00002AAAAB429349 _ZN9GcfCaller8getStateEP12GCF_PartInfomP11GCF_RetInfo + 0x189
      [4] 0x0000000000403468 main + 0x1158
      [5] 0x00002AAAAF2D2C36 __libc_start_main + 0xE6
      [6] 0x0000000000402279 _ZNSt8ios_base4InitD1Ev + 0x39
    DB: DB2 10.5.0.3 WSE (previously 9.7.0.4 WSE)
    OS: Suse Enterprise Linux 11.2

    Kind regards,
    kwhtre
    Last edited by kwhtre; 06-23-14 at 09:48.

  2. #2
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    TSA services are trying to hit the db as per your previous conf. but as you said it has been disabled now. How it was disabled ? TSA server internally is still active and probing the DB at regular intervals causing these errors. You may try to uninstall TSA completely to get rid of such errors.
    ssumit

  3. #3
    Join Date
    Feb 2013
    Posts
    29
    Hi,

    yes, the lssam command still outputs information about the cluster.
    The TSA was disabled by issuing the "db2haicu -disable" command.
    I presume that the "db2haicu -delete" command should help, right ? Unfortunately I cannot connect to the systems now, so I am unable to try this out, but I will post what happened when I get access again.

    Thanks for the reply and best regards,
    kwhtre

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    when migrating from version (as stated in doc) all tsa definitions must be dropped and re-created
    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
  •