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.

Queryhistory stopped collecting data – Netezza

ISSUE:

Queryhistory stopped collecting data and all the directories under /nz/data/hist are empty.

CAUSE:

This can happen when the max storage limit is reached.

/nz/kit/log/alcapp->more alcapp.log
2016-01-23 20:32:08.759330 EDT (8231) Error: History Stored Data size: 1000 exceeds STORAGELIMIT (1000).
2016-01-23 20:32:08.765248 EDT (8231) Error: Disabling History Capture.

RESOLUTION:

To fix the issue you have to increase the maximum storage limit from 1000 MB (in this case) to a higher value. Maximum size allowed is 100GB.

Here are the steps that you can follow to increase the storage limit.