Cannot redirect restore into a different database name.

sharon.zhang.ca

Hi,

I'm using the following command to redirect restore from source
database AAA into target database BBB:

db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without rolling forward

Why does it always restore into AAA instead of BBB? What's wrong with
my command?

Thanks.

Jun 27 '08 #1

Subscribe Reply

4730

Lennart

On May 13, 2:13 pm, sharon.zhang... @gmail.com wrote:

Hi,

I'm using the following command to redirect restore from source
database AAA into target database BBB:

db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without rolling forward

Why does it always restore into AAA instead of BBB? What's wrong with
my command?

Not sure what redirect into means. Here is how I normally do what you
describe:

db2 restore db AAA from /DBBACKUP taken at 20080512100655 into BBB
redirect without rolling forward
/Lennart

>
Thanks.

Jun 27 '08 #2

Larry

Does the target database already exist? It is unique on the target system?

Larry E.

sh************* @gmail.com wrote:

Hi,

I'm using the following command to redirect restore from source
database AAA into target database BBB:

db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without rolling forward

Why does it always restore into AAA instead of BBB? What's wrong with
my command?

Thanks.

Jun 27 '08 #3

simon.tran.ca

On May 13, 11:09*am, Larry <la...@nospam.n etwrote:

Does the target database already exist? It is unique on the target system?

Larry E.

sharon.zhang... @gmail.com wrote:
Hi,

I'm using the following command to redirect restore from source
database AAA into target database BBB:

db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without rolling forward

Why does it always restore into AAA instead of BBB? What's wrong with
my command?

Thanks.- Hide quoted text -

- Show quoted text -

Try something like this:

RESTORE DATABASE AAA FROM /DBBACKUP taken at 20080512100655 TO /
Newlocation INTO BBB REDIRECT WITHOUT PROMPTING

-- Use list tablespace containers commands to obtain a list of
containers
-- Change the directory for the containers for the new location.
--

SET TABLESPACE CONTAINERS FOR 0 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT0000.0")

SET TABLESPACE CONTAINERS FOR 1 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT0001.0")

SET TABLESPACE CONTAINERS FOR 2 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT_U4K_TMWIN. 0")

SET TABLESPACE CONTAINERS FOR 3 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT_U8K_TMWIN. 0")

SET TABLESPACE CONTAINERS FOR 4 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT9001.0")

SET TABLESPACE CONTAINERS FOR 5 USING (PATH "/DB2/NODE0000/SQL00003/
SQLT9002.0")

SET TABLESPACE CONTAINERS FOR 6 USING (PATH "/DB2/NODE0000/SQL00003/
SYSTOOLSPACE")

RESTORE DATABASE AAA CONTINUE

ROLLFORWARD DATABASE BBB TO END OF LOGS AND COMPLETE OVERFLOW LOG PATH
(/DB2BAK/DB2LOGS/DB2/GRIMSHAW/NODE0000/C0000001)

Jun 27 '08 #4

Similar topics

5709

How to restore a log? Now we get an error

by: Rene | last post by:

Hi, While restoring the log we receive a message after about 30 minutes: Processed 1152109 pages for database 'restest', file 'sales_Log' on file 1 Server: Msg 9004, Leverl 21, State 20, Line 3 An error occurred while processing the log for database ' '. It is unclear why the databasename is an empty string, I guess there must be

Microsoft SQL Server

2080

Restore DB procedure - date parameter

by: barbara | last post by:

I am using this procedure from net for getting the restore script. It lists the latest full backup file name and logs after that point. Is there any way to modify this script to take either date or time as parameter and give the files for restore? I need this if I need to restore the data up to last week/upto some point of time. CREATE procedure usp_what_files_to_restore as --

Microsoft SQL Server

5483

Cannot use mail() in IE, only works in a debugger--help

by: baustin75 | last post by:

Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I debug it in PHP designer, it works with no problems, I get the test email. If

PHP

5596

Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

by: Smutny30 | last post by:

Hello, I am preparing a database that will store 10 n * GBs - 100 n * GBs of data. I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on 4 GB box. I obtain : "SQL1478W The defined buffer pools could not be started. Instead, one small

DB2 Database

13587

Redirected restore problem

by: Chris | last post by:

I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the productions server are on the d drive and my test server has no d drive. The restore command i am using is: RESTORE DATABASE CENTRAL FROM "C:\DB2Backups" TAKEN AT 20050620000000 INTO CENT0620 REDIRECT;

DB2 Database

4325

Restore database from v7.2 to v8.2

by: chow.justy | last post by:

Dear all, I'm a new beginner of DB2. I face 2 question during restore the data. I have 2 DB2 servers on my company. Server A is running on V7.2 and Server B is running on v8.2 (Enterprise Server). I backup a database from Server A and restore it on Server B. Question 1) "SQL2542N database name is not match on the source file" error

DB2 Database

5762

Cannot restore after Veritas Netbackup restores

by: africantract | last post by:

Hi There, We have an issue on our db2 restores. We do database dumps every night, and restore them to development servers every morning. This works fine with no errors. However if we backup those images to tape using Veritas netbackup, and then restore those images and try to restore them to the database, we get "The backup image is corrupt". If we run db2ckbkp against that image we get "Unable to decompress image from different platform"....

DB2 Database

4104

The Question about REDIRECT RESTORE

by: zhif | last post by:

I tried to test this process on my personal laptop. Could you help me to take a look where is the problem as below? 1. I created a source database, name: db100 <-- db2 create db db100 2. Collect the source database tablespace containers’ information <-- db2 list tablespace containers for 0 show detail Then I got as below Tablespace Containers for Tablespace 0 Container ID = 0 Name ...

DB2 Database

7325

Restore a database to another server

by: Seguros Catatumbo | last post by:

Hi, i am using sql server 2000, and i make daily backups. I want to restore my backup to a test msde database i have. I don't know how i did it last time. -The database name is the same: "web" on both places -The database is located on different hard drives and the file name are different on both places. I tried to do it from enterprise manager, restore database, from device, i chose the transaction file and the database backup itself

Microsoft SQL Server

9641

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9944

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

8968

AI Job Threat for Devs

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...

Career Advice

7494

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5378

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4044

transfer the data from one system to another through ip address

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

C# / C Sharp

3643

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2875

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General