DBC.DBQLogTbl V12

Database

DBC.DBQLogTbl V12

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

Re: DBC.DBQLogTbl V12

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.
Enthusiast

Re: DBC.DBQLogTbl V12

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.
Enthusiast

Re: DBC.DBQLogTbl V12

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