Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    11

    Unanswered: Can DB2 Sequences be replicated in Q replication

    We have a requirement to determine the last Assigned value of a DB2 sequence.The sequence is used by multiple tables & we can't replicate all of them. I can get these values from sysibm.syssequences, however replicating this table is not allowed in any OS except z/os (we have AIX 6.1). Is there any way that I can replicate a Db2 sequence?

  2. #2
    Join Date
    Apr 2014
    Posts
    11

    Q Replication

    We have a requirement to replicate only ID column from multiple tables. All these columns are using same sequence. Is is possible to replicate data from multiple tables to one target tables?

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Not trying to be rude, but of what benefit could that be to you? You state that you are using this same sequence for some tables that you do not replicate on your target, so there will be lots of holes in your sequence on the target. I can't figure out why you would care what the last/next sequence would be.
    Other than that the only way I can see to do it would be to add additional processing to all of your processes that use the sequence.
    Dave

Tags for this Thread

Posting Permissions

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