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