If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 replication

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-29-04, 02:16
asha192 asha192 is offline
Registered User
 
Join Date: Feb 2003
Posts: 49
DB2 replication

HI,

I am not able to add control servers through replication center. However if I use the Custom option, I am able to do it....

But my replication is not working, the data is getting captured but not getting copied to my destination database

Thanks in advance
Reply With Quote
  #2 (permalink)  
Old 11-29-04, 02:32
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
replication

many reasons ..
if data is getting captured, full refresh has already run
apply qualyfier is case sensitive
start apply with trace
asnapply control_server=xxx apply_qualyfier=xxx trcflow > trace.out
and check - maybe this is more clear
has password file been created for all databases ?
Best Regards, Guy Przytula
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
Reply With Quote
  #3 (permalink)  
Old 11-29-04, 02:46
asha192 asha192 is offline
Registered User
 
Join Date: Feb 2003
Posts: 49
replication

Yes, i have created the password file...while starting the apply program thru replication centre it asks me for the password....

but there is some error and data is not getting replicated...
Reply With Quote
  #4 (permalink)  
Old 11-29-04, 02:56
Romeo Romeo is offline
Registered User
 
Join Date: Feb 2002
Location: Philippines
Posts: 41
maybe you can provide us with more details to work on
__________________
There are 10 kinds of people,
those who know binary and those who don't.

http://www.linkedin.com/in/rtitong
Reply With Quote
  #5 (permalink)  
Old 11-29-04, 05:54
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
replication

as indicated before : start apply from command window and add trcflow at the end and re-route output to file
this will reveal the error
asnapply apply_qual= apply_qualifier control_server= db_name apply_path= pathname pwdfile=filename trcflow
Best Regards, Guy Przytula
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On