ResUsage Tables are not collecting data

Database

ResUsage Tables are not collecting data

Hi, I am new to Teradata and currently working on project based on workload monitoring on Teradata database through data visualization. I am using Teradata Express 13 on Windows 7 OS. The problem I am facing is regarding data collection in ResUsage Tables. I have enabled RSS Table Logging and Data Collection Rate from CTL using command prompt. Data is successfully being collected in DBQL tables but not in ResUsage Tables. 

Kindly help as soon as possible.

3 REPLIES
Enthusiast

Re: ResUsage Tables are not collecting data

As you probably know , there is no relation between the collections on the two sets of tables.

As you mentioned RSS collection is controlled by CTL.

Please post the info from sc rss

Rglass

Enthusiast

Re: ResUsage Tables are not collecting data

Please post the command you used to enable RSS..

Re: ResUsage Tables are not collecting data

These are the list of commands I used sequentially in CTL.

>open command prompt

>ctl

>screen rss

>0=60 (0=RSS Collection rate)

>1=600 (1=Node Logging rate)

>2=600 (2=Vproc Logging rate)

>3=ON (3=SPMA)

>5=ON (5=SCPU)

>6=ON (6=SVPR)

>A=ON (A=SPDSK)

>B=ON (B=SVDSK)

>C=ON (C=SAWT)

>D=ON (D=SPS)

>wr (To write control GDO)