Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 31 Mar 2015 @ 00:49:57 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Duplicate entries in DBQL
From:   Sravan.Bodla

Dear all,

I have noticed a strange issue today:

One of the stored procedures which are invoked by a 3rd party application is having duplicate (multiple) entries in DBC DBQ LOG TBL.

Duplicate (Ghost) entries in DBC DBQ LOG TBL:

There are 2 entries for every run with almost same time (or with a slight difference in 4-5 seconds or milli seconds).

The first entry has all the resource consumption and runtime details. Whereas the 2nd entry for the same procedure shows 0 elapse time, 0 total time , 0 spool and WD ID as null AND statement group ? Other No Group.

I have read a similar article from archives, but, this is very old and seems to be the issue on TD12.


Any idea, why there are multiple/dummy entries for the same execution??? We are presently on 14.10

Thank you in advance!


Sravan Kumar Bodla
TERADATA 12 DBA Certified
ITIL V3 Foundation Certified

  <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