How to enable ResUsage

Question :

How to enable ResUsage

Environment/Conditions/Configuration

TDBMS 14.xx or higher

Answer :

Before you enable the resource usage tables, determine which tables apply to the resource usage macros you want to run.

For more information, you can refer to manual Resource Usage Macros and Tables.

Additional Information

The default for RSS Collection Rate, Node Logging Rate, and Vproc Logging Rate is 600

Example:

# 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: On
(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 : Off (3) SCPU: On
(4) SVPR : On (5) IVPR : Off (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