Archives of the TeradataForum
Message Posted: Mon, 31 Mar 2015 @ 00:49:57 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|