Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17

    Unanswered: DB2 UDB -Replication

    Dear -alls,
    In my Database there are few tables which have'nt any Key column/s, and when i go for replication then found its Mandatory to have a key column in a table to which I want to replicate - (DB2 UDB 7.2 replication scenario)- so if anyone here have any solution ? - i mean, i suppose to add key column in table or there is another way to do replication without it.
    any help or guidance in this regard really appreciate.
    Thank You.
    A.Dee

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96

    Re: DB2 UDB -Replication

    Originally posted by ADee
    Dear -alls,
    In my Database there are few tables which have'nt any Key column/s, and when i go for replication then found its Mandatory to have a key column in a table to which I want to replicate - (DB2 UDB 7.2 replication scenario)- so if anyone here have any solution ? - i mean, i suppose to add key column in table or there is another way to do replication without it.
    any help or guidance in this regard really appreciate.
    Thank You.
    No, you really need a primary key or a unique index on the table you want to replicate. If you update a row in the source database DB2 needs to know which row should be updated in the target database which isn't possible without a unique key.

    Kind regards, Gert

Posting Permissions

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