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.
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
These are the list of commands I used sequentially in CTL.
>open command prompt
>0=60 (0=RSS Collection rate)
>1=600 (1=Node Logging rate)
>2=600 (2=Vproc Logging rate)
>wr (To write control GDO)