All Forums Database
jhjeanmichel 3 posts Joined 08/08
29 Aug 2008
DBC.DBQLogTbl V12

HiHow to calculate the time query IN V12. The field LastRespTime does not exist.Hudson

Fred 1096 posts Joined 08/04
29 Aug 2008

Use FirstRespTime. The actual "last response packet sent to host" time was not being captured in earlier releases; LastRespTime was nearly aways reported as being either the same as FirstRespTime or 0.01 second later.

monisiqbal 119 posts Joined 07/09
01 Sep 2008

Also, we don't always receive values for FirstRespTime.In case of erroneous queries or special Teradata queries e.g. BEGIN LOGGING we only have StartTime.

UpaMishra 35 posts Joined 01/08
05 Feb 2010

The field TotalCPUTime is also not present in dbc.DBQLogTbl table in TD12.Can anyone suggest, what is the alternative field for this.

You must sign in to leave a comment.