ACTIVATE_UC_OBJECT - with option 'WAIT' submitted by a Time Event : Remaining Entries in MQMEM

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

A Time EVENT is executed once with an MRT determined in his run time settings.
This time triggers in his Event process a followup job via ACTIVATE_UC_OBJECT with option 'WAIT'

!================================================================================
! Time Eevent to repeat the submission of &JOB#
!================================================================================
:IF SYS_STATE_ACTIVE("&JOB#") = "N"
: SET &ACTIVATE# = ACTIVATE_UC_OBJECT("&JOB#",WAIT,,,,PASS_VALUES)
!:ELSE
!:  PRINT '>>INFO: &JOB_TO_BE_ACTIVATED# is already active and will not be relaunched therefore.'
:ENDIF

When the Time EVENT reaches its MRT and its status is set to 1942 ended timeout.

It can be observed that related entries for this Event remain in the MQMEM table even though the EVENT has ended with Time_stamp4 set, with no entries left in EH.

SELECT * FROM MQMEM

1395004    SYS210    MEM.CVS0022JPEXEC_RTIMER_DOPSCRIPT AH_IDNR 0001855007    12176    (BLOB)    0    1
1395006    SYS210    MSV.MSV0022UCGENX_RPSCRIPT CV_MEMSVHANDLER 0000345520 cv-mem    6    (BLOB)    0    1
1395005    SYS210    SYN.SYP0022UCGENX_RPSCRIPT AKTX    AH_IDNR 0001855008    1408    (BLOB)    0    1
1395007    SYS210    MSV.MSV0022UCGENX_RPSCRIPT CV_MEMSVHANDLER 0000346802 cv-mem    1204    (BLOB)    0    1
1395008    SYS210    MEM.CVS0022UCGENX_RPSCRIPT AKTX    AH_IDNR 0001855008    162080    (BLOB)    0    1

These MQMEM entries are only deleted once the follow up jobs '&JOB#', that was launched by the Event via ACTIVATE_UC_OBJECT, has ended.

The following SQL shows the relation between MQMEM and the AH entry for this RunID

select MQ.MQMEM_PK, MQ.MQMEM_SYSTEM, MQ.MQMEM_TITLE, MQ.MQMEM_LEN, MQ.MQMEM_VERSION, MQ.MQMEM_MQSET, AC.AH_NAME, AC.AH_IDNR, AC.AH_STATUS, AC.AH_TIMESTAMP4 from MQMEM MQ, AH AC where SUBSTR(MQMEM_TITLE, 44, 10)=1855007 and AC.AH_IDNR=1855007 

1395004    POX210    MEM.CVS0022JPEXEC_RTIMER_DOPSCRIPT AH_IDNR 0001855007    12176    0    1    DRAP_ADR.DMADR.METHODE.ERG_ADR.DGHYP.EVT.OBP    1855007    1942    26-MAR-24

‘select * from EH where EH_AH_IDNR=1855007’ returns nothing. The EH table is empty for this RunID.

 

Environment

One Automation Engine 21

Cause

By Design see Resolution.

Resolution

This is behavior by design:

Since the processing script must be made persistent it will remain in the MQMEM table as long as the option 'WAIT' did not receive any return code from the ACTIVATE_UC_OBJECT call.