
UNSOLVED
S
surjeet_singh
1 Rookie
•
21 Posts
0
10952
March 18th, 2015 02:00
SQL2062N An error occurred while accessing media "/usr/lib/libnsrdb2.so".
Hello Guys... Can anyone help me regarding below issue for DB2 backup.?
* server.networker:DB2:/SDD/NODE0000 PRECMD completed successfully.
* server.networker:DB2:/SDD/NODE0000 Backing up 'SDD' database...
* server.networker:DB2:/SDD/NODE0000 Unable to backup SDD database due to backup request failure, SQLCODE : -2062, SQL2062N An error occurred while accessing media "/usr/lib/libnsrdb2.so".
* server.networker:DB2:/SDD/NODE0000 Reason code: "0".
* server.networker:DB2:/SDD/NODE0000 .ERROR: DbBackup() failed
* server.networker:DB2:/SDD/NODE0000
* server.networker:DB2:/SDD/NODE0000 NMDA backup failed.
* server.networker:DB2:/SDD/NODE0000 64673:nsrdasv: Unable to backup SDD database due to backup request failure, SQLCODE : -2062, SQL2062N An error oc
curred while accessing media "/usr/lib/libnsrdb2.so".
* server.networker:DB2:/SDD/NODE0000 Reason code: "0".
* server.networker:DB2:/SDD/NODE0000
Thanks in advance !!
Responses (8)
Solutions (0)
surjeet_singh
1 Rookie
•
21 Posts
6682
0
Posted March 18th, 2015 05:00
Hello Prajith,
Thanks for reply !!
Yes file exists on the client machine.
/usr/lib/libnsrdb2.so
-rwxr-xr-x root 10348170 Nov 30 2011 libnsrdb2.so
Reply surjeet_singh
1 Rookie
•
21 Posts
6682
0
Posted March 18th, 2015 08:00
Hello William,
Thank you !!
We have already done this thing with OS team, and it was usefull but after a week it's comming again with same error.
# the permission and owners of the below
/nsr/apps/tmp folder
/nsr/apps/logs folder
/nsr/tmp folder
/nsr/apps/logs/nmda_db2.messages.raw file
Below are the permission now
cd /nsr/apps/
drwxr-xr-t 507 24576 Mar 15 03:37 logs
drwxrwxrwt root 4096 Mar 17 07:22 tmp
cd /nsr/
drwxrwxrwt 507 4096 Oct 17 2013 applogs
drwxr-xr-x root 4096 Jan 30 2014 logs
drwxrwxrwt root 4096 Mar 12 14:01 apps
drwxr-xr-x root 4096 Mar 18 05:14 tmp/nsr/apps/logs/nmda_db2.messages.raw
-rw-rw-rw- 507 2821 Mar 17 07:22 nmda_db2.messages.raw
Reply Surjeet,
What is the user 507?
Is the DB2 instance owner? If it’s not related or you have different users for the backups you will need to change?
The /nor/apps dir. has full permissions owner root
The logs dir. underneath only allows 507 to write to it?
Bill Mason
Reply surjeet_singh
1 Rookie
•
21 Posts
6682
0
Posted March 18th, 2015 09:00
Yes 507 is instance owner
Reply Hello Guys,
While doing a DB2 restore with CLI on windows, I am getting the below errors:
D:\Program Files\IBM\SQLLIB\BIN>db2 restore db DBTEST load "D:\PROGRA~1\EMCNET~1\nsr\bin\libnsrdb2.dll" open 1 sessions options @"D:\PROGRA~1\EMCNET~1\nsr\apps\config\nmda_db2.cfg"
SQL2062N An error occurred while accessing media
"D:\PROGRA~1\EMCNET~1\nsr\bin\libnsrdb2.dll". Reason code: "0".
Can anyone suggest something...?
Reply

nmc2
268 Posts
6682
0
Posted March 18th, 2015 05:00
Verify if the file "/usr/lib/libnsrdb2.so" exists on the client machine.
You can use this command,
file /usr/lib/libnsrdb2.so