Archives of the TeradataForum
Message Posted: Tue, 05 Apr 2005 @ 07:50:00 GMT
Subj: | | Recording downtime |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Monday, April 04, 2005 20:10 -->
We have a requirement to report on downtime for all our databases each month. In Oracle we use startup and shutdown triggers to write entries
in a log table. For Ingres we scan the dbms log for specific startup and shutdown messages.
How can we track downtime in Teradata? I've tried looking through the software_event_log and while there are many events logged when a shutdown
and a restart are done - I couldn't put my finger on any one that looked specifically like a shutdown or a startup message.
Any suggestions?
Not that we have much downtime at all for Teradata - but it is taken down occasionally for patching etc.
|