Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: BTEQ error - maximum byte count
From:   James Grogan

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.


James Grogan

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023