473,543 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Relocate DB2 databases part 2

Hi, thanks already for your info in a previous post Ian, Dave and Gert.

What I understood from your answers (and believe me when I tell you I know
nothing about DB2) the best and easied way to move the databases is to
backup both databases, stop the database server (db2stop force), move (or
should I copy?) the entire folder c:\db2 to the d-drive and start the
database server (db2start).

Then goto the DB2 command line processor and issue the command
"db2relocat edb -f c:\temp\relocat e.cfg".

The content of the relocate.cfg file should be:

DB_NAME=DATABAS EA
DB_PATH=C:,D:

After running this command, issue the same command, but change the DB_NAME
to DATABASEB.

Am I correct?

Sorry for asking, but it is very important both databases will work like
before with everything in it, only on a d-drive and not on the c-drive.

Kind regards,

Frank
Mar 15 '06 #1
1 1669
Raj
easiest way is to redirect restore

You can restore a DB2 backup and redirect it into another DB2 database
that is running under the same type of operating system. The DB2
command statements required to perform a redirected restore are:

One DB2 RESTORE DATABASE INTO command
One SET TABLESPACE CONTAINERS command for each table space in the
database
One DB2 RESTORE DATABASE CONTINUE command.

checkout this link
http://www-128.ibm.com/developerwork...2mulligan.html

Mar 16 '06 #2

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

Similar topics

2
1878
by: wimmie | last post by:
Hello to all, I have a 'small' problem. I have made a application in php that connect trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present the data to a user. There are 2 Oracle databases in diffrent city's and 5 Basis+ databases allso in diffrent city's. Now we have to logon to each database and can ask a question. My...
1
1478
by: ChrisA | last post by:
Hi all, we are developing an internal application that involves "Timesheets", "Support" and "Project Management". Imagine that there are 3 different databases for the above scenario, under SQL Server 2000. My task is to create one or a few table triggers for INSERT/UPDATE/DELETE operations. For example: - if a row is added in Table A of...
0
2159
by: nick | last post by:
In the following link, the screen has a lot of refresh (iframe keep relocate its position ) when the mouse hover around the popup menu. But IE doesn't have the problem. http://greywolfdesign.com/tmp/projects/sylvan%20way/ProjSylvan.htm The flashing doesn't occur after I remove the iframe in the html code. Any clue?
3
4608
by: mike.cutts | last post by:
Hi, I have a website which, when search results are returned to engines, displays a site description of "Relocate" instead of the correct TITLE tag. I'm not sure why it's doing this so any help would be appreciated. For info, you will be able to see the problem by searching for www.wiseowlsolutions.com on AltaVista.com Thanks,
49
3274
by: Mike MacSween | last post by:
I frequently hear that there isn't a commercially available dbms that fully implements the relational model. Why not? And which product comes closest. Mike MacSween
7
24671
by: Altemir | last post by:
I want to create an UPDATE statement that updates a value in a table in database A based on the results of an inner join between tables each residing in deifferent databases. What is the correct syntax for doing this? The following should give you an idea of what I'm trying to do: UPDATE A.dbo.tblCars SET A.dbo.tblCars.Car = 'Ferrari'
3
2786
by: Frank | last post by:
Hi, I have two databases in DB2 v8.2 (Windows 2003 Server platform) and right now both databases are on my c-drive. Unfortunately space on this drive is becoming low and I want to relocate the databases to my d-drive. You can change properties of an instance (default database path), but this applies to new databases.
6
1460
by: Alfred | last post by:
If you're a PHP fan like I am, I have a word of advice. Don't live where I have relocated near Myrtle Beach, South Carolina, USA. It's probably the most backward place on the planet, where IT workers are not respected, are highly underpaid, and gigs are few and far between. I used to work in Raleigh, NC (the Research Triangle area) USA and...
8
2735
by: situ | last post by:
Hello all, i have Database1 and database2, is it possible to make database connection to database2 by running stored procedure on database1. Thanks and Regards Situ
0
7412
marktang
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...
0
7594
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. ...
0
7746
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...
0
5889
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...
1
5285
isladogs
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...
0
3394
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...
0
3394
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
979
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
648
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...

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.