System Heartbeat Canary Query

Viewpoint
Enthusiast

System Heartbeat Canary Query

We have set the following as the canary query in the Viewpoint server:

Select * from DBC.dbcinfo;

What are the other canary queries available? Is it ok to set the following as canary queries:

1)SELECT 1;

2)SELECT CURRENT_DATE;

Kindly let me know.

Tags (2)
3 REPLIES
Enthusiast

Re: System Heartbeat Canary Query

Yes. You can run any query based on your requirement.

Teradata Employee

Re: System Heartbeat Canary Query

customer has multiple canary queries including a specific Aprimo canary query and wants to log to DBQL only for this Aprimo canary query. we didn't see a way to have different usernames for each different canary quereies

Teradata Employee

Re: System Heartbeat Canary Query

Each canary query can run under a different username.  In the Monitored Systems portlet (or Teradata Systems in Viewpoint 14.10 and earlier), first set up any usernames you want to use in the General screen.  Then when you go to the Canary Queries screen, you should see any usernames that you have set up in the dropdown labeled Login.