Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2012
    Posts
    6

    Unanswered: update table after replication

    Hi ,
    i manually updated source tables in the source database after replication , but changes do not affect target tables.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    DB2 version+fixpack?
    What kind of replication? (sql-replication, q-replication, other...) ?

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you be more specific and provide more details
    with this 1 sentence we (I) have no idea what you are doing or what is the problem
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Jun 2012
    Posts
    6
    i used sql-replication.
    i have TS_AUTH named table in source database. i replicated this table to target database. Then, i want to update TS_AUTH table. i add a row to this table but, adding row is not affected to replicated table.

  5. #5
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Is Capture running at the source database?
    Is apply running on the target database?

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    how did you replicated the table ? full refresh - manual -automatic ?
    status of subscription ? active ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Jun 2012
    Posts
    6
    capture running source database,apply is in the target database.
    i don't have any information about full refresh (automatic or manual).

  8. #8
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Do you see your update in the corresponding change data table at the source?
    What information appears in the capture log file and in the apply log file?

  9. #9
    Join Date
    Jun 2012
    Posts
    4

    adds the column

    In SQL Server 2000, you'll use the sp_repladdcolumn stored procedure to feature a column to a replicated table while not reinitializing the whole publication as a result of the stored procedure automatically adds the column at the mainframe testing. for instance, if the authors table within the Pubs database has already been printed, you'll add the newcol integer column to that table by executing the subsequent stored procedure:
    sp_repladdcolumn @source_object =
    'authors'
    , @column = 'newcol'
    , @typetext = 'INT'
    , @publication_to_add = '<name
    of publication authors is
    included in>'
    Last edited by ashee1; 06-24-12 at 15:00.

Posting Permissions

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