Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.

teradataforum.com/teradata/20101029_194841.htm

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


Thank you in advance!

Sravan.

Sravan Kumar Bodla
TERADATA DBA
TERADATA 12 DBA Certified
ITIL V3 Foundation Certified



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