What are Resusage table logging rules

Database
Enthusiast

What are Resusage table logging rules

Hi,

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 ?

Thanks !

1 REPLY
Senior Apprentice

Re: What are Resusage table logging rules

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)

Dieter