TASM Reporting

Database

TASM Reporting

Hello All,

I am on TD 13.10 (VP 15) and would like to know whether we have any mechanishm to pull out the reports on TASM (like each workload CPU usage over the period of time).

Regards

Tags (1)
3 REPLIES
N/A

Re: TASM Reporting

If your logging, DBQL has this info.

Rglass

Re: TASM Reporting

Also, you can built reports based on TASM data/info using System Performance Monitor and Production Control API

http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/General_Reference/B035_1098_015K/...

Thanks!!

Re: TASM Reporting

Hello Robert,

I am using the following query

SELECT

wd.RuleName,

ql.collecttimestamp(date),

day_of_week(collecttimestamp),

sum(ampcputime),

COUNT(*)

FROM dbc.dbqlogtbl ql

INNER JOIN tdwm.RuleDefs wd

ON ql.wdid = wd.RuleId

GROUP BY 1,2,3;

As per my understanding, we can't find/derive the total CPU capacity instead it is always relative to the %CPU allocated for usage(80% in Use & 20% COD).

80% of CPU = ???? ampcputime [unknown]

I am after the hourly analyis of data like how many workloads were active and howmuch Ampcputime each were consuming.

Please suggest.