472,783 Members | 1,073 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,783 software developers and data experts.

What is wrong with this Redirected restore command - UDBv8.2 fp14 on Linux

Hi all,
This is a very urgent issue for my team. We are trying a Redirected restore the most current online DB2 UDBv8.2 backup copy from

prod disk to disk on another/test instance. Our environment is RedHat Linux. We have tried the following with failure: (1)

[db2prd1@aaanpudb1 /]$ db2 restore db AANPDM01 from "/stuff/ftp/bkp" taken at 20070525164103 to "/dmd/data" into AANNDM01

NEWLOGPATH "/dmt/log" redirect without rolling forward;

SQL1052N The database path "/dmd/data" does not exist.

Note: "/dmd/data" does not exist in the source DB2 Linux Production environment but categorically exist in the target DB2 Linux

Test environment. What I need is to restore restore from production to test.
[db2prd1@fsfnpudb1 /]$ <== prod_instance_DB
[db2inst1@target_server <== systest_instance_DB

(2) We then tried to sFTP the backup image copy to the test environment but not having much luck either. We got repeated failure

with this message:

sftp> put FSNPDM01.0.db2prd1.NODE0000.CATN0000.2007092504450 6.001
Uploading AANPDM01.0.db2prd1.NODE0000.CATN0000.2007092504450 6.001 to

/db2home/db2inst1/AANPDM01.0.db2prd1.NODE0000.CATN0000.2007092504450 6.001
AANPDM01.0.db2prd1.NODE0000.CATN0000.2007092504450 6.001 12% 3972MB 4.2MB/s 1:54:37 ETA. Couldn't write to

remote file
"/db2home/db2inst1/FSNPDM01.0.db2prd1.NODE0000.CATN0000.2007092504450 6.001": Failure ID mismatch (127219 != 3)

Could any of our redirected restore gurus please step in and shed some light on this technical matter! This will be highly



Sep 26 '07 #1
1 2448
In your redirected restore command you should not specify TO CLAUSE unless the target database is not existing
If you are restoring to an existing database you should not mention that
Remove to "/dmd/data" from your restore command and try again, it will work

For the sftp problem either there are not enough permissions to write to the target directory or the space is exhausted
Sep 26 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: hvaisane | last post by:
Valgrind says ==11604== Invalid read of size 4 ==11604== at 0x8048ABB: main (foo.cc:36) ==11604== Address 0x1B92415C is 4 bytes inside a block of size 8 free'd ==11604== at 0x1B90514F:...
by: Frank Stefani | last post by:
Hi, due to an upgrade from a former DB2 v7.02, I backed up an entire database to a file in the local filesystem under Linux. I removed the old version completely an installed a fresh v8.1 DB2....
by: db2inst2 | last post by:
Hi all, I did a redirected restore into a new DB in the same instance, I get the following error message in db2diag.log right after doing that. The new DB that i restored to is working fine. ...
by: CCC via DBMonster.com | last post by:
We use redirected restore to refresh test from prod on different AIX 5.2 servers. The databases have the same number, size and names of cooked containers. The only difference is the fully qualified...
by: Kent.Brooke | last post by:
When a backup is taken from server a and then redirected restore is done on server b, the tables and data is fine however db2advis says "explain & advise tables not created for user x properly"....
by: P. Adhia | last post by:
Hello All, I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x) on DB2 V8.2 system (AIX 5.2). I get the above error with no other details. db2diag.log has a series of error...
by: Raj | last post by:
How can we restore a tablespace from a Full backup to a new tablespace with out effecting the existing tablespace.. (can we use the redirect option in the backup command for tablespace recovery...
by: okonita | last post by:
Hi all, My environment is DB2 UDBv8.2 on Windows and Linux. I am getting a lot of errors on the script you see below. Some of the error I am geting are: ...
by: Kofa | last post by:
Dear All, I'd like to know whether it is possible to restore backups created on a production machine, running DB2 9.1 on Windows, using DMS table space containers, onto a developer's machine,...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.