-
-
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
- Thread starter Swagat
- Start date
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.
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.
marclant
ADSM.ORG Moderator
Here you go, it's the help on message ANR9961W, it should provide you with the solution: https://www.ibm.com/support/knowledgecenter/en/SSGSG7_7.1.5/srv.msgs/ANR9961W_Windows.html
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 ?
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
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
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 .
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 .
marclant
ADSM.ORG Moderator
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 .
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
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.
