View Single Post
  #1 (permalink)  
Old 07-01-09, 10:17
ranjandba ranjandba is offline
Registered User
 
Join Date: Mar 2006
Posts: 20
db2 replication setup basic simple steps through command

current task - setup sql replication 2 db2 servers. difficulty i m facing (replication through gui control centre is pretty slow.) new to db2

can any body help in explaining in simple steps how to setup replication throguh command line.

to make it simple i've the below env db2 on unix enviorment.

have server A , database dbsource , table A column a
server B , database dbdestination , table A column a.

wanted server B should get sync with server A every 5 miutes.

question -
#1> is it possible to setup replication through command line ie syntax

#2> what are the steps i need to do ie what sould be my first step , 2nd step etc ,if i want to setup throguh command line.

#3> is it possibel to write SP / avaiable , which will take input parameter (source server,db,table , destination server,db,table etc )& will setup the repication.

#4> how to create monitoring jobs which will check & alert if replication is in sync ?

appriciate you're time & inclination help ...hope to get a solution.

thanks
ranjan
Reply With Quote