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 > Replication

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-22-05, 14:44
toniblair toniblair is offline
Registered User
 
Join Date: Sep 2005
Posts: 5
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??
Reply With Quote
  #2 (permalink)  
Old 09-23-05, 00:00
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
  #3 (permalink)  
Old 09-24-05, 14:07
przytula przytula is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 09-24-05, 14:21
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
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