Per this article:
"A Teradata Database system is considered DOWN in the health equation if any of the following conditions occurs:
Is there any way to change the maximum allowed response time on the System Heartbeat canary query (sel * from dbcinfo)? We've seen a few instances where we received "health down" alert for the heartbeat query when the system isn't actually down. Sometimes other system conditions (which we'd like to alert on separately) do cause a heartbeat response of greater than 60 seconds, triggering the "health down" alert. We want to increase this value to something that would raise the likelihood that the system is actually down when we receive the alert. For sake of example let's say 120 seconds. So: Can we do this? And if so, where?
The canary query response time threshold cannot be modified today. However, the query can certainly be modified. Certainly there's some query that can complete in under 60 seconds on your system, right? It might be beneficial to switch to a single AMP query and ensure it isn't delayed by TASM.
It's in Monitored Systems (or Teradata Systems if you are running Viewpoint 14.10 or earlier).
That was easy enough, thanks Steve. Basically 'sel * from dbc.dbase where databasenamei = 'dbc'' - with row-level access lock. Will always go to same amp but is at least single amp.