Results 1 to 4 of 4

Thread: Replication

  1. #1
    Join Date
    Sep 2005
    Posts
    5

    Unanswered: Replication

    I added a column to a table which is being replicated. Will that column be reflected at the target? If not, how can I achieve this??

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    No. If you saved the scripts used to create the replication, then you can see where each column is defined separately. If you did not save the scripts, you could generate a new replication scenario on a test machine and look at the scripts before they are submitted by the GUI interface. You will also need to add the column to the target table.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    replication

    it can be done manually - if you know the tables and their layout
    it should be added to the capture tables - the cd tables should be changed..
    it should be added to asn.ibmsnap_subscols...
    Use the gui of replication center if not familiar with manual procedure
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by przytula
    it can be done manually - if you know the tables and their layout
    it should be added to the capture tables - the cd tables should be changed..
    it should be added to asn.ibmsnap_subscols...
    Use the gui of replication center if not familiar with manual procedure
    That is what I said. It is not done automatically.

    What I suggested was to create a new replication scenario (if the old scripts were not saved), and look at what the GUI does (Show SQL) to figure out what needs to be done manually fo each column. Or one can delete the old definitions and start over.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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