Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Aug 2013 @ 10:05:21 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Canary query metrics
From:   sobhan.pratim

Hello experts,

Previously we get Canary Query response times from dbcmngr.loghearbeat table

Now Viewpoint does not access the dbcmngr.logheartbeat table. Viewpoint opens its own JDBC connection to the monitored Teradata database and executes the canary query itself. The default system heartbeat canary query runs "SELECT * FROM DBC.DBCINFO". When Viewpoint runs the query, it captures the elapsed time to execute the query and then stores this value into its own database for later display in portlets such as Canary Response Times.

But I am yet to find any meaningful explanation on which portlet holds canary metrics.

When i go to Viewpoint config to find details how they setup VP server, i do not get any meaningful definition from the following:

     replace macro console.dbscontrol as (;);
     replace macro console.aborthost as (;);
     replace macro console.config as (;);
     replace macro console.checktableb as (;);
     replace macro dumplocklog as (;);
     replace macro console.ferret as (;);
     replace macro console.xgtwglobal as (;);
     replace macro console.lokdisp as (;);
     replace macro console.cnscons as (;);
     replace macro console.schmon as (;);
     replace macro console.qryconfig as (;);
     replace macro console.qrysessn as (;);
     replace macro console.rcvmanager as (;);
     replace macro console.showlocks as (;);
     replace macro console.tdwmdmp as (;);
     replace macro console.vprocmanager as (;);
     etc. etc.

Also i see that Viewpoint monitors TDWM. Probably i need to look into TDWM views to find any meaningful metrics that can give me Canary metrics.

Any comments?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020