We are designing a process that will alert when unexpectedly high latency timing occurs. We are considering a task that runs on a one second interval. We are considering using fields MONITOR_TIME, RECVQ, and END2END_LATENCY from the APPLY_MON DB2 table.
Does anyone know if an APPLY_MON row is inserted at start of UOW and then updated when the commit is processed, or if the APPLY_MON row is only inserted at the end of commit processing for the UOW?
Does anyone know if an APPLY_MON row is inserted at start of UOW and then updated when the commit is processed, or if the APPLY_MON row is only inserted at the end of commit processing for the UOW?