Based on other posting we know there is a hard limit of 64260. We have also updated the row count and array size from 2000/2000 (defaults) to 2300 and 575 and eliminated this warning.td_shaw_acct_trnsl,0: [IIS-CONN-TERA-005010] The estimated row length of 86 bytes multiplied by the array size of 2,000 is 172,000 which exceeds the maximum buffer size of 64,260
However, we have thousands of jobs to convert from DB2 to Teradata. I don't want to have to modify this value for every single job unless I really have to.
We have rerun the job with the defaults (2000, 2000) and the output appears to be correct. What is the impact of the warning? What happens if we leave the defaults for everything?
Brad.