Page 1 of 1
array size while inserting
Posted: Thu Sep 04, 2008 3:40 am
by DS_FocusGroup
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
Posted: Thu Sep 04, 2008 7:19 am
by chulett
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.
Posted: Fri Sep 05, 2008 12:26 am
by DS_FocusGroup
How did we come to this conclusion
. it the array length always fixed or can we change it ?
Posted: Fri Sep 05, 2008 12:27 am
by chulett
Based on what you posted, of course, and a little bit of that 'rithmetic stuff.
Posted: Fri Sep 05, 2008 12:37 am
by DS_FocusGroup
"How" to change the array size is still the question....................
Posted: Fri Sep 05, 2008 7:24 am
by chulett
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.
Posted: Fri Sep 05, 2008 2:24 pm
by toshea
There is a property in the Teradata Connector called Array size. Reduce its value to get rid of the warning.
Posted: Fri Sep 05, 2008 3:35 pm
by shershahkhan
Wouldn't it be nice to increase the buffer size?
Posted: Fri Sep 05, 2008 3:55 pm
by toshea
The Teradata Parallel Transporter API has a hard limit of 64260 for its buffer size. You cannot increase it (although you can decrease it).
Posted: Sun Sep 07, 2008 4:02 am
by DS_FocusGroup
thanks all!