473,385 Members | 1,769 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

how to restore the existing production db in development environment

1
Hi guys ,

We have the existing db2 db in production ,

we want to restore the production database in development environment ,

db2 V8.2

Please provide me the procedure.
Apr 26 '13 #1
3 1989
db2move dbname export
Apr 26 '13 #2
vijay2082
112 100+
If your servers os and type is same then you can go for direct restore. Else use db2move export/load option to move between server which have different endianess.

http://publib.boulder.ibm.com/infoce...e/r0001976.htm

Cheers, Vijay
Apr 27 '13 #3
iwaich
1
If the your production environment is same as your developement evironment, you can use restore, it's very easy.

Step 1: get a backup image from you production database.
---> db2 backup db <db_name>

Step 2: Transfer this image from you production database to developement environment.
then use command --> db2 restore db <db_name>
May 16 '13 #4

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

Similar topics

4
by: xo55ox | last post by:
Hi, Currently, I am on SQL2000 SP3 and Windows 2003. I am trying to restore the full database backup and transaction log backup on the development server. The full database restore is not a...
0
by: Sherman Alpert | last post by:
Agile Development Conference Salt Lake City, Utah, USA June 25-26, 2004 www.AgileDevelopmentConference.com Call for Research Papers The Agile Development Conference is an integrated, 4-day...
1
by: Raquel | last post by:
Had a simple question..there is a command in UDB: RESTORE DB a TAKEN AT ts1 INTO b Where 'a' is one database, 'b' is another database and ts1 is a timestamp in the past when database 'a' was...
7
by: Yasaswi Pulavarti | last post by:
I have three instances with a database each on a production server. I need to replicate the databases on a qa server once a week. I installed administration client on qa server. How do I go about...
3
by: Omar Vazquez | last post by:
i'm trying to restore a backup that olriginaly was made from a server (production). I want to get data into a new server(development). Does somebody know about a guide to get some information?,...
0
by: RaynorClement | last post by:
I have a situation that someone delete some records on a table in the production system. The production current setup on a win2003 server with mirrorlogpath = "\\backup\logs", and logretain =...
3
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...
4
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...
1
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...
1
by: okonita | last post by:
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
0
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,...

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.