15.10 - Logging Resource Usage Data - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

You can retain collected data for subsequent historical analysis by enabling one or more resource usage tables for logging. The table and type of PM/API request are listed below. For details on the resource usage tables and pre-defined report macros, see Resource Usage Macros and Tables.

To control the resource usage logging option (for example, setting the logging rate and enabling one or more log tables or subtables), use the ctl utility. For instructions on using ctl, see Utilities.

 

PM/API Request

Table

MONITOR PHYSICAL RESOURCE

MONITOR PHYSICAL SUMMARY

ResUsageSpma

MONITOR PHYSICAL RESOURCE

MONITOR VIRTUAL RESOURCE

ResUsageShst

MONITOR VIRTUAL RESOURCE

MONITOR VIRTUAL SUMMARY

ResUsageSldv (Storage Devices)

EVENT STATUS

MONITOR WD

ResUsageSps

MONITOR VIRTUAL RESOURCE

MONITOR VIRTUAL SUMMARY

ResUsageSvpr

MONITOR VIRTUAL RESOURCE

ResUsageSvdsk