Archives of the TeradataForum

Message Posted: Mon, 23 Aug 2010 @ 21:16:48 GMT

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

Hi all,

Actually it might well be the "union all", I've had that before (and it was a pain to sort out).

Read through the plan VERY carefully and see if you're ending up with a spool file containing the query text from BOTH dbqlogtbl and dbqlsqltbl (or whatever the actual names are).

Also, remember that although the query text column is only 31KB long, it is a UNICODE column (certainly in the DBC tables) so the byte count for this alone can be up to 62KB. The worst thing that I found was that this is effectively a 'run time' error, meaning that whether or not you get the error depends on the data. With some data it works, with other data it won't.

Cheers,

Dave

Ward Analytics Ltd - Information in motion ( www.ward-analytics.com )

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