473,327 Members | 2,069 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,327 software developers and data experts.

production and qa

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
replicating the production databases on to the qa server.
Please help.
Yasaswi
Nov 12 '05 #1
7 1846
Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


I'd simply restore the latest production backup of each database. If you
need to change paths for any tablespaces then you'll need a redirected
restore : otherwise a simply restore will do the job.

Phil
Nov 12 '05 #2
Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


Backup/Restore ?

Jan M. Nelken
Nov 12 '05 #3
Simplest for this would be a weekly restore. The backups should already be
in place.
(The admin client is not necessary for this.)
"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google.c om...
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
replicating the production databases on to the qa server.
Please help.
Yasaswi

Nov 12 '05 #4
Hi Phil:
By redirected restore, do you mean I have to give the filesystem
directory path of where the tablespaces will be on the QA server, on
the command line? Please explain.
Thanks,
Yasaswi

Philip Nelson <te*****@scotdb.com> wrote in message news:<04**********************@news.easynews.com>. ..
Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


I'd simply restore the latest production backup of each database. If you
need to change paths for any tablespaces then you'll need a redirected
restore : otherwise a simply restore will do the job.

Phil

Nov 12 '05 #5
You can't replicate the production database on another server with the
admin client. You'll need DB2 UDB ESE installed on the QA server also.

Larry Edelstein

Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


Nov 12 '05 #6
Let us assume "ServerA" is the production DB2 node and "ServerB" is
the QA DB2 node. Then do I do "catalog tcpip node ..." on ServerA or
on ServerB?
The reason I say this is when I run "db2 restore db productiondb..." I
need to be connected to the target instance, but then if I catalog the
qa instance on production server then when running db2 restore, the
production server will be overloaded right? Please help.
Thanks,
Yasaswi

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message news:<fo********************@rogers.com>...
Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


Backup/Restore ?

Jan M. Nelken

Nov 12 '05 #7
On Server A, you catalog the Server B as:
DB2 CATALOG TCPIP NODE serverB REMOTE <what resolves to its IP address>
SERVER <its listening entry port>

On Server A, you backup your db to some Target.
On Server A, you : DB2 ATTACH TO serverB user .... using .....
On Server A, you: DB2 RESTORE DB <dbanme> FROM Target

If you "stay" on Server A, you need to attach to the remote instance
that holds your QA system.
HTH, Pierre.
Yasaswi Pulavarti wrote:
Let us assume "ServerA" is the production DB2 node and "ServerB" is
the QA DB2 node. Then do I do "catalog tcpip node ..." on ServerA or
on ServerB?
The reason I say this is when I run "db2 restore db productiondb..." I
need to be connected to the target instance, but then if I catalog the
qa instance on production server then when running db2 restore, the
production server will be overloaded right? Please help.
Thanks,
Yasaswi

"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in message news:<fo********************@rogers.com>...
Yasaswi Pulavarti wrote:
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
replicating the production databases on to the qa server.
Please help.
Yasaswi


Backup/Restore ?

Jan M. Nelken


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #8

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

Similar topics

5
by: Theodore Feldman | last post by:
Hi, Our DBA group is debating production release methodology. We always perfect our deployment package (typically a script) against the database in a Staging environment, before executing the...
5
by: Bill Willyerd | last post by:
I have been looking for some documentation that would support or reject my opinion on Production -vs- Development naming conventions. I believe that each environment should be housed on separate...
3
by: Bill Willyerd | last post by:
Hello All, I have been searching for a published document for Best Practices concerning access levels based on roles. Should developers have more than (if at all) select level access to...
6
by: Klaus Jensen | last post by:
Hi! I have a pretty traditional setup where I develop on my local PC and the use "Copy Project" to deploy to the production enviroment.. In web.config I need different values for...
1
by: bay_dar | last post by:
We are wondering what is the best way to go about managing production and development versions of our ASP.NET applications. We often publish a production version of a .NET application but then we...
4
by: RedHair | last post by:
Development: Windows 2003 Production :Windows 2003 ASP.NET 2.0 + C# I want to disable the cache feature of all pages in dev but enable it in production environments. What's the solution? If...
8
by: James | last post by:
Say I have a project that I have hosted locally. I have a separate machine which is our production environment. To do our deploys, we've been copying/pasting the folder from our local machines...
2
by: gsauns | last post by:
Hello, I have just put a new virtual server in place that I intend to make my development server. I would like to develop and test on that new server, and host my production apps on my...
3
by: =?Utf-8?B?bG10dGFn?= | last post by:
We have developed a number of different applications (ASP.NET web site, Windows services, DLLs, Windows forms, etc.) in C# 2.0. We have developed and unit tested all these applications/components...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.