Pinned topic DataMirror 6.1 in Iseries, Refresh is OK but problems with mirroring
2013-03-01T14:53:45Z | idr-cdc
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I installed Datamirror 6.1 over Iseries and I have just made a refresh of a table, but when the suscription is running in "mirroring" mode and we insert, delete or update any record in the source table, there is no news in the target table. I have just revised everything but we couldn't find anything wrong. do you have any idea?
Thanks in advance!!!
Updated on 2016-08-14T15:38:58Z at 2016-08-14T15:38:58Z by Ken Motilall
Rphilo 2700013TF4547 Posts
Re: DataMirror 6.1 in Iseries, Refresh is OK but problems with mirroring2013-03-04T12:15:32ZThis is the accepted answer. This is the accepted answer.JorgeThere are a number of possibilities1) The tables are still in active pending status., This happens if you perform mark table capture point- CDC will ignore any changes it scrapes before the time you do the mark table capture point, You can tell if this is the casea) The event log has messages "table xyz is ready to be mirrored" indicates active pending status", instead of "table xyz is being mirrored"b) the event log has messages " mirroring initiated for table xyz" when the time of the mark table capture point is reached in the journlc) If the tables are still in active pending status, you can query <product library/dmfs510p and review the updsts column0 = idle1= refresh2=active pending3-active (capturing changes)4-active ignore (during refresh while active)d) If you display the journal and you see user entries (posted by CDC) of type \C. CDC posts these when mark table capture point is done, so you can read the journal to determine what CDC has done.[CDC also uses \b and \c user entries to mark the start and end of refresh in the journal, so if you only have user entries \c without \b as well, then you have done mark table capture point)2) CDC is starting mirroring from the "wrong" position, i.e. you have manually set the bookmark with SETJRNPOS- the source event log will tell you where it started from3) You are running CDC under commitment control and you have not issued a commit on the source (the target event log will tell you whether CDC is replicating under commit control or not)4) You have disabled CDC operations on the target table (review column mappings/operations tab)5) You have a row filter in place which is not working for mirroring6) You have an error in the target event log or source event log7) You have a user exit on the target side and you are not physically saving updates to the target tables until either a high number of updates are pending or the apply job ends. Review the file description on the target (if iSeries) and set to force write ratio to 1
My money is on cause 1.If you perform a refresh before mirroring, ensure that you set the status to refresh and then start mirroring, CDC will refresh the tables and then automatically start mirroring from the correct position without further intervention from the operator.RegardsRobert
Re: DataMirror 6.1 in Iseries, Refresh is OK but problems with mirroring2013-03-06T19:08:00ZThis is the accepted answer. This is the accepted answer.
- Rphilo 2700013TF4
Re: DataMirror 6.1 in Iseries, Refresh is OK but problems with mirroring2013-03-06T21:57:52ZThis is the accepted answer. This is the accepted answer.
Robert: I have been analyzing the issue when I found this message:Table [TABLE NAME] in library [LIBRARY NAME] has no unique index assigned and an Update transaction has been sent from the source.In the knowledge database ( http://www-01.ibm.com/support/docview.wss?uid=swg21572524) I found the same issue posted with the solution:
- Rphilo 2700013TF4
Missing unique index on the target table (after which remapping has to be done).
Resolving the problem
Error can be fixed with the following steps:
1) Create an unique index on the target table.
2) Remap the source table to the target table in Management Console.It was confusing becouse the refresh process finished right, the insert during mirroring process finished right, but the update and delete were failed. I will tell you if this solution is true for this problem.thanks again!!!
Rphilo 2700013TF4547 Posts
Re: DataMirror 6.1 in Iseries, Refresh is OK but problems with mirroring2013-03-07T06:45:59ZThis is the accepted answer. This is the accepted answer.
Hi JorgeThe cause and suggested solution are certainly appropriate. I am glad that you found the reason, In most cases the source and target replication/subscription event logs will indicate the cause of any problems.In the present case, the refresh process will be successful without a unique index on the iSeries target as it is only doing inserts, and any insert mirrored from the source will be successful. However the first time you have an update or delete transaction, the iSeries target apply will fail as it needs the unique key to perform the look-up of the row to update or delete.RegardsRobert
- JorgeTuzi 270005T1GS