can I restore a database from one system to another?

anna_cheng11

We do not have a DBA available, and this is a development environment,
hence I was asked to do the work. I am not a DBA. I need some help to
clarify my understanding of DB2 recovery and I am reading the following
as well.
http://publib.boulder.ibm.com/infoce...help/index.jsp
I have a database say DB_INV on machine A and the database is backed
up to tape, I am going to create a second system, say machine B with a
database called DB_INV which is empty, can I run the db2 restore
command to restore from tape the database DB_INV from machine A to
machine B?

With the exception of running the db2 restore command, are there
anything that I need to do to ensure
a. the database on machine B is identical to the database on machine
A? identical to the time the backup was created. Assuming the backup is
run via "db2 backup db" command, do I need to recover the data
dictionary, catalogue etc?
b. Are there any commands I can use to ensure the restore is
successful? or that as long as there is no error at the end of the
restore?
c. I assume the db2 restore command will just overwrite whatever I
initially created as an empty database on machine B and create the
necessary tablespace, data dictionary, etc, right?
d. After the restore is finished, can I just run db2start to bring up
the database on machine B even machine A with DB_INV is up at the same
time? Will there be any conflict etc ? (say my experience as a SA, I
cannot bring up two machines with the same hostname and IP on the same
segment, will I have similar problem after the database restore).

As far as the command line is concerned, can I just use
db2 restore db DB_INV from some_directorie s with 4 buffers buffer 512
replace existing parallelism 4 without prompting;
Or do I need to use
db2 restore db DB_INV into DB_INV from some_directorie s with 4 buffers
buffer 512 replace existing parallelism 4 without prompting;
thanks
anna

Nov 12 '05 #1

Subscribe Reply

4135

RealMaroon

an**********@ya hoo.com wrote:

We do not have a DBA available, and this is a development environment, hence I was asked to do the work. I am not a DBA. I need some help to
clarify my understanding of DB2 recovery and I am reading the following as well.
http://publib.boulder.ibm.com/infoce...help/index.jsp
I have a database say DB_INV on machine A and the database is backed
up to tape, I am going to create a second system, say machine B with a database called DB_INV which is empty, can I run the db2 restore
command to restore from tape the database DB_INV from machine A to
machine B?

With the exception of running the db2 restore command, are there
anything that I need to do to ensure
a. the database on machine B is identical to the database on machine
A? identical to the time the backup was created. Assuming the backup is run via "db2 backup db" command, do I need to recover the data
dictionary, catalogue etc?
b. Are there any commands I can use to ensure the restore is
successful? or that as long as there is no error at the end of the
restore?
c. I assume the db2 restore command will just overwrite whatever I
initially created as an empty database on machine B and create the
necessary tablespace, data dictionary, etc, right?
d. After the restore is finished, can I just run db2start to bring up
the database on machine B even machine A with DB_INV is up at the same time? Will there be any conflict etc ? (say my experience as a SA, I
cannot bring up two machines with the same hostname and IP on the same segment, will I have similar problem after the database restore).

As far as the command line is concerned, can I just use
db2 restore db DB_INV from some_directorie s with 4 buffers buffer 512
replace existing parallelism 4 without prompting;
Or do I need to use
db2 restore db DB_INV into DB_INV from some_directorie s with 4 buffers buffer 512 replace existing parallelism 4 without prompting;
thanks
anna

Nov 12 '05 #2

RealMaroon

Anna ,

have you some more detail
System A / System B Operating system
Are the systems equally resourced in terms of disk

Nov 12 '05 #3

Similar topics

13987

Problem with redirected restore

by: GL | last post by:

I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was encountered on device "TBS_IDX". Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) t

DB2 Database

7778

restore database to another server failed

by: Andy J | last post by:

Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2, Modification: 5, Service Level: WR21294 Querying the system... Windows 2000 Version

DB2 Database

1302

restore to another machine fialed

by: Andy J | last post by:

DB2 Database

7279

problem with a restore maybe ...

by: Andy K | last post by:

Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I then restore the backup without creating a database with the simple command line "db2 restore backup DBNAME".

DB2 Database

13540

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

2506

Online backup to restore onto another system (or for disaster recovery): how to?

by: Konstantin Andreev | last post by:

Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple question. I need to perform the full database backup for at least these two goals: - to restore data onto developers' database system. - to ensure disaster recovery

DB2 Database

5735

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

4981

Backup in Db2 Linux and Restore in DB2 Windows

by: abelbfilho | last post by:

I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure: D:\DADOSADV.0\db2\NODE0000\CATN0000\20060812\ and rename the backup image file to 230006.001 When I type (Prompt DOS) db2ckbkp -H 230006.001 and I receive this result ===================== MEDIA HEADER REACHED:

DB2 Database

5218

Unable to restore DB2 Database on Linux

by: mlaris | last post by:

Howdy, We are experiencing a bizarre problem under Linux attempting to restore a DB2 database. The backup was created on this machine, and is being restored to the same machine, but changing the name of the database, and redirecting the tablespaces. The system is running DB2 Express C V9.5 and RHEL5 with latest updates The restore commands we are trying to run are as follows: RESTORE DATABASE CARDS FROM "/opt/rccs/data/backups"...

DB2 Database

8402

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

8829

Problem With Comparison Operator <=> in G++

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

C / C++

8734

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

8508

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

7341

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

4323

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

2733

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

1962

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

1627

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