Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 25 Apr 2005 @ 17:51:35 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Fetch Time from DBQL
From:   Ballinger, Carrie

This email from me back in early April is not correct, so I wanted to fix it.

Although the original idea behind having a LastRespTime column in the DBQLogTbl was to reflect the time the last response packet was sent, that is not done at this time. DBQL lives and records its information from within the dispatcher. In the case of response processing, all responses after the first packet are handled by the BYNET, and DBQL does not currently have visibility into what time the final packet was sent.

Sorry for any confusion. - Carrie

-----Original Message-----
From: Ballinger, Carrie
Sent: Tuesday, April 05, 2005 12:03 PM
Subject: Re: Fetch Time from DBQL

You should be able to subtract firstresptime from lastresptime if what you mean by fetch time is the time it took to return the answer set.

firstresptime -- Timestamp when the first response packet was sent to the host.

Lastresptime -- Timestamp when the last response packet was sent to the host.

Thanks, -Carrie

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023