Archives of the TeradataForum

Message Posted: Wed, 16 Nov 2011 @ 13:39:56 GMT

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

Hi Trevor

The request buffer size is 1Mb, IIRC.? BTEQ script size is not limited, as far as I know.

It would seem that you are sending a single SQL request of over 1Mb? that sounds too big for an individual Collect Stats step. Assuming you have not missed off a semicolon or two somewhere during SQL generation, is it possible that you are you exporting the generated COLLSTATS.SQL script without closing it, then trying to read it in the same job?? I have fallen foul of this before now.

I used something like this

     .EXPORT DATA DDNAME=collstats.sql?

when I should have used this:

     .EXPORT DATA DDNAME=collstats.sql,CLOSE?

This was on MP-RAS, so YMMV.

Just a thought.

BRgds

James Grogan

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