For instructions on starting the Database Window, see Teradata Vantage™ - Database Utilities, B035-1102.
To enable RSS logging from DBW:
- Open the Supvr window.
- Set the Node Logging Rate using this database command.
SET RESOURCE { LOGGING | LOG } number
where number is the number of seconds.
A rate of zero disables the logging function. - Specify the table you want to enable logging to using this database command.
SET LOGTABLE { tablename | ALL } { ON | OFF }
where tablename is the suffix part of ResUsage Xxxx. For example, for the DBC.ResUsageSpma table, the tablename would be “Spma.”
After the table is enabled for logging, you can log rows in Summary Mode. For more information, see Summary Mode.
To log rows in Summary Mode, you must enable the table specified in both the RSS Table Logging Enable group and in the RSS Summary Mode Enable group. - (Optional) Enable Summary Mode on the table specified using this command.
SET SUMLOGTABLE tablename { ON | OFF }