Buffer Size

Post by **admin** » Sun Jul 29, 2001 6:20 am

Which buffer?

If youre talking about the result set buffer for an ODBC stage type, the default is a maximum of 400 columns or 8192 bytes, whichever comes first. These can be varied using MAXFETCHCOLS and MAXFETCHBUFF, respectively, in the uvodbc.config file. If its not this buffer, please post a more precise question.

====================

I need to know the max buffer size for DataStage 4.0 and how or if it can be increased.

Thanks
Lisa Hamilton

Post by **admin** » Sun Sep 02, 2001 4:37 am

Where do I go to increase the buffer size on the datastage server to correct this error:

SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.

Post by **admin** » Sun Sep 02, 2001 10:48 pm

In uvodbc.config file in the project directory on the server, change MAXFETCHBUFF to a larger value. Its default value is 8192; maybe double it.

-----Original Message-----
From: Roosa, Mike [mailto:Mike.Roosa@getronics.com]
Sent: Sunday, 02 September 2001 14:38
To: datastage-users@oliver.com
Subject: Buffer Size

Where do I go to increase the buffer size on the datastage server to correct this error:

SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.