The onstat -g dtc command displays statistics for the delete table cleaner. The delete table cleaner removes rows from the delete table when they are no longer needed.
onstat -g dtc ---- Delete Table Cleanup Status as of (1370357849) 2013/06/04 09:57:29 NOT RUNNING rows deleted = 0 lock timeouts = 0 cleanup interval = 300 list size = 2 last activity = (1370357769) 2013/06/04 09:56:09 Id Database Last Cleanup Time Replicate Server Last Log Change ========================================================= 000001 syscdr (1370356241) 2013/06/04 09:30:41 _ifx_qod_control g_gimli (1370356241) 2013/06/04 09:30:41
onstat -g dtc -- Delete Table Cleanup Status as of (1365761422) 2010/08/13 18:49:28 thread = 49rows deleted = 1 lock timeouts = 0 cleanup interval = 300 list size = 3 last activity = (1365761422) 2013/04/12 10:10:22 Id Database Last Cleanup Time Replicate Server Last Log Change ========================================================= 000001 test (1365762033) 2013/04/12 10:20:33 rep1 g_gimli (1365762033) 2013/04/12 10:20:33 rep1 g_theoden (1365762033) 2013/04/12 10:20:33
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.