473,806 Members | 2,654 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Restore DB2 from DB2 Legato Network Server

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\B IN>db2 restore db QMAPP_BK load C:\Program
Files\Legato\ns r\bin\
libnsrdb2.dll

error :
--------

SQL0104N An unexpected token "Files\Legato\n sr\bin\libnsrdb 2.dll" was
found
following "<identifie r>". Expected tokens may include: "TO".
SQLSTATE=42601

2) C:\IBM\SQLLIB\B IN>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

Jul 30 '06 #1
1 4122
"V_S_H_Sati sh" <sa************ *@gmail.comwrot e in message
news:11******** *************@b 28g2000cwb.goog legroups.com...
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\B IN>db2 restore db QMAPP_BK load C:\Program
Files\Legato\ns r\bin\
libnsrdb2.dll

error :
--------

SQL0104N An unexpected token "Files\Legato\n sr\bin\libnsrdb 2.dll" was
found
following "<identifie r>". Expected tokens may include: "TO".
SQLSTATE=42601

2) C:\IBM\SQLLIB\B IN>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
Hi,

you have to use the load <libsyntax afaik. But you should use the 8
character notation of the path; probably
load C:\Progra~1\Leg ato\nsr\bin\lib nsrdb2.dll

The blank in the path confuses the command line parser.

Cheers

Ralph
Jul 30 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2178
by: Ictus | last post by:
Does anyone have expeience of Legato backups in a busy environment? Due to the number of systems we have, we'd like to do a Legato backup every so often, and a log backup to disk (to be copied to a remote machine in case of disk failure) every little while. The aim is to get a backup from which we can recover to 1/2 hour ago or so in the case of total system failure. What does anyone else do to ensure this sort of recoverability, or...
2
2175
by: SD | last post by:
Hi, Quick question, I have about 20 users in my local server and database. We are looking to restore that database to a new server in a new network and still be able to retain the database users. We have created all 20 logins in the new server (exact names) but when we restore the database I do not see the users anymore! Is there something we can do to preserve them or a script we can run to link
0
1294
by: ajit | last post by:
Hi I need to do daily incremental replicatation of MS SQL databases on my 6 branch office servers on my HO server. Presently it will be one way replication from branches to HO. But later we may replicate HO on one of the Branch servers for Dister recovery. Is SQL's own replication facility good enough or would you suggest using Legato Replicator or similar Veritas software.
13
23463
by: | last post by:
Hi I am trying to copy a 20 GB database from server 1 to 2. I took a full backup, copied to server2 and restored ( ready for use) using EM. After the message restore completed, I see the database's status as LOADING. We are on Sql Server 2000 (8.00.818) on Windows 2000 Adv Servers. I ran dbcc on the source DB and it returned no errors. I tried the command 'restore db with recovery ' which didnot help. I get an message saying that
1
1933
by: ILPTAB | last post by:
Hello. Can somebody help me out here? I have a web server sitting on a DMZ that has DB2 UDB version 8 installed running on it. I would like this server to be completely independent of our internal network. If possible, I would like to be able to each morning FTP a copy of the backup image from our production database, which is created from the previous night's db2 backup, to the web server. I am hoping that I
0
1555
by: debian75 | last post by:
Hi. I have two servers in the same MS network area: 1: MS 2000 Server, with an Oracle 9 installed (with license 1), and a DB1. 2: MS 2003 Enterprise R2, with an Oracle 10.2.0.3 installed (with license 2), and a DB2. I want to realize a daemon/script/cmd to backup DB1 to prevent any type of inactivity/anomaly (oracle.exe at 100% during improbable day time, other relevant job that required more system resources) of the server 1, and to...
1
4384
by: micofarmer | last post by:
We are running a PHP web-based frontend with a Postgres 7.2 backend on a Windows 2000 Server box with automated backups of the server being handled by Legato. We are experiencing several problems that point in the general direction of the backup process but we have nothing concrete. The Legato system runs incremental backups Monday through Saturday with a full server backup on Sunday. The problems we are seeing are mainly database...
4
5757
by: Christian Maslen | last post by:
Hi All, I understand in older versions of DB2/UDB this was not possible. The following article explains how I might do this http://www.ibm.com/developerworks/db2/library/techarticle/0207kline/0207kline.html Is this still a restriction in version 9.x? I'd specifically like to restore a backup performed on an AIX server to a Windows server.
4
7929
by: DL | last post by:
Background Info: Instance A: SQL Server 2005 on Windows Server 2003 OS Instance B: SQL Server 2005 on XP Prof w/ SP2 Process: backup a database on Instance A like this: step 1 -- Management Studio for Instance A BACKUP DATABASE myAppNameDB TO DISK = 'c:\Temp\myAppNameDB_FullRecovery.bak' GO
0
10618
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10366
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10371
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10110
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9187
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4329
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3850
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.