Archives of the TeradataForum

Message Posted: Fri, 28 Aug 2003 @ 23:25:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Rohit,

Resnode report are obtainable by running DBC.ResNode or DBC.ResCPUByNode. First one will provide summarise stat across all Nodes, and second will provide CPU for individual Node.

Not longer ago I had to do similar exercise and I develop my own script which access DBC.ResUsageSpma table. Information on this table is enough to provide CPU&IO on Node/Amp. You have to spend some time understanding this table, and make sure the data collected hasn't been purged.

Below is my SQL I developed for my self but you may be able to leverage on it.

sel
      TheDate                  (Title 'Date') (CHAR (12))
     ,Substr(TheTime,1,5)      (Title 'Time HH:MM') (CHAR (5))
     ,PmaId                    (Title 'Node#' )
     ,SUM(CPUIdle)             (Title 'CPU Idle')
     ,SUM(CPUSysOh)            (Title 'CPU User IO waiting')
     ,SUM(CPUUServ)            (Title 'CPU User Exec')
     ,SUM(CPUUExec)            (Title 'CPU Busy Exec')
     ,SUM(FileAcqReads)        (Title 'IO read')
     ,SUM(FileWrites)          (Title 'IO write')
     ,SUM(FilePreReads)        (Title 'IO preRead')
from   DBC.ResUsageSpma
where TheDate =  '2003-08-29'
group  by 1,2,3
order by 1,2;

Regards

Ivan

	<Prev	Next>		<<First	<Prev	Next>	Last>>