Data Replication

 View Only
  • 1.  Failure receiving Journal Entry - IDR on DB2 for IBM i

    Posted Mon January 23, 2023 09:22 AM
    Good day:

    I am receiving a failure in IDR saying "Error occurred while receiving journal entry 00000002313952248684 from journal OMSLIBRAMD/OMSJRMN86 using journal receiver JRNLIBRAMD/OMS86N6506."

    In IBM i, that journal entry corresponds to a table that is not part of the subscription. I mean, that specific journal entry is for table PCCLIBRAMD.PCCFFHSTCN, and tables involved in the failing subscription are PCCLIBRAMD.PCCFFDGOPT, WWWLIBRAMD.WWWFFMADSP, and WWWLIBRAMD.WWWFFNVDSP.

    Is there any reason why a journal entry corresponding to another table can affect a subscription?

    Thanks.


    ------------------------------
    Daniel Jose Lema Guanziroli
    ------------------------------


  • 2.  RE: Failure receiving Journal Entry - IDR on DB2 for IBM i

    Posted Mon January 23, 2023 09:54 AM
    Daniel

    The scraper has to process all the entries in the journal receivers to determine if an particular entry is in scope. 

    All the message is doing is telling you which journal entry the scraper was processing when some error (possibly unrelated to the journal entry) occurred on the source or target.

    To get to the bottom of what the message means:
    1) Look at the message detail in the event log. It will give you the job name. job number and job user for the scraper job. Use the iSeries WRKJOB command to look at the job log to see if there is some issue identified in the job log.
    2) Look on the source and target event log for any errors at that time that would explain why replication had an issue.

    regards

    Robert

    ------------------------------
    Robert Philo
    ------------------------------



  • 3.  RE: Failure receiving Journal Entry - IDR on DB2 for IBM i

    Posted Thu January 26, 2023 12:06 PM
    Daniel
    Thanks for informing me of the issue with RGZPFM and the PTF

    ------------------------------
    Robert Philo
    ------------------------------