Teradata error: Request size exceeds maximum
Moderators: chulett, rschirm, roy
Teradata error: Request size exceeds maximum
Hi
Recently we have migrated to Datastage 8.5 and also to Teradata .I am using the Teradata connector stage and want to load the data into table . This table has 118 columns and it is failing :
Copy_3_of_Teradata_Connector_85,0: RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum.
As per this discusstion I have added :
APT_TERA_64K_BUFFERS=1
APT_TERA_64K_BUFFERSIZE=64000
and reran the job .The job failed again .Can somebody help us in resolving the issue .
Recently we have migrated to Datastage 8.5 and also to Teradata .I am using the Teradata connector stage and want to load the data into table . This table has 118 columns and it is failing :
Copy_3_of_Teradata_Connector_85,0: RDBMS code 350: CLI2: REQOVFLOW(350): Request size exceeds maximum.
As per this discusstion I have added :
APT_TERA_64K_BUFFERS=1
APT_TERA_64K_BUFFERSIZE=64000
and reran the job .The job failed again .Can somebody help us in resolving the issue .
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: Teradata error: Request size exceeds maximum
Is this an insert/update or select?
How big is the buffer in your teradata system (has nothing to do with APT settings you have set)?
Is your row size (number of bytes) * the array size greater than the teradata buffer settings?
I have been working with a Teradata 13 system which has a buffer of roughly 1,000,000 bytes. On wide rows, using the immediate setting it is fairly easy to cross the Teradata buffer threshold. One option is to use batch which is not hindered by the Teradata buffer.
How big is the buffer in your teradata system (has nothing to do with APT settings you have set)?
Is your row size (number of bytes) * the array size greater than the teradata buffer settings?
I have been working with a Teradata 13 system which has a buffer of roughly 1,000,000 bytes. On wide rows, using the immediate setting it is fairly easy to cross the Teradata buffer threshold. One option is to use batch which is not hindered by the Teradata buffer.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Decrease your array size so that the (bytes per row * array size) is less than your buffer ... Or switch to bulk load instead of immediate which is not affected by the Teradata buffer.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Thanks Keith,
Reducing the Array size and records counts worked for and my job is running without below two parameters as well.
APT_TERA_64K_BUFFERS=1
APT_TERA_64K_BUFFERSIZE=64000
Thanks and regards,
Kunal Shah
APT_TERA_64K_BUFFERS=1
APT_TERA_64K_BUFFERSIZE=64000
Thanks and regards,
Kunal Shah
Best Regards,
Kunal Shah
Kunal Shah