array size while inserting

DS_FocusGroup · Post by **DS_FocusGroup** » Thu Sep 04, 2008 3:40 am

Hi, Anyone please let me know why we get this warning ? what is the default array size ? what is the maximum we can use? where do we change this from ?

Code: Select all

Insert_TD,0: [IIS-CONN-TERA-005010] The estimated row length of 41 bytes multiplied by the array size of 2,000 is 82,000 which exceeds the maximum buffer size of 64,260

chulett · Post by **chulett** » Thu Sep 04, 2008 7:19 am

Seems to me, everything is in the error message you posted. Your array size needs to be no more than 1567 with that row length to ensure the buffer size is not exceeded.

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Sep 05, 2008 12:26 am

How did we come to this conclusion

. it the array length always fixed or can we change it ?

chulett · Post by **chulett** » Fri Sep 05, 2008 12:27 am

Based on what you posted, of course, and a little bit of that 'rithmetic stuff.

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Sep 05, 2008 12:37 am

"How" to change the array size is still the question....................

chulett · Post by **chulett** » Fri Sep 05, 2008 7:24 am

How can anyone answer that for you unless they are clairvoyent? You haven't given any details like database, stage, etc. We can guess Teradata, but that's about it.

toshea · Post by **toshea** » Fri Sep 05, 2008 2:24 pm

There is a property in the Teradata Connector called Array size. Reduce its value to get rid of the warning.

shershahkhan · Post by **shershahkhan** » Fri Sep 05, 2008 3:35 pm

Wouldn't it be nice to increase the buffer size?

toshea · Post by **toshea** » Fri Sep 05, 2008 3:55 pm

The Teradata Parallel Transporter API has a hard limit of 64260 for its buffer size. You cannot increase it (although you can decrease it).

DS_FocusGroup · Post by **DS_FocusGroup** » Sun Sep 07, 2008 4:02 am

thanks all!