Records lost while using TPUMP with MQ

Connectivity

Records lost while using TPUMP with MQ

Hi,

I have a TPUMP process that reads from MQ using the below parameters:

0006 .BEGIN LOAD

         ERRLIMIT 5000

         ERRORTABLE xyz

         CHECKPOINT 5

         SESSIONS 60

         TENACITY 1

         latency 0 notimerprocess

         SERIALIZE ON

         PACK 60;

I encountered an issue wherein the queue manager went down and TPUMP failed with the below erros:

**** 15:32:17 UTY4015 Access module error '34' received during 'read' operation

     on record number '1056766': 'Teradata Websphere MQ AMOD/PIDMMain(!ERROR!):

     Reason code = 2009.  Function MQGET failed.'

**** 15:33:25 UTY4014 Access module error '34' received during 'close'

     operation: 'Teradata Websphere MQ AMOD/CloseAll(!ERROR!): MQCLOSE failed.

     QName = S20.EPOS_TRANLOG.STHDBT. Reason code = 2009.'

I have a reconciliation flow through which I was able to find out that there were several records that were missed when compared to the source. It means that even though I have a CHECKPOINT of 5 minutes, the data was lost.

Have you encountered this issue before and is there a way to avoid it?

Thanks,

Raunak