We are in the process now of moving our canaries, which are implemented using the PDCR Toolkit, over to Viewpoint. Our concern was there is logic in the PDCR script that looks to make sure there isn't another canary of the same type running before it runs another one. Is my understanding correct that Viewpoint has this same check built into it to wait until the last canary3 finishes before it kicks off another canary3? And if that wait time exceeds 30 minutes, it then aborts both canary3 processes? The one that is running as well as the one waiting?
I read through the Teradata Viewpoint Users Guide in the Canary section and saw nothing on this topic.
Viewpoint will only allow one execution of a particular canary query at a time. If it becomes time to run the canary query again and the previous execution is still running, the next execution will be delayed until the previous execution completes. As soon as it completes, the query will be submitted to Teradata.
As for timeouts, the system heartbeat has a timeout of 1 minute. All other canary queries have a timeout of 30 minutes. The JDBC driver will abort any query that exceeds these timeouts. Only the running query will be aborted. The next query is run as it would normally run.
Thanks! Just curious, the query that is aborted after the 30 minute timeout...does it appear in Viewpoint's chart? I believe DBQL only captures queries that complete...correct?
The query that is aborted after the timeout will not appear in the Viewpoint Canary Response Time portlet. You will find an exception in the dcs log on the Viewpoint server. Viewpoint does its own timing of the canary queries and does not rely upon DBQL for this data. However, I believe you are correct that DBQL does not currently capture aborted queries.
I want ti run a macro - PDCRINFO.CapCanarySUMRT_Rpt. This macro will give me max and avg canary response time. I see that this macro uses PDCRDATA."Canary_Hst" and PDCRDATA."ShiftHour". However, both of these tables are empty.
Can anyone help me to identify how these tables are populated ? Do i need to enable logging for these ? I tried to see if canary query logging can be enabled, however, i dont see any option to log the canary query.