AndraRadu
Follow / 27 Jan 2017 at 10:33am / Toad for IBM DB2

Problem with replication

Expand content
Hi guys, I have a question regarding db2 replication. Maybe you can help me.. I have a table replicated from database A to database B. Right now, I am trying to add a new column to the table, called...

Hi guys,

I have a question regarding db2 replication. Maybe you can help me..

I have a table replicated from database A to database B.

Right now, I am trying to add a new column to the table, called PROPOSAL_SENT, with default value 'N'.

I register the new column for replication, and after I start back replication, I want to make an update on the table from db A: to update the value of N to be Y for some rows.

The changes apply successfully on db A, but on db B, replication instead of moving the Y values, replaces the N with - .

And I cannot figure it out what is happening.

Thanks in advance for any thought. :(

Unanswered 502 0 / Create an account to join the discussion.
Steve Hilker
Follow / 5 Nov 2013 at 5:18pm / Toad for IBM DB2
Latest post by on 3 Jan 2017 at 4:28am

Welcome

Expand content
Welcome to the Spotlight on DB2 LUW forum. This forum is for discussing any and all aspects of Spotlight on DB2 LUW. Have a question? Ask it here. Something been on your mind about Spotlight and you're...

Welcome to the Spotlight on DB2 LUW forum.  This forum is for discussing any and all aspects of Spotlight on DB2 LUW. Have a question?  Ask it here.  Something been on your mind about Spotlight and you're wondering what others think?  Again, post it here for general discussion.  This forum your place to ask questions, share your experiences, and hopefully have a little fun, too.

We look forward to your participation!

Steve Hilker
Toad World Admin

11848 1 / Create an account to join the discussion.