Archives of the TeradataForum

Message Posted: Sat, 18 Jul 2015 @ 14:22:10 GMT

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

Hi All,

We want to know, How much time system is spending in each state (TASM System Conditions).

In all we have 3 system states let?s say Normal, Orange and Red defined in TASM. Ideally system should be in Normal state but in case of degradation system changes it?s state (Depending on state rule) from normal to Orange or Red and revert when all becomes normal.

But I am unable to fetch time spent by system in each state.. Please guide me .. !!!

I have checked dbc.TDWMEventlog table , it stores all info. of WD changes but none for sysconID.

Thanks in Advance .. !!!

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