Results 1 to 5 of 5

Thread: DB2 replication

  1. #1
    Join Date
    Feb 2003
    Posts
    49

    Unanswered: 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

  2. #2
    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

  3. #3
    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...

  4. #4
    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

  5. #5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •