In the past, I have used the below commands to purge Sentinel data. Now I am looking to schedule a prune cycle where I delete rows older than yyyymmdd. I would like to run this weekly or monthly and remove data older than say two years.
Or would it be better to develop a Sentinel Request and remove rows using the SQL delete statement?
./trkcmd purge -tabname “TrkTable(XFBLog,current)”
./trkcmd purge -tabname “TrkTable(XFBLog,historic)”
./trkcmd purge -tabname “TrkTable(XIBTRANSFER,current)”
./trkcmd purge -tabname “TrkTable(XIBTRANSFER,historic)”
./trkcmd purge -tabname “TrkTable(XIBMESSAGE,current)”
./trkcmd purge -tabname “TrkTable(XIBMESSAGE,historic)”
./trkcmd purge -tabname “TrkTable(XFBTRANSFER,current)”
./trkcmd purge -tabname “TrkTable(XFBTRANSFER,historic)”
./trkcmd purge -tabname “TrkTable(XFBMESSAGE,current)”
./trkcmd purge -tabname “TrkTable(XFBMESSAGE,historic)”
