Is there any view/table where i can get information about - Resusage table logging rules ? Like you have DBC.DBQLRULESV to get information about dbql rules enabled, where do i find Resusage table logging information ?
There's no view for it, you must use a command line utility, e.g.
xdbw -> get resource/logtable/sumlogtable
ctl -> screen rss
If you only want to know the collection/logging rate you might use:
SELECT VprocLogging, VprocMonitor FROM TABLE (MonitorVirtualSummary()) AS t1;
or Teradata Systems -> Monitor Rates in Viewpoint (from the Admin menu)