DBC.DBQLogTbl V12

[jhjeanmichel]

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

[Fred]

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]

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]

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