Dear Friends
Let me explain my problem clearly
1. My Database is running on DB2 v8.1.10.812 Fix pak 10 on Windows 2000
sp1
2. We are using Legato Db2 module for doing backup and restore.
3. we successfully implement backup by using legato db2 network server
But we are facing problem when we are trying to do restore command.
I try to restore with the following two commands:
1) C:\IBM\SQLLIB\BIN>db2 restore db QMAPP_BK load C:\Program
Files\Legato\nsr\bin\
libnsrdb2.dll
error :
--------
SQL0104N An unexpected token "Files\Legato\nsr\bin\libnsrdb2.dll" was
found
following "<identifier>". Expected tokens may include: "TO".
SQLSTATE=42601
2) C:\IBM\SQLLIB\BIN>db2 restore db QMAPP_BK use xbsa
Error:
---------
SQL2062N An error occurred while accessing media
"C:\IBM\SQLLIB\bin\db2xbsa.dll". Reason code: "-2072".
Could any one explain me how to do restore from the legato network
server.
Appreciate your help
Cheers :)
Satish.v.sh
Ralph Ganszky - 30 Jul 2006 10:10 GMT
> Dear Friends
>
[quoted text clipped - 38 lines]
>
> Satish.v.sh
Hi,
you have to use the load <lib> syntax afaik. But you should use the 8
character notation of the path; probably
load C:\Progra~1\Legato\nsr\bin\libnsrdb2.dll
The blank in the path confuses the command line parser.
Cheers
Ralph