Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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