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 

Comments