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?
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.