How to enable ResUsage in Teradata
The default for RSS Collection Rate, Node Logging Rate, and Vproc Logging Rate is 600 (Teradata, 2016)
SMP001-01:~ # ctl
> 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
> 1=on
> 3=on
> 4=on
> 6=on
> 7=on
> 8=on
> 9=on
> a=on
> b=on
> write
CTL: Control GDO successfully written.
> screen rss
(0) Node Logging Rate : 600 sec
RSS Table Logging Enable
(1) SPMA : On (2) IPMA : On (3) SCPU: On
(4) SVPR : On (5) IVPR : On (6) SLDV: On (7) SHST: On
(8) SPDSK: On (9) SVDSK: On (A) SAWT: On (B) SPS : On
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
References
Teradata. (2016, 07 22). Retrieved from http://knowledge.teradata.com/KCS/id/KCS002135