Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Onstat -a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g dtc Statistics for the delete table cleaner

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           = 49 
      rows 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.