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