Skip to content

How to turn on logging for system usage (ResUsage tables in DBC database)?

You will see number of system level usage tables in DBC database. These tables start with ResUsage*. These tables exist to save system usage
information but the usage logging is not eanbled by default.

Below are the steps as how you can enable RSS table logging (resusage* tables logging):

1) Login to Teradata host (Any cop node)
2) Run “ctl” to enter into ctl utility

# ctl
>
3) Now run “screen RSS” to see the current system usage logging settings

> screen RSS

(0) Node Logging Rate : 600 sec

RSS Table Logging Enable

(1) SPMA : Off (2) IPMA : Off (3) SCPU: Off
(4) SVPR : Off (5) IVPR : Off (6) SLDV: Off (7) SHST: Off
(8) SPDSK: Off (9) SVDSK: Off (A) SAWT: Off (B) SPS : Off

RSS Summary Mode Enable

Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off Summarize SPS : Off
4) Here if you want to enable logging for AMP worker task (SWAT) then run below command

> A = on
5) Again run “screen RSS” to see the new system usage logging settings. You will see its on. But to save this setting you have to run command in
step 6.

> screen RSS

(0) Node Logging Rate : 600 sec

RSS Table Logging Enable

(1) SPMA : Off (2) IPMA : Off (3) SCPU: Off
(4) SVPR : Off (5) IVPR : Off (6) SLDV: Off (7) SHST: Off
(8) SPDSK: Off (9) SVDSK: Off (A) SAWT: on (B) SPS : Off

RSS Summary Mode Enable

Summarize SPMA: Off Summarize IPMA : Off (C) Summarize SCPU : Off
(D) Summarize SVPR: Off (E) Summarize IVPR : Off (F) Summarize SLDV : Off
(G) Summarize SHST: Off (H) Summarize SPDSK: Off (I) Summarize SVDSK: Off
(J) Summarize SAWT: Off Summarize SPS : Off
6) Run below command to save the setting

> write
CTL: Control GDO successfully written.