1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

SQL2071N RC2

Discussion in 'DB2' started by Swagat, Oct 25, 2017.

  1. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
    upload_2017-10-25_15-11-25.png
    db2diag.log output


    upload_2017-10-25_15-12-4.png

    upload_2017-10-25_15-12-27.png
    actual error


    I cannot find a solution . Can the libtsm.a file be recreated ?
     
  2.  
  3. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
    2017-10-25-20.36.18.670385+630 I310528205E551 LEVEL: Error
    PID : 20891 TID : 139861784782592 PROC : db2sysc 0
    INSTANCE: db2bod NODE : 000 DB : BOD
    APPHDL : 0-387 APPID: *LOCAL.db2bod.171025100618
    AUTHID : DB2BOD HOSTNAME: mmalbod01
    EDUID : 185 EDUNAME: db2agent (BOD) 0
    FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:485
    MESSAGE : SQL2071N An error occurred while accessing the shared library "".
    Reason code: "".

    2017-10-25-20.36.18.670733+630 E310528757E645 LEVEL: Error
    PID : 20891 TID : 139861784782592 PROC : db2sysc 0
    INSTANCE: db2bod NODE : 000 DB : BOD
    APPHDL : 0-387 APPID: *LOCAL.db2bod.171025100618
    AUTHID : DB2BOD HOSTNAME: mmalbod01
    EDUID : 185 EDUNAME: db2agent (BOD) 0
    FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:752
    MESSAGE : SQL2071N An error occurred while accessing the shared library "".
    Reason code: "".
    DATA #1 : String, 63 bytes
    Could not delete partial backup image created on vendor device.

    2017-10-25-20.36.18.695572+630 E310529403E463 LEVEL: Severe
    PID : 20891 TID : 139861784782592 PROC : db2sysc 0
    INSTANCE: db2bod NODE : 000 DB : BOD
    APPHDL : 0-387 APPID: *LOCAL.db2bod.171025100618
    AUTHID : DB2BOD HOSTNAME: mmalbod01
    EDUID : 185 EDUNAME: db2agent (BOD) 0
    FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:1075
    MESSAGE : Backup terminated.
     
  4. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
  5. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,606
    Likes Received:
    370
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
  6. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
    Thanks for the reply .
    This link suggests adding 'adregister yes' to the dsm.opt file of the client . This client has an OS backup node configured which is running fine , it is the DB2 backup that is having issues .
    Error from DB2 end :
    MESSAGE : SQL2071N An error occurred while accessing the shared library "/db2/db2bod/sqllib/adsm/libtsm.a".
    Reason code: "2".
    Can this file be regenerated with a fresh client installation ?
     
  7. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,606
    Likes Received:
    370
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    No, Server. That's specific to ANR9961W, not the DB2 errors.
    It's in a DB2 path, so it would come from a DB2 install. This was the first Google hit regarding SQL2071N + libtsm.a: http://www-01.ibm.com/support/docview.wss?uid=swg21598050
     
  8. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
    Hi . Could you please help me further . I am still getting both the errors .
    For ANR9961W how and where do I add the 'adregister yes' command ?
    dsmserv.opt ? can i just edit and add this line to it ?


    And for the libtsm.a error , I have re-installed the tsm clients and copied the same file from a working server .
     
  9. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,606
    Likes Received:
    370
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Yes
    Yes

    And then restart the instance.
     
  10. Swagat

    Swagat ADSM.ORG Member

    Joined:
    May 29, 2017
    Messages:
    32
    Likes Received:
    0
    Hi
    I could solve the ANR9961W issue with the above said entry to the dsmserv.opt . (Thank You)
    However , SQL2071N still exists and I am getting the same error . I have removed and installed the client and reconfigured . Re-created the node as well .
    DB2 team have done their end of re-configuration .
    Could you please help me resolve this . I am unable to find a solution to this .
    http://www-01.ibm.com/support/docview.wss?uid=swg21598050 I have checked this link and there in only 1 path where this library file exists .
    Permissions to the dsm.sys and the error log , password file path has been modified as per a working client with a similar db2 setup .
     
  11. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,606
    Likes Received:
    370
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    That would not change anything since SQL2071N is a DB2 error and "/db2/db2bod/sqllib/adsm/libtsm.a" is a file that ships with DB2 and used to backup to Spectrum Protect. I'm not of any help at this point, further investigation will need to be done from the DB2 side and I know very little about that.
     

Share This Page