DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
dwh_user



Group memberships:
Premium Members

Joined: 18 Oct 2018
Posts: 11
Location: Sydney
Points: 122

Post Posted: Mon Jul 15, 2019 2:25 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
The nvarchar(max) field of sql server is read as LOB by datastage ODBC stage ([IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]). In order to read the data it suggests to change the array size to 1 for LOB and this change highly impacts the performance.

Is there any solution/workaround for reading nvarchar(max) fields without impacting the performance?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54534
Location: Sydney, Australia
Points: 295710

Post Posted: Mon Jul 22, 2019 6:59 pm Reply with quote    Back to top    

You may be able to increase array size by one or two, but are quickly likely to run into the maximum number of bytes that the ODBC driver can handle. That figure can be tuned by including MAX_F ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
dwh_user



Group memberships:
Premium Members

Joined: 18 Oct 2018
Posts: 11
Location: Sydney
Points: 122

Post Posted: Tue Jul 23, 2019 2:00 am Reply with quote    Back to top    

Hi ray.wurlod

Thanks for the details. I updated the array size to 2 and the ODBC stage still fails. It fails for any sizes other than 1.

I will try to configure MAX_FETCH_BUFF in windows and see if it works.
Appreciate your help with this.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours