• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

SQL2071N RC2

Swagat

ADSM.ORG Member
Joined
May 29, 2017
Messages
42
Reaction score
0
Points
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 ?
 

Swagat

ADSM.ORG Member
Joined
May 29, 2017
Messages
42
Reaction score
0
Points
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.
 

Swagat

ADSM.ORG Member
Joined
May 29, 2017
Messages
42
Reaction score
0
Points
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 ?
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,735
Reaction score
618
Points
0
Location
Canada
Website
www.ibm.com
This link suggests adding 'adregister yes' to the dsm.opt file of the client .
No, Server. That's specific to ANR9961W, not the DB2 errors.
MESSAGE : SQL2071N An error occurred while accessing the shared library "/db2/db2bod/sqllib/adsm/libtsm.a".
Reason code: "2".
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
 

Swagat

ADSM.ORG Member
Joined
May 29, 2017
Messages
42
Reaction score
0
Points
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 .
 

Swagat

ADSM.ORG Member
Joined
May 29, 2017
Messages
42
Reaction score
0
Points
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 .
 

marclant

ADSM.ORG Moderator
Joined
Jun 16, 2006
Messages
3,735
Reaction score
618
Points
0
Location
Canada
Website
www.ibm.com
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 .
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.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

DigitalOcean $100 Credit

Support ADSM.ORG and get DigitalOcean FREE credit. DigitalOcean currently offer a $100, 60-day Free Credit for new accounts. Sign-up here:

DigitalOcean Referral Badge

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 20 18.7%
  • Keep using TSM for Spectrum Protect.

    Votes: 65 60.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.1%
  • Other (please comement)

    Votes: 9 8.4%

Forum statistics

Threads
31,871
Messages
135,906
Members
21,786
Latest member
london
Top