Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Restore DB2 from DB2 Legato Network Server

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
V_S_H_Satish - 30 Jul 2006 07:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.