All Forums Viewpoint
Kishore_1 208 posts Joined 03/10
14 Apr 2014
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.

 

cr255014 23 posts Joined 01/14
22 Apr 2014

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

jjudge 3 posts Joined 07/09
30 Jul 2014

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

stever 149 posts Joined 08/09
30 Jul 2014

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.

You must sign in to leave a comment.