Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2006 @ 14:54:42 GMT

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

How are you determining that the query is PARSING?

20 minutes sounds like a long time, but is it possible that the utility you are using simply hasn't updated its display?

Another possibility is that someone else has obtained a write lock or an exclusive lock on one of the metadata tables the parser needs to parse your query. For example due to a backup? Depending upon your version of Teradata (i.e. an old version), a long running delete database might hold a lock? In this case, you would expect that most users would receive poor response times.

Does it always have this problem with Cognos? I'm assuming Cognos is using ODBC, if so, then it as far as Teradata is concerned, there is (should) be no distinction in how it is processed as you are using the same "access path" (i.e. ODBC).

I hope this helps

Glenn Mc

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