SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:12 AM
| ||||
| ||||
 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      |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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 |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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 |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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" <yasaswi@encfor.com> wrote in message news:aa862233.0411061138.6f77a5d6@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 |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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 <teamdba@scotdb.com> wrote in message news:<04bjd.3992923$ic1.391871@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 |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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 |
|
02-27-2008, 02:12 AM
| |||
| |||
| Re: production and qa 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" <Unknown.User@Invalid.Domain> wrote in message news:<foGdndpvBaapoxDcRVn-rQ@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 |
|
02-27-2008, 02:12 AM
| ||||
| ||||
| Re: production and qa 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" <Unknown.User@Invalid.Domain> wrote in message news:<foGdndpvBaapoxDcRVn-rQ@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. |
Linear Mode
